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

sql table provisioner: errors showing as success

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • 2.4.0
    • provisioning
    • None
    • tier docker

    Description

      an error shows as success - this error goes with following log entry

      fullSync: true, key: EXT_IDENTITY, finalLog: true, state: retrieveToGroupingsOfBatch, databaseFrom: shib, tableFrom: EXT_IDENTITY, databaseTo: grouper, tableTo: uf_EXT_IDENTITY, totalCountFrom: 12938, fromGroupingUniqueValues: 12938, groupingsToDelete: 0, numberOfBatches: 2, currentBatch: 0, rowsSelectedFrom: 10000, exception: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SENSITIVE, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01 from grouper.uf_EXT_IDENT' at line 1,fullSync: true, key: EXT_IDENTITY, finalLog: true, state: retrieveToGroupingsOfBatch, databaseFrom: shib, tableFrom: EXT_IDENTITY, databaseTo: grouper, tableTo: uf_EXT_IDENTITY, totalCountFrom: 12938, fromGroupingUniqueValues: 12938, groupingsToDelete: 0, numberOfBatches: 2, currentBatch: 0, rowsSelectedFrom: 10000, exception: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SENSITIVE, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01 from grouper.uf_EXT_IDENT' at line 1,sql: select REGISTRY_ID, SEQUENCE_NO, LINKED_ID, UFID, PRINCIPAL, PRIN_RSC_TYP, FRIENDLY_NAME, HONORIFIC_PREFIX, GIVEN_NAME, MIDDLE_NAME, FAMILY_NAME, HONORIFIC_SUFFIX, DISPLAY_NAME, EMAIL, PHONE_NUMBER, PHONE_TYPE, CREATED_TS, INACTIVE_TS, END_TS, STATUS, SENSITIVE, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01 from grouper.uf_EXT_IDENTITY where REGISTRY_ID >= ? and REGISTRY_ID <= ? at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:1901) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.retrieveDataBatchFromDb(GcTableSync.java:968) at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.fullSync(GcTableSync.java:804) at edu.internet2.middleware.grouper.app.tableSync.TableSyncOtherJob.run(TableSyncOtherJob.java:60) 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.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SENSITIVE, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01 from grouper.uf_EXT_IDENT' at line 1,sql: select REGISTRY_ID, SEQUENCE_NO, LINKED_ID, UFID, PRINCIPAL, PRIN_RSC_TYP, FRIENDLY_NAME, HONORIFIC_PREFIX, GIVEN_NAME, MIDDLE_NAME, FAMILY_NAME, HONORIFIC_SUFFIX, DISPLAY_NAME, EMAIL, PHONE_NUMBER, PHONE_TYPE, CREATED_TS, INACTIVE_TS, END_TS, STATUS, SENSITIVE, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01 from grouper.uf_EXT_IDENTITY where REGISTRY_ID >= ? and REGISTRY_ID <= ? at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955) at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1005) at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:1896) ... 8 more, took: 0:01:36.253

       

      Success N/A overall 2019-06-21 22:23:55.0 2019-06-21 22:25:31.0 96323     12938 0 0 0 0 8a8085b26b7cfea4016b7cff4ec30018 2019-06-21 22:25:31.0 a4e7e3348125

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            michael.gettes.4@at.internet2.edu Michael Gettes (ufl.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: