Minor Description
ERROR UpgradeTasks$14$1.callback(1270) - [] - Could not perform upgrade task V20 adding tables/foreign keys/indexes for GRP-5625 load azure from provisioner to table! Skipping this upgrade task, install the tables/foreign keys/indexes manually
|
java.lang.RuntimeException: sql: CREATE TABLE grouper_prov_adobe_user
|
(
|
config_id VARCHAR2(50) NOT NULL,
|
user_id VARCHAR2(100) NOT NULL,
|
email VARCHAR2(256) NOT NULL,
|
username VARCHAR2(100),
|
status VARCHAR2(30) NULL,
|
adobe_type VARCHAR2(30) NULL,
|
firstname VARCHAR2(100) NULL,
|
lastname VARCHAR2(100) NULL,
|
domain VARCHAR2(100) NULL,
|
country VARCHAR2(2) NULL,
|
PRIMARY KEY (config_id, user_id)
|
);
|
,
|
at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2665)
|
at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.executeSql(GcDbAccess.java:2694)
|
at edu.internet2.middleware.grouper.app.upgradeTasks.UpgradeTasks$14$1.callback(UpgradeTasks.java:958)
|
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.upgradeTasks.UpgradeTasks$14.updateVersionFromPrevious(UpgradeTasks.java:913)
|
at edu.internet2.middleware.grouper.app.upgradeTasks.UpgradeTasksJob.run(UpgradeTasksJob.java:112)
|
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) [quartz-2.3.2.jar:?]
|
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?]
|
Caused by: java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option
|
|
|
https://docs.oracle.com/error-help/db/ora-00922/
|
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:712) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:612) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1364) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:969) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:516) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:275) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1485) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:2009) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1622) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3961) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.OraclePreparedStatement.doExecuteLargeUpdate(OraclePreparedStatement.java:4327) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:4304) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4279) ~[ojdbc17.jar:23.6.0.24.10]
|
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1004) ~[ojdbc17.jar:23.6.0.24.10]
|
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462) ~[c3p0-0.9.5.4.jar:0.9.5.4]
|
at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2654)
|
... 16 more
|
The issue is the semicolon in the 3 statements for the tables; tested and confirmed the error goes away without the semicolon.
Note also the error says "V20" when it's actually V14.