On 30/04/2018 23:26, PeeDub wrote:
OK, I updated the jdbc driver (had to do it by writing a wget download
command rather than using apt-get) and Syncope to 2.0.8, and I'm still
getting the error.
I would have expected that: I suggested to upgrade the JDBC driver *and*
PostgreSQL itself: the version you are using is extremely old.
You can download the Ubuntu packages for 9.6 from
https://www.postgresql.org/download/linux/ubuntu/
HTH
Regards.
I should note that I am ordering by a schema attribute (which works on the
Syncope REST endpoint.)
Here's the full stack trace:
org.apache.syncope.common.lib.SyncopeClientException: DataIntegrityViolation
[ERROR: UNION types integer and text cannot be matched
Position: 158 {prepstmnt 1156037144 SELECT u.any_id,sva.stringvalue AS
email FROM (SELECT DISTINCT any_id FROM user_search WHERE id IS NOT NULL) u,
(SELECT * FROM user_search_attr UNION SELECT * FROM user_search_null_attr)
sva WHERE u.any_id=sva.any_id AND sva.schema_id='email' AND u.any_id IN
(SELECT any_id FROM user_search WHERE realm_id IN (SELECT id AS realm_id
FROM Realm WHERE id=?)) ORDER BY email ASC} [code=0, state=42804]]
at
org.apache.syncope.common.lib.SyncopeClientException.build(SyncopeClientException.java:37)
at
org.apache.syncope.client.lib.RestClientExceptionMapper.checkSyncopeClientCompositeException(RestClientExceptionMapper.java:143)
at
org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:53)
at
org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:42)
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:313)
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:876)
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:789)
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.invoke(ClientProxyImpl.java:235)
at com.sun.proxy.$Proxy64.search(Unknown Source)
at com.gal.ums.services.UsersService.getUsers(UsersService.java:65)
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
