SQL sync full job with incorrect eternal system gives error "Shouldnt get here"

XMLWordPrintable

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Minor
    • 4.19.0, 5.20.0
    • Affects Version/s: None
    • Component/s: None
    • None

      java.lang.RuntimeException: configDatabaseFrom: DB2-ro, configEnabled: true, configDatabaseTo: grouper, configTableFrom: (SELECT UIN, PID, TSTAMP from PB.PERSON WHERE UIN IS NOT NULL AND PID IS NOT NULL), configTableTo: pb_pids, configColumns: *, configPrimaryKeyColumns: UIN, finalLog: true, state: init, sync: sqlTableSync, provisionerName: uicPersonPidSync, syncType: fullSyncFull, exception: java.lang.RuntimeException: Error finding metadata for 'select * from (SELECT UIN, PID, TSTAMP from PB.PERSON where 1!=1 and UIN IS NOT NULL AND PID IS NOT NULL)' in database: 'DB2-ro'
      	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
      	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
      	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
      	at edu.internet2.middleware.grouperClient.util.GrouperClientCommonUtils.createRuntimeExceptionWithMessage(GrouperClientCommonUtils.java:478)
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:466)
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:301)
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveTableMetadataFromDatabase(GcTableSyncTableMetadata.java:287)
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveTableMetadataFromCacheOrDatabase(GcTableSyncTableMetadata.java:269)
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableBean.configureMetadata(GcTableSyncTableBean.java:58)
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.sync(GcTableSync.java:311)
      	at edu.internet2.middleware.grouper.app.tableSync.TableSyncOtherJob.run(TableSyncOtherJob.java:71)
      	at edu.internet2.middleware.grouper.app.loader.OtherJobBase$2.callback(OtherJobBase.java:441)
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      	at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:394)
      	at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:378)
      	at edu.internet2.middleware.grouper.app.loader.GrouperDaemonJob.execute(GrouperDaemonJob.java:57)
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      Caused by: java.lang.RuntimeException: sql: select * from (SELECT UIN, PID, TSTAMP from PB.PERSON where 1!=1 and UIN IS NOT NULL AND PID IS NOT NULL), 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2665)
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:360)
      	... 15 more
      Caused by: java.lang.RuntimeException: Error connecting to: null
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.connection(GcDbAccess.java:2335)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2605)
      	... 16 more
      Caused by: java.lang.RuntimeException: Error calling constructor and 'connection' on edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.connectionGetFromPool(GcDbAccess.java:2384)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.connectionHelper(GcDbAccess.java:3047)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.connection(GcDbAccess.java:2318)
      	... 17 more
      Caused by: java.lang.RuntimeException: Problems with db: DB: user: null, url: null, connectionName: DB2-ro
      	at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:449)
      	at jdk.internal.reflect.GeneratedMethodAccessor522.invoke(Unknown Source)
      	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
      	at edu.internet2.middleware.grouperClient.util.GrouperClientCommonUtils.invokeMethod(GrouperClientCommonUtils.java:2787)
      	at edu.internet2.middleware.grouperClient.util.GrouperClientCommonUtils.callMethod(GrouperClientCommonUtils.java:2745)
      	at edu.internet2.middleware.grouperClient.util.GrouperClientCommonUtils.callMethod(GrouperClientCommonUtils.java:2922)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.connectionGetFromPool(GcDbAccess.java:2379)
      	... 19 more
      Caused by: java.lang.RuntimeException: Shouldnt get here: 'DB2-ro'
      	at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.configTypeWithDatabaseConnection(GrouperLoaderDb.java:645)
      	at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.initProperties(GrouperLoaderDb.java:461)
      	at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:331)
      	... 26 more
      , queryCount: 2, tookMillis: 5, took: 00:00:00.005
      	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.sync(GcTableSync.java:592)
      	at edu.internet2.middleware.grouper.app.tableSync.TableSyncOtherJob.run(TableSyncOtherJob.java:71)
      	at edu.internet2.middleware.grouper.app.loader.OtherJobBase$2.callback(OtherJobBase.java:441)
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      	at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:394)
      	at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:378)
      	at edu.internet2.middleware.grouper.app.loader.GrouperDaemonJob.execute(GrouperDaemonJob.java:57)
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      

            Assignee:
            Chris Hyzer
            Reporter:
            Chad Redman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: