talk@lists.collectionspace.org
WE HAVE SUNSET THIS LISTSERV - Join us at collectionspace@lyrasislists.org
View all threadsv1.12 on OS X 10.6.8: can't load vocabs, etc. "ERROR: operator does not exist: character varying = bigint"
Noob CSspace installer here! Could use some help!
I am having a problem installing and configuring 1.12 on Mac OS X 10.6.8.
I believe I am installing and starting the services as specified in the
documentation, but I cannot load vocabularies (or the sample data), nor
can I save records.
Install seems to work fine, EXCEPT towards the end of the CS Server
startup the log says:
[...]
10:58:35,932 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- Packages waiting for a deployer ---
org.jboss.deployment.DeploymentInfo@e231c69 {
url=file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
}
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch:
file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
altDD: null
lastDeployed: 1323889115932
lastModified: 1323889115000
mbeans:
[blah blah blah...]
However, the server does start and I can login with the default credentials.
Then, when I try to do almost anything (e.g. load vocabularies, create
records, etc.), I get exceptions in the log indicating a query failure of
some sort. They are all of the following flavor:
- In a browser, I visit: http://localhost:8180/cspace-services/vocabularies
(it asks for login and password, I enter "admin@..." and "Administrator")
result:
List request failed: org.nuxeo.ecm.core.api.ClientException: Failed to
execute query: ERROR: operator does not exist: character varying = bigint
in the log I see:
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Vocabulary WHERE collectionspace_core:tenantId = 1 AND ecm:isProxy =
0 ORDER BY collectionspace_core:updatedAt DESC
When I try to load vocabularies, the core vocabs appear to load OK (I
get messages in my browser indicating that they are being created), but
error messages are being generated in the logs, e.g.
11:01:33,728 ERROR [STDERR] 2011-12-14 11:01:33,728 (202192)
[http-0.0.0.0-8180-6] ERROR
org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:
Got error : List request failed: org.nuxeo.ecm.core.api.ClientException:
Failed to execute query: ERROR: operator does not exist: character varying
= bigint
11:01:33,731 ERROR [STDERR] 2011-12-14 11:01:33,731 (202195)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: need to create Instance
person-person
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: Instance person-person
Created
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: testing Authority
location
11:01:34,241 ERROR [LocationAuthorityResource]
org.collectionspace.services.location.LocationAuthorityResource detail:
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
-- message: org.nuxeo.ecm.core.api.ClientException: Failed to execute
query: ERROR: operator does not exist: character varying = bigint
-- Causes: org.nuxeo.ecm.core.api.ClientException::Failed to execute
query: ERROR: operator does not exist: character varying = bigint
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Locationauthority WHERE collectionspace_core:tenantId = 1 AND
(locationauthorities_common:shortIdentifier='location') AND ecm:isProxy =
0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Invalid query:
SELECT * FROM Locationauthority WHERE collectionspace_core:tenantId = 1
AND (locationauthorities_common:shortIdentifier='location') AND
ecm:isProxy = 0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.postgresql.util.PSQLException. message: ERROR: operator does not
exist: character varying = bigint
-- Stack Trace:
-- org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDocCSID(RepositoryJavaClientImpl.java:394)
...first 4 lines. 256 more.
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
Suggestions would be welcome, thanks,
John
"ERROR: operator does not exist: character varying = bigint" might be
resolvable via:
On Wed, Dec 14, 2011 at 11:33 AM, jblowe@berkeley.edu wrote:
Noob CSspace installer here! Could use some help!
I am having a problem installing and configuring 1.12 on Mac OS X 10.6.8.
I believe I am installing and starting the services as specified in the
documentation, but I cannot load vocabularies (or the sample data), nor
can I save records.
Install seems to work fine, EXCEPT towards the end of the CS Server
startup the log says:
[...]
10:58:35,932 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- Packages waiting for a deployer ---
org.jboss.deployment.DeploymentInfo@e231c69 {
url=file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
}
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch:
file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
altDD: null
lastDeployed: 1323889115932
lastModified: 1323889115000
mbeans:
[blah blah blah...]
However, the server does start and I can login with the default credentials.
Then, when I try to do almost anything (e.g. load vocabularies, create
records, etc.), I get exceptions in the log indicating a query failure of
some sort. They are all of the following flavor:
- In a browser, I visit: http://localhost:8180/cspace-services/vocabularies
(it asks for login and password, I enter "admin@..." and "Administrator")
result:
List request failed: org.nuxeo.ecm.core.api.ClientException: Failed to
execute query: ERROR: operator does not exist: character varying = bigint
in the log I see:
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Vocabulary WHERE collectionspace_core:tenantId = 1 AND ecm:isProxy =
0 ORDER BY collectionspace_core:updatedAt DESC
When I try to load vocabularies, the core vocabs appear to load OK (I
get messages in my browser indicating that they are being created), but
error messages are being generated in the logs, e.g.
11:01:33,728 ERROR [STDERR] 2011-12-14 11:01:33,728 (202192)
[http-0.0.0.0-8180-6] ERROR
org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:
Got error : List request failed: org.nuxeo.ecm.core.api.ClientException:
Failed to execute query: ERROR: operator does not exist: character varying
= bigint
11:01:33,731 ERROR [STDERR] 2011-12-14 11:01:33,731 (202195)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: need to create Instance
person-person
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: Instance person-person
Created
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: testing Authority
location
11:01:34,241 ERROR [LocationAuthorityResource]
org.collectionspace.services.location.LocationAuthorityResource detail:
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
-- message: org.nuxeo.ecm.core.api.ClientException: Failed to execute
query: ERROR: operator does not exist: character varying = bigint
-- Causes: org.nuxeo.ecm.core.api.ClientException::Failed to execute
query: ERROR: operator does not exist: character varying = bigint
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Locationauthority WHERE collectionspace_core:tenantId = 1 AND
(locationauthorities_common:shortIdentifier='location') AND ecm:isProxy =
0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Invalid query:
SELECT * FROM Locationauthority WHERE collectionspace_core:tenantId = 1
AND (locationauthorities_common:shortIdentifier='location') AND
ecm:isProxy = 0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.postgresql.util.PSQLException. message: ERROR: operator does not
exist: character varying = bigint
-- Stack Trace:
-- org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDocCSID(RepositoryJavaClientImpl.java:394)
...first 4 lines. 256 more.
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
Suggestions would be welcome, thanks,
John
Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org
Thanks, Aron, that did the trick! (I did RTFM, but somehow missed this
particular troubleshooting tip...)
Cheers,
John
"ERROR: operator does not exist: character varying = bigint" might be
resolvable via:
On Wed, Dec 14, 2011 at 11:33 AM, jblowe@berkeley.edu wrote:
Noob CSspace installer here! Could use some help!
I am having a problem installing and configuring 1.12 on Mac OS X
10.6.8.
I believe I am installing and starting the services as specified in
the
documentation, but I cannot load vocabularies (or the sample data), nor
can I save records.
Install seems to work fine, EXCEPT towards the end of the CS Server
startup the log says:
[...]
10:58:35,932 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- Packages waiting for a deployer ---
org.jboss.deployment.DeploymentInfo@e231c69 {
url=file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
}
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch:
file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
altDD: null
lastDeployed: 1323889115932
lastModified: 1323889115000
mbeans:
[blah blah blah...]
However, the server does start and I can login with the default
credentials.
Then, when I try to do almost anything (e.g. load vocabularies, create
records, etc.), I get exceptions in the log indicating a query failure
of
some sort. They are all of the following flavor:
- In a browser, I visit:
http://localhost:8180/cspace-services/vocabularies
(it asks for login and password, I enter "admin@..." and
"Administrator")
result:
List request failed: org.nuxeo.ecm.core.api.ClientException: Failed to
execute query: ERROR: operator does not exist: character varying =
bigint
in the log I see:
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT
*
FROM Vocabulary WHERE collectionspace_core:tenantId = 1 AND ecm:isProxy
0 ORDER BY collectionspace_core:updatedAt DESC
When I try to load vocabularies, the core vocabs appear to load OK (I
get messages in my browser indicating that they are being created), but
error messages are being generated in the logs, e.g.
11:01:33,728 ERROR [STDERR] 2011-12-14 11:01:33,728 (202192)
[http-0.0.0.0-8180-6] ERROR
org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:
Got error : List request failed: org.nuxeo.ecm.core.api.ClientException:
Failed to execute query: ERROR: operator does not exist: character
varying
= bigint
11:01:33,731 ERROR [STDERR] 2011-12-14 11:01:33,731 (202195)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: need to create
Instance
person-person
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: Instance
person-person
Created
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: testing Authority
location
11:01:34,241 ERROR [LocationAuthorityResource]
org.collectionspace.services.location.LocationAuthorityResource detail:
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
-- message: org.nuxeo.ecm.core.api.ClientException: Failed to execute
query: ERROR: operator does not exist: character varying = bigint
-- Causes: org.nuxeo.ecm.core.api.ClientException::Failed to execute
query: ERROR: operator does not exist: character varying = bigint
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT
*
FROM Locationauthority WHERE collectionspace_core:tenantId = 1 AND
(locationauthorities_common:shortIdentifier='location') AND ecm:isProxy
0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Invalid query:
SELECT * FROM Locationauthority WHERE collectionspace_core:tenantId = 1
AND (locationauthorities_common:shortIdentifier='location') AND
ecm:isProxy = 0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.postgresql.util.PSQLException. message: ERROR: operator does not
exist: character varying = bigint
-- Stack Trace:
-- org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDocCSID(RepositoryJavaClientImpl.java:394)
...first 4 lines. 256 more.
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
Suggestions would be welcome, thanks,
John
Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org
Aron,
Another Postgres installation question:
I'm receiving this error upon Ant create_db:
create_base_db:
BUILD FAILED
/Users/rjaffe/Documents/IST_One-IST/IST_Departments/DataServices/DS_CollectionSpace/Code/ucb-pahma/trunk/services/v1.12/build.xml:223: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "root", database "root", SSL off
I have edited pg_hba.conf to include user 'postgres'. Somehow, my system wants to run as root. How do I change it to run as postgres?
Thanks,
Rick
On Dec 14, 2011, at 11:42 AM, Aron Roberts wrote:
"ERROR: operator does not exist: character varying = bigint" might be
resolvable via:
On Wed, Dec 14, 2011 at 11:33 AM, jblowe@berkeley.edu wrote:
Noob CSspace installer here! Could use some help!
I am having a problem installing and configuring 1.12 on Mac OS X 10.6.8.
I believe I am installing and starting the services as specified in the
documentation, but I cannot load vocabularies (or the sample data), nor
can I save records.
Install seems to work fine, EXCEPT towards the end of the CS Server
startup the log says:
[...]
10:58:35,932 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- Packages waiting for a deployer ---
org.jboss.deployment.DeploymentInfo@e231c69 {
url=file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
}
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch:
file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
altDD: null
lastDeployed: 1323889115932
lastModified: 1323889115000
mbeans:
[blah blah blah...]
However, the server does start and I can login with the default credentials.
Then, when I try to do almost anything (e.g. load vocabularies, create
records, etc.), I get exceptions in the log indicating a query failure of
some sort. They are all of the following flavor:
- In a browser, I visit: http://localhost:8180/cspace-services/vocabularies
(it asks for login and password, I enter "admin@..." and "Administrator")
result:
List request failed: org.nuxeo.ecm.core.api.ClientException: Failed to
execute query: ERROR: operator does not exist: character varying = bigint
in the log I see:
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Vocabulary WHERE collectionspace_core:tenantId = 1 AND ecm:isProxy =
0 ORDER BY collectionspace_core:updatedAt DESC
When I try to load vocabularies, the core vocabs appear to load OK (I
get messages in my browser indicating that they are being created), but
error messages are being generated in the logs, e.g.
11:01:33,728 ERROR [STDERR] 2011-12-14 11:01:33,728 (202192)
[http-0.0.0.0-8180-6] ERROR
org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:
Got error : List request failed: org.nuxeo.ecm.core.api.ClientException:
Failed to execute query: ERROR: operator does not exist: character varying
= bigint
11:01:33,731 ERROR [STDERR] 2011-12-14 11:01:33,731 (202195)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: need to create Instance
person-person
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: Instance person-person
Created
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: testing Authority
location
11:01:34,241 ERROR [LocationAuthorityResource]
org.collectionspace.services.location.LocationAuthorityResource detail:
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
-- message: org.nuxeo.ecm.core.api.ClientException: Failed to execute
query: ERROR: operator does not exist: character varying = bigint
-- Causes: org.nuxeo.ecm.core.api.ClientException::Failed to execute
query: ERROR: operator does not exist: character varying = bigint
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Locationauthority WHERE collectionspace_core:tenantId = 1 AND
(locationauthorities_common:shortIdentifier='location') AND ecm:isProxy =
0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Invalid query:
SELECT * FROM Locationauthority WHERE collectionspace_core:tenantId = 1
AND (locationauthorities_common:shortIdentifier='location') AND
ecm:isProxy = 0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.postgresql.util.PSQLException. message: ERROR: operator does not
exist: character varying = bigint
-- Stack Trace:
-- org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDocCSID(RepositoryJavaClientImpl.java:394)
...first 4 lines. 256 more.
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
Suggestions would be welcome, thanks,
John
Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org
Oh, I see... it's set in my environmental variables.
Never mind,
Rick
On Dec 14, 2011, at 1:52 PM, Rick Jaffe wrote:
Aron,
Another Postgres installation question:
I'm receiving this error upon Ant create_db:
create_base_db:
BUILD FAILED
/Users/rjaffe/Documents/IST_One-IST/IST_Departments/DataServices/DS_CollectionSpace/Code/ucb-pahma/trunk/services/v1.12/build.xml:223: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "root", database "root", SSL off
I have edited pg_hba.conf to include user 'postgres'. Somehow, my system wants to run as root. How do I change it to run as postgres?
Thanks,
Rick
On Dec 14, 2011, at 11:42 AM, Aron Roberts wrote:
"ERROR: operator does not exist: character varying = bigint" might be
resolvable via:
On Wed, Dec 14, 2011 at 11:33 AM, jblowe@berkeley.edu wrote:
Noob CSspace installer here! Could use some help!
I am having a problem installing and configuring 1.12 on Mac OS X 10.6.8.
I believe I am installing and starting the services as specified in the
documentation, but I cannot load vocabularies (or the sample data), nor
can I save records.
Install seems to work fine, EXCEPT towards the end of the CS Server
startup the log says:
[...]
10:58:35,932 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- Packages waiting for a deployer ---
org.jboss.deployment.DeploymentInfo@e231c69 {
url=file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
}
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch:
file:/usr/local/share/jboss-4.2.3.GA/server/cspace/deploy/data/bundles.ids
altDD: null
lastDeployed: 1323889115932
lastModified: 1323889115000
mbeans:
[blah blah blah...]
However, the server does start and I can login with the default credentials.
Then, when I try to do almost anything (e.g. load vocabularies, create
records, etc.), I get exceptions in the log indicating a query failure of
some sort. They are all of the following flavor:
- In a browser, I visit: http://localhost:8180/cspace-services/vocabularies
(it asks for login and password, I enter "admin@..." and "Administrator")
result:
List request failed: org.nuxeo.ecm.core.api.ClientException: Failed to
execute query: ERROR: operator does not exist: character varying = bigint
in the log I see:
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Vocabulary WHERE collectionspace_core:tenantId = 1 AND ecm:isProxy =
0 ORDER BY collectionspace_core:updatedAt DESC
When I try to load vocabularies, the core vocabs appear to load OK (I
get messages in my browser indicating that they are being created), but
error messages are being generated in the logs, e.g.
11:01:33,728 ERROR [STDERR] 2011-12-14 11:01:33,728 (202192)
[http-0.0.0.0-8180-6] ERROR
org.collectionspace.chain.csp.persistence.services.connection.ReturnedDocument:
Got error : List request failed: org.nuxeo.ecm.core.api.ClientException:
Failed to execute query: ERROR: operator does not exist: character varying
= bigint
11:01:33,731 ERROR [STDERR] 2011-12-14 11:01:33,731 (202195)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: need to create Instance
person-person
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: Instance person-person
Created
11:01:34,060 ERROR [STDERR] 2011-12-14 11:01:34,060 (202524)
[http-0.0.0.0-8180-6] INFO
org.collectionspace.chain.csp.webui.misc.WebReset: testing Authority
location
11:01:34,241 ERROR [LocationAuthorityResource]
org.collectionspace.services.location.LocationAuthorityResource detail:
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
-- message: org.nuxeo.ecm.core.api.ClientException: Failed to execute
query: ERROR: operator does not exist: character varying = bigint
-- Causes: org.nuxeo.ecm.core.api.ClientException::Failed to execute
query: ERROR: operator does not exist: character varying = bigint
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT *
FROM Locationauthority WHERE collectionspace_core:tenantId = 1 AND
(locationauthorities_common:shortIdentifier='location') AND ecm:isProxy =
0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Invalid query:
SELECT * FROM Locationauthority WHERE collectionspace_core:tenantId = 1
AND (locationauthorities_common:shortIdentifier='location') AND
ecm:isProxy = 0
org.nuxeo.ecm.core.api.WrappedException::Exception:
org.postgresql.util.PSQLException. message: ERROR: operator does not
exist: character varying = bigint
-- Stack Trace:
-- org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDocCSID(RepositoryJavaClientImpl.java:394)
...first 4 lines. 256 more.
org.collectionspace.services.common.document.DocumentException:
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR:
operator does not exist: character varying = bigint
at
org.collectionspace.services.nuxeo.client.java.RepositoryJavaClientImpl.findDoc(RepositoryJavaClientImpl.java:373)
Suggestions would be welcome, thanks,
John
Talk mailing list
Talk@lists.collectionspace.org
http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org