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

oracle timestamp error on sql sync

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • None
    • None

    Description

      finalLog: true, state: retrieveData, sync: sqlTableSync, provisionerName: ngss_fac_staff, syncType: fullSyncFull, databaseFrom: pennCommunity, tableFrom: pcdadmin.ngss_fac_staff_view, databaseTo: pennCommunity, tableTo: pcdadmin.ngss_fac_staff_v, exception: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Not expecting value: class oracle.sql.TIMESTAMP,finalLog: true, state: retrieveData, sync: sqlTableSync, provisionerName: ngss_fac_staff, syncType: fullSyncFull, databaseFrom: pennCommunity, tableFrom: pcdadmin.ngss_fac_staff_view, databaseTo: pennCommunity, tableTo: pcdadmin.ngss_fac_staff_v, exception: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Not expecting value: class oracle.sql.TIMESTAMP,sql: select max( LAST_UPDATED )  from pcdadmin.ngss_fac_staff_view,  at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2228) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1639) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1513) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.select(GcDbAccess.java:1463) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype.captureCurrentMaxIncrementalIndexIfNeeded(GcTableSyncSubtype.java:719) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype.access$100(GcTableSyncSubtype.java:30) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype$1.retrieveData(GcTableSyncSubtype.java:53) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.sync(GcTableSync.java:393) at edu.internet2.middleware.grouper.app.tableSync.TableSyncOtherJob.run(TableSyncOtherJob.java:106) at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:205) at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:163) 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: java.lang.RuntimeException: Not expecting value: class oracle.sql.TIMESTAMP,sql: select max( LAST_UPDATED )  from pcdadmin.ngss_fac_staff_view,  at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.getFieldValue(GcBoundDataConversionImpl.java:163) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.addObjectToList(GcDbAccess.java:2370) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.access$100(GcDbAccess.java:37) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess$2.callback(GcDbAccess.java:1659) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess$2.callback(GcDbAccess.java:1639) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2224) ... 13 moreCaused by: java.lang.RuntimeException: Not expecting value: class oracle.sql.TIMESTAMP at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.getFieldValue(GcBoundDataConversionImpl.java:159) ... 18 more, queryCount: 6, tookMillis: 6708, took: 0:00:06.708java.lang.RuntimeException: finalLog: true, state: retrieveData, sync: sqlTableSync, provisionerName: ngss_fac_staff, syncType: fullSyncFull, databaseFrom: pennCommunity, tableFrom: pcdadmin.ngss_fac_staff_view, databaseTo: pennCommunity, tableTo: pcdadmin.ngss_fac_staff_v, exception: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Not expecting value: class oracle.sql.TIMESTAMP,sql: select max( LAST_UPDATED )  from pcdadmin.ngss_fac_staff_view,  at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2228) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1639) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1513) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.select(GcDbAccess.java:1463) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype.captureCurrentMaxIncrementalIndexIfNeeded(GcTableSyncSubtype.java:719) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncSubtype.access$100(G

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: