AnsweredAssumed Answered

Clarityv13.1 Upgrade issue - Incorrect syntax near 'CONFIGURATIONS'

Question asked by Georgy N Joseph on Oct 26, 2012
Latest reply on Jun 24, 2014 by Georgy N Joseph
Hi Experts,

We are currently on Clarityv12.1.0.5840 and just begun our upgrde to v13.1. (is this the recommended upgrade path for 12.1.0.5840??)

We ran install.bat of the 13.1 installer and now face an error.
The contents of install.log file at \temp\install-packages\12.1.1\upgrade-repack.12.1.1.1208\ is shown below..
.............
10/26/12 6:23 AM (ExecTask) Command: install database schema file
10/26/12 6:23 AM (ExecTask) To URL: 

jdbc:clarity:sqlserver://192.168.0.201:1433;DatabaseName=CareFirstUpgrade;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
10/26/12 6:23 AM (ExecTask) As user: niku
10/26/12 6:23 AM (ExecTask) For vendor: mssql
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) Process: C:\Clarity\database\sql\OBSOLETE_OBJECTS.xml
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) Total time: 0H:0M:0S
10/26/12 6:23 AM (ExecTask) Adjust stock seeddata IDs...
10/26/12 6:23 AM (ExecTask) ==========================================
10/26/12 6:23 AM (ExecTask) DBTools Log - Fri Oct 26 06:23:17 PDT 2012
10/26/12 6:23 AM (ExecTask) ==========================================
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) Command: bump ids (oracle only)
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) Total time: 0H:0M:0S
10/26/12 6:23 AM (ExecTask) Generate sequences...
10/26/12 6:23 AM (ExecTask) ==========================================
10/26/12 6:23 AM (ExecTask) DBTools Log - Fri Oct 26 06:23:18 PDT 2012
10/26/12 6:23 AM (ExecTask) ==========================================
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) [color=#f01e1e]Command: install database schema file[/color]
10/26/12 6:23 AM (ExecTask) To URL: 

jdbc:clarity:sqlserver://192.168.0.201:1433;DatabaseName=CareFirstUpgrade;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
10/26/12 6:23 AM (ExecTask) As user: niku
10/26/12 6:23 AM (ExecTask) For vendor: mssql
10/26/12 6:23 AM (ExecTask) 
[color=#ed2626]10/26/12 6:23 AM (ExecTask) Process: C:\Clarity\database\sql\GENERATE_CMN_SEQ_TABLES.xml[/color]
[color=#eb2424]10/26/12 6:23 AM (ExecTask) java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'CONFIGURATIONS'.[/color]
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseStatement.execute(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:1775)
10/26/12 6:23 AM (ExecTask) 
at com.niku.dbtools.FileApp.apply(FileApp.java:183)
10/26/12 6:23 AM (ExecTask) 
at com.niku.dbtools.FileApp.installSchemaObject(FileApp.java:88)
10/26/12 6:23 AM (ExecTask) 
at com.niku.dbtools.FileApp.installSchemaFile(FileApp.java:68)
10/26/12 6:23 AM (ExecTask) 
at com.niku.dbtools.FileApp.installSchemaFile(FileApp.java:57)
10/26/12 6:23 AM (ExecTask) 
at com.niku.dbtools.Utilities.run(Utilities.java:1325)
10/26/12 6:23 AM (ExecTask) 
at com.niku.dbtools.Utilities.main(Utilities.java:632)
10/26/12 6:23 AM (ExecTask) Exception in thread "main" java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'CONFIGURATIONS'.
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) SQL Text:
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask)  [color=#f01e1e] BEGIN
10/26/12 6:23 AM (ExecTask)     exec CMN_CREATE_SEQ_TABLES_SP;
10/26/12 6:23 AM (ExecTask)   END;[/color]
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) 
10/26/12 6:23 AM (ExecTask) Total time: 0H:0M:7S
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
10/26/12 6:23 AM (ExecTask) 
at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
10/26/12 6:23 AM (ExecTask) Error occurred: C:\Clarity\.setup\scripts\db.xml:345: Java returned: 1
10/26/12 6:23 AM (ExecTask) Check admin.log or use -verbose for more information.
[color=#f01e1e]10/26/12 6:23 AM (ExecTask) ERROR 2012-10-26 06:23:25,940 [main] ant.UnknownElement Task "exec" finished with error.
10/26/12 6:23 AM (ExecTask) C:\Clarity13Media\temp\install-packages\12.1.1\upgrade-repack.12.1.1.1208\install.xml:606: exec returned: 1[/color]
10/26/12 6:23 AM (ExecTask) 
at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:591)
10/26/12 6:23 AM (ExecTask) 
at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)
10/26/12 6:23 AM (ExecTask) 
at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)
................

10/26/12 6:23 AM (ExecTask) ERROR 2012-10-26 06:23:26,049 [main] ant.UnknownElement Task "if" finished with error.
10/26/12 6:23 AM (ExecTask) C:\Clarity13Media\temp\install-packages\12.1.1\upgrade-repack.12.1.1.1208\install.xml:606: exec returned: 1
.......
10/26/12 6:23 AM (ExecTask) ERROR 2012-10-26 06:23:26,080 [main] ant.UnknownElement Task "complete" finished with error.
10/26/12 6:23 AM (ExecTask) C:\Clarity13Media\temp\install-packages\12.1.1\upgrade-repack.12.1.1.1208\install.xml:606: exec returned: 1
10/26/12 6:23 AM (ExecTask) 
at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:591)
................
Any ideas?

regards,
Georgy

Outcomes