data provider delete needs to clean up child data

XMLWordPrintable

    • Type: New Feature
    • Resolution: Fixed
    • Priority: Minor
    • 5.15.0
    • Affects Version/s: None
    • Component/s: None
    • None

      2024-11-27T11:30:48,713: [DefaultQuartzScheduler_Worker-7] ERROR OtherJobBase$2.callback(451) - [] - Error occurred while running job: OTHER_JOB_PROVIDER_umichAAcurrterm_FULL
      java.lang.RuntimeException: sql: delete from grouper_data_provider where INTERNAL_ID = ? ,
          at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2696) ~[grouperClient-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.executeSql(GcDbAccess.java:2725) ~[grouperClient-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.deleteFromDatabase(GcDbAccess.java:826) ~[grouperClient-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.dataField.GrouperDataProviderDao.delete(GrouperDataProviderDao.java:91) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.dataField.GrouperDataEngine.syncDataProviders(GrouperDataEngine.java:557) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.app.dataProvider.GrouperDataProviderLogic.syncFull(GrouperDataProviderLogic.java:84) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.app.dataProvider.GrouperDataProviderSyncType$1.sync(GrouperDataProviderSyncType.java:31) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.app.dataProvider.GrouperDataProviderSync.runSync(GrouperDataProviderSync.java:192) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.dataField.GrouperDataProviderFullSyncJob.loadFull(GrouperDataProviderFullSyncJob.java:105) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.dataField.GrouperDataProviderFullSyncJob$1.callback(GrouperDataProviderFullSyncJob.java:46) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.dataField.GrouperDataProviderFullSyncJob.run(GrouperDataProviderFullSyncJob.java:35) ~[grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.app.loader.OtherJobBase$2.callback(OtherJobBase.java:443) [grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063) [grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132) [grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099) [grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:394) [grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:378) [grouper-5.14.0.jar:5.14.0]
          at edu.internet2.middleware.grouper.app.loader.GrouperDaemonJob.execute(GrouperDaemonJob.java:57) [grouper-5.14.0.jar:5.14.0]
          at org.quartz.core.JobRunShell.run(JobRunShell.java:202) [quartz-2.3.2.jar:?]
          at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?]
      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (GROUPER_DEV.GROUPER_DATA_FIELD_ASSIGN_FK_3) violated - child record found
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc10-19.19.0.0.jar:19.19.0.0.0]
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc10-19.19.0.0.jar:19.19.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc10-19.19.0.0.jar:19.19.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) ~[ojdbc10-19.19.0.0.jar:19.19.0.0.0]
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) ~[ojdbc10-19.19.0.0.jar:19.19.0.0.0]
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc10-19.19.0.0.jar:19.19.0.0.0]
          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatem...
       

            Assignee:
            Vivek Sachdeva
            Reporter:
            Chris Hyzer
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: