You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by Francesco Chicchiriccò <il...@apache.org> on 2018/05/02 06:23:47 UTC
Re: Order by descending/ascending
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/
Re: Order by descending/ascending
Posted by Francesco Chicchiriccò <il...@apache.org>.
On 03/05/2018 17:00, PeeDub wrote:
> OK, done.
>
> Issue is here: https://issues.apache.org/jira/browse/SYNCOPE-1308
Thanks.
Regards.
--
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/
Re: Order by descending/ascending
Posted by PeeDub <pf...@greenarrowlabs.com>.
OK, done.
Issue is here: https://issues.apache.org/jira/browse/SYNCOPE-1308
-----
Paul Fullbright
--
Sent from: http://syncope-user.1051894.n5.nabble.com/
Re: Order by descending/ascending
Posted by Francesco Chicchiriccò <il...@apache.org>.
On 02/05/2018 18:19, PeeDub wrote:
> OK, that was the problem. Our Postgres was *TOO* new. I downgraded to 9.6 and
> it works.
Ah ok, now I see.
> You might check out running on Postgres 10.3.
Sure, I will run the whole test suite against the latest PostgreSQL 10: would you mind opening an issue on JIRA about the problem you have found?
Regards.
--
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/
Re: Order by descending/ascending
Posted by PeeDub <pf...@greenarrowlabs.com>.
OK, that was the problem. Our Postgres was *TOO* new. I downgraded to 9.6 and
it works.
You might check out running on Postgres 10.3.
-----
Paul Fullbright
--
Sent from: http://syncope-user.1051894.n5.nabble.com/
Re: Order by descending/ascending
Posted by PeeDub <pf...@greenarrowlabs.com>.
We are already using the very latest postgres: 10.3. This is coming from the
official dockerhub image.
-----
Paul Fullbright
--
Sent from: http://syncope-user.1051894.n5.nabble.com/