Which IIQ version are you inquiring about?
Version 8.4
Please share any other relevant files that may be required (for example, logs).
ErrorLog.txt (196 KB)
Share all details related to your problem, including any error messages you may have received.
As part of the IIQ Installation, We have imported init.xml and init-lcm.xml and then did restart of Apache Tomcat Server. But after restart we are getting the below error. In this case “bbyc-sqldb-sailpoint-dt-001” is the database name and “identityiq” is the schema name. But IIQ is taking the first one as schema name and trying to create ACTIVEMQ_MSGS table(which is rejected by SQL Server since such schema doesn’t exist). Please assist us on triggering the sql query with correct schema. Attached full log from tomcat.
2024-01-23T04:02:26,091 WARN main sailpoint.messagebus.impl.ActiveMQMessageServiceManager:525 - Could not create JDBC tables; they could already exist. Failure was: CREATE TABLE bbyc-sqldb-sailpoint-dt-001.ACTIVEMQ_MSGS(ID BIGINT NOT NULL, CONTAINER VARCHAR(250) NOT NULL, MSGID_PROD VARCHAR(250), MSGID_SEQ BIGINT, EXPIRATION BIGINT, MSG IMAGE, PRIMARY KEY ( ID ) ) Message: Incorrect syntax near ‘-’. SQLState: S0001 Vendor code: 102
2024-01-23T04:02:26,098 WARN main activemq.store.jdbc.JDBCPersistenceAdapter:648 - Failure details: Incorrect syntax near ‘-’.
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘-’.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7675) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4137) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) ~[mssql-jdbc-12.4.2.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:787) ~[mssql-jdbc-12.4.2.jre11.jar:?]
