syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Tsvetkov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SYNCOPE-1304) Order Groups by userOwner throws DataIntegrityViolation exception
Date Mon, 23 Apr 2018 13:35:01 GMT

     [ https://issues.apache.org/jira/browse/SYNCOPE-1304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexander Tsvetkov updated SYNCOPE-1304:
----------------------------------------
    Labels: orderby  (was: )

> Order Groups by userOwner throws DataIntegrityViolation exception
> -----------------------------------------------------------------
>
>                 Key: SYNCOPE-1304
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-1304
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 2.0.8
>            Reporter: Alexander Tsvetkov
>            Priority: Major
>              Labels: orderby
>             Fix For: 2.0.8
>
>
> In java code when I search groups with request
>   
> {code:java}
> {"realm":"/","details":null,"fiql":null,"page":1,"size":50,"orderBy":"userOwner DESC"}
> {code}
> I got exception:
> {noformat}
> 16:06:33.151 [http-nio-8090-exec-7] ERROR o.a.s.c.l.RestClientExceptionMapper - Exception
thrown
> org.apache.syncope.common.lib.SyncopeClientException: DataIntegrityViolation [ERROR:
column sv.userowner does not exist
> Position: 17 {prepstmnt 950849233 SELECT u.any_id,sv.userOwner FROM (SELECT DISTINCT
any_id FROM group_search WHERE id IS NOT NULL) u,group_search sv WHERE u.any_id=sv.any_id
AND u.any_id IN (SELECT any_id FROM group_search WHERE realm_id IN (SELECT id AS realm_id
FROM Realm WHERE id=? OR id=? OR id=? OR id=?)) ORDER BY sv.userOwner DESC} [code=0, state=42703]]
> 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.$Proxy118.search(Unknown Source) 
> {noformat}
> The same problem is reproduced in swagger.
> Request: 
> {noformat}
> http://localhost:8080/syncope/rest/groups?page=1&size=20&orderby=userOwner&realm=%2F
> {noformat}
> Response:
> {noformat}
> {
>   "status": 409,
>   "type": "DataIntegrityViolation",
>   "elements": [
>     "ERROR: column sv.userowner does not exist\n  Position: 17 {prepstmnt 1083964178
SELECT u.any_id,sv.userOwner FROM (SELECT DISTINCT any_id FROM group_search WHERE id IS NOT
NULL) u,group_search sv WHERE u.any_id=sv.any_id AND u.any_id IN (SELECT any_id FROM group_search
WHERE realm_id IN (SELECT id AS realm_id FROM Realm WHERE id=? OR id=? OR id=? OR id=?)) ORDER
BY sv.userOwner ASC} [code=0, state=42703]"
>   ]
> }
> {noformat}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message