You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "fabio martelli (JIRA)" <ji...@apache.org> on 2018/10/11 08:41:00 UTC
[jira] [Resolved] (SYNCOPE-1382) Failure specifying push task
filters including db column mapped as integer
[ https://issues.apache.org/jira/browse/SYNCOPE-1382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
fabio martelli resolved SYNCOPE-1382.
-------------------------------------
Resolution: Fixed
> Failure specifying push task filters including db column mapped as integer
> --------------------------------------------------------------------------
>
> Key: SYNCOPE-1382
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1382
> Project: Syncope
> Issue Type: Improvement
> Components: console
> Affects Versions: 2.0.10, 2.1.1
> Reporter: fabio martelli
> Assignee: fabio martelli
> Priority: Major
> Fix For: 2.0.11, 2.1.2, 3.0.0
>
>
> It seems that case insensitive approach is used for boolean fields mapped on integer columns.
> Failures are experienced with boolean on postgresql. See exception below.
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: function lower(integer) does not exist
> Hint: No function matches the given name and argument types. You might need to add explicit type casts.
> Position: 132 \{prepstmnt 2084826893 SELECT COUNT(any_id) FROM (SELECT u.any_id FROM (SELECT DISTINCT any_id FROM anyObject_search_attr WHERE ((schema_id='enabled' AND LOWER (booleanvalue)=LOWER(?) AND any_id IN ( SELECT DISTINCT any_id FROM anyObject_search_attr WHERE schema_id='enabled' AND LOWER (booleanvalue)=LOWER(?))) AND any_id IN ( SELECT DISTINCT any_id FROM anyObject_search WHERE type_id=?))) u WHERE u.any_id IN (SELECT any_id FROM anyObject_search WHERE realm_id IN (SELECT id AS realm_id FROM Realm WHERE id=? OR id=?))) count_any_id} [code=0, state=42883]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218) ~[openjpa-lib-2.4.3.jar:2.4.3]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:202) ~[openjpa-lib-2.4.3.jar:2.4.3]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58) ~[openjpa-lib-2.4.3.jar:2.4.3]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1117) ~[openjpa-lib-2.4.3.jar:2.4.3]
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-lib-2.4.3.jar:2.4.3]
> at org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedStatement.executeQuery(PostgresDictionary.java:1011) ~[openjpa-jdbc-2.4.3.jar:2.4.3]
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) ~[openjpa-lib-2.4.3.jar:2.4.3]
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1800) ~[openjpa-jdbc-2.4.3.jar:2.4.3]
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:258) ~[openjpa-lib-2.4.3.jar:2.4.3]
> at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeQuery(SQLStoreQuery.java:317) ~[openjpa-jdbc-2.4.3.jar:2.4.3]
> at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeQuery(SQLStoreQuery.java:220) ~[openjpa-jdbc-2.4.3.jar:2.4.3]
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1011) ~[openjpa-kernel-2.4.3.jar:2.4.3]
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:869) ~[openjpa-kernel-2.4.3.jar:2.4.3]
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:800) ~[openjpa-kernel-2.4.3.jar:2.4.3]
> at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:541) ~[openjpa-kernel-2.4.3.jar:2.4.3]
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274) ~[openjpa-persistence-2.4.3.jar:2.4.3]
> at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:290) ~[openjpa-persistence-2.4.3.jar:2.4.3]
> at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:318) ~[openjpa-persistence-2.4.3.jar:2.4.3]
> at org.apache.syncope.core.persistence.jpa.dao.JPAAnySearchDAO.doCount(JPAAnySearchDAO.java:143) ~[syncope-core-persistence-jpa-2.0.10.jar:2.0.10]
> at org.apache.syncope.core.persistence.jpa.dao.AbstractAnySearchDAO.count(AbstractAnySearchDAO.java:129) ~[syncope-core-persistence-jpa-2.0.10.jar:2.0.10]
> at org.apache.syncope.core.provisioning.java.pushpull.PushJobDelegate.doExecuteProvisioning(PushJobDelegate.java:229) ~[syncope-core-provisioning-java-2.0.10.jar:?]
> at org.apache.syncope.core.provisioning.java.pushpull.PushJobDelegate.doExecuteProvisioning(PushJobDelegate.java:57) ~[syncope-core-provisioning-java-2.0.10.jar:?]
> at org.apache.syncope.core.provisioning.java.pushpull.AbstractProvisioningJobDelegate.doExecute(AbstractProvisioningJobDelegate.java:560) ~[syncope-core-provisioning-java-2.0.10.jar:?]
> at org.apache.syncope.core.provisioning.java.job.AbstractSchedTaskJobDelegate.execute(AbstractSchedTaskJobDelegate.java:120) ~[syncope-core-provisioning-java-2.0.10.jar:2.0.10]
> at sun.reflect.GeneratedMethodAccessor1753.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141]
> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) ~[spring-aop-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) ~[spring-tx-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) ~[spring-tx-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:64) ~[syncope-core-persistence-jpa-2.0.10.jar:2.0.10]
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.18.RELEASE.jar:4.3.18.RELEASE]
> at com.sun.proxy.$Proxy615.execute(Unknown Source) ~[?:?]
> at org.apache.syncope.core.provisioning.java.job.TaskJob$1.exec(TaskJob.java:86) ~[syncope-core-provisioning-java-2.0.10.jar:2.0.10]
> ... 5 more
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)