Details
-
Bug
-
Resolution: Fixed
-
Major
-
4.5.5
-
None
Description
Our Incremental Provisioning to SQL is failing with a bogus target-system query:
select group_name, subject_id, subject_source_id from grouper.memberships_from_grouper where ( )
(vx85briy): at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2361)
(vx85briy): at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1759)
(vx85briy): at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1633)
(vx85briy): at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1608)
(vx85briy): at edu.internet2.middleware.grouper.app.sqlProvisioning.SqlProvisionerCommands.retrieveObjectsColumnFilter(SqlProvisionerCommands.java:217)
(vx85briy): at edu.internet2.middleware.grouper.app.sqlProvisioning.SqlProvisioningDao.retrieveMemberships(SqlProvisioningDao.java:166)
(vx85briy): at edu.internet2.middleware.grouper.app.sqlProvisioning.SqlProvisioningDao.retrieveMemberships(SqlProvisioningDao.java:106)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.retrieveMembershipsHelper(GrouperProvisionerTargetDaoAdapter.java:1921)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter$18.callLogic(GrouperProvisionerTargetDaoAdapter.java:2331)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter$18.callLogic(GrouperProvisionerTargetDaoAdapter.java:2325)
(vx85briy): at edu.internet2.middleware.grouper.util.GrouperUtil.executorServiceSubmit(GrouperUtil.java:14111)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.retrieveMembershipObjectsPlural(GrouperProvisionerTargetDaoAdapter.java:2341)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.retrieveMembershipObjects(GrouperProvisionerTargetDaoAdapter.java:2274)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.retrieveMemberships(GrouperProvisionerTargetDaoAdapter.java:1956)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.retrieveIncrementalData(GrouperProvisionerTargetDaoAdapter.java:1043)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningLogicIncremental.retrieveIncrementalTargetMemberships(GrouperProvisioningLogicIncremental.java:2215)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningLogic.provisionIncremental(GrouperProvisioningLogic.java:1145)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningType$3.provision(GrouperProvisioningType.java:100)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningLogic.provision(GrouperProvisioningLogic.java:77)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioner.provision(GrouperProvisioner.java:835)
(vx85briy): at edu.internet2.middleware.grouper.app.provisioning.ProvisioningConsumer.dispatchEventList(ProvisioningConsumer.java:91)
(vx85briy): at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:503)
(vx85briy): at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:261)
(vx85briy): at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$6.runJob(GrouperLoaderType.java:676)
(vx85briy): at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:541)
(vx85briy): at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:345)
(vx85briy): at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
(vx85briy): at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
I'll attach our config and a debug-level log.