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)
|