Details
-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
2.4.0
-
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 |