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

sql cache group error

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • None
    • None

    Description

      grouper;grouper_error.log;${ENV};${USERTOKEN};2024-03-15T04:29:00,111: [DefaultQuartzScheduler_Worker-1] ERROR GrouperLoaderJob.execute(363) - [] - Error running up job
      java.lang.RuntimeException: Error in loader job: null, status: ERROR, check logs: method: dispatchEventList, eventCount: 4, lastSequenceAvailable: 79022, wrongAttributeName: 1, removeCacheCount: 2, addCacheCount: 1, eventsSkipped: 1, tookMillis: 16Error: java.lang.RuntimeException: Couldn't process any records: type: consumer, finalLog: true, state: sendToPublisher, consumerName: sqlCacheGroup, currentSequenceNumber: null, filterInvalidEventTypesSize: 22, elFilter: event.eventType eq 'ATTRIBUTE_ASSIGN_VALUE_ADD' || event.eventType eq 'ATTRIBUTE_ASSIGN_VALUE_DELETE', skippedEventsDueToExpressionLanguageCount: 669, publisherClass: edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache, exception: java.lang.RuntimeException: sql:  select  from OBJECT;, args: ArrayList size: 4: [0]: 1710449243087000
      [1]: etc:sqlCacheable:sqlCacheableListName
      [2]: 9776abcbcb8b42359eaa9a781bdcee8d
      [3]: 58a626505bc94d368bb6a6ece3a8a099
       
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2433)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1795)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1669)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1644)
      	at edu.internet2.middleware.grouper.sqlCache.SqlCacheGroupDao.retrieveNonexistingAttributeAssignments(SqlCacheGroupDao.java:296)
      	at edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache.dispatchEventList(EsbPublisherSqlCache.java:157)
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:511)
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1055)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1124)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1091)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      Caused by: java.lang.RuntimeException: Problem attaching param index: 1, param: '1710449243087000'
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:70)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2393)
      	... 17 more
      Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
      	at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:70)
      	at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:144)
      	at org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1113)
      	at org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:344)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setLong(NewProxyPreparedStatement.java:197)
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:45)
      	... 18 more
      , tookMillis: 22
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:603)
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1055)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1124)
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1091)
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
       
       

      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: