AnsweredAssumed Answered

Error during installation of RSA IGL 7.0.2

Question asked by Steve ALEXANDRE on May 25, 2018

Hello,

 

We are trying to install RSA IGL 7.0.2 in a lab environment but we got some errors during the part of the database.

We use a remote database, all has been configured following rsa procedures.

 

Here an example of the error :

 

SQL/line#: /tmp/aveksa/staging/database/Schema/Create_Base_Schema.sql(8507):
Start time [Fri May 25 14:29:30 CEST 2018]
ALTER TABLE T_WORKFLOW_RULES_VERSIONS ADD CONSTRAINT FK_T_WF_R_V_RID_T_WF_R_ID
FOREIGN KEY (RULE_ID)
REFERENCES T_WORKFLOW_RULES(ID)
End time [Fri May 25 14:29:31 CEST 2018]
Execution time (s): 0
[0:03:08] File Completion Time: /tmp/aveksa/staging/database/Schema/Create_Base_Schema.sql
[0:03:10] Total Migration Time
java.sql.SQLSyntaxErrorException: ORA-00942: Table ou vue inexistante

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
at com.aveksa.migration.jdbctool.IncrementalUpdate.saveDatabaseUpdates(IncrementalUpdate.java:748)
at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:511)
at com.aveksa.migration.jdbctool.CreateSchema.execute(CreateSchema.java:81)
at com.aveksa.cli.CreateMigrateSchemaModule.runCommandImpl(CreateMigrateSchemaModule.java:195)
at com.aveksa.cli.BaseDatabaseCLIModule.runCommand(BaseDatabaseCLIModule.java:60)
at com.aveksa.cli.Main.run(Main.java:350)
at com.aveksa.cli.Main.main(Main.java:390)

After checking on the database, the table exist. It is possible the java process running more faster than the treatment of the DB?

 

An other example :

 

SQL/line#: /tmp/aveksa/staging/database/Utilities/Sql/vlog.sql(5):
Start time [Fri May 25 14:29:36 CEST 2018]
create or replace view VLOG as
select '['||to_char(LDATE, 'Mon DD, HH24:MI:SS')||':'||LTRIM(to_char(mod(LHSECS,100),'09'))||']'||
'['||plog.getLevelInText(llevel)||']['||
LUSER||']['||
LSECTION||']['||
LTEXTE||']' log
from (select * from (select * from tlog order by id desc) where rownum < 25)
order by ID
End time [Fri May 25 14:29:36 CEST 2018]
Execution time (s): 0
[0:00:04] File Completion Time: /tmp/aveksa/staging/database/Utilities/Sql/RebuildLog4PLSQL.sql
[0:03:15] Total Migration Time
java.sql.SQLSyntaxErrorException: ORA-00942: Table ou vue inexistante

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
at com.aveksa.migration.jdbctool.IncrementalUpdate.saveDatabaseUpdates(IncrementalUpdate.java:748)
at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:511)
at com.aveksa.migration.jdbctool.CreateSchema.execute(CreateSchema.java:81)
at com.aveksa.cli.CreateMigrateSchemaModule.runCommandImpl(CreateMigrateSchemaModule.java:195)
at com.aveksa.cli.BaseDatabaseCLIModule.runCommand(BaseDatabaseCLIModule.java:60)
at com.aveksa.cli.Main.run(Main.java:350)
at com.aveksa.cli.Main.main(Main.java:390)

After checking on the DB again, the table TLOG is present.

 

Thank you for your help.

Outcomes