Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-5072

Sql Provisioner: Empty where clause

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0, 4.8.0
    • 4.5.5
    • provisioning
    • 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.

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            bert.beelindgren@at.internet2.edu Bert Bee-Lindgren (gatech.edu)
            Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: