AnsweredAssumed Answered

Issue During Upgrade from Clarity 7.5.3 to 8.1

Question asked by mathan14 on Jun 8, 2010
Latest reply on Jun 8, 2010 by FL_Joan
Hi All,

We are currently upgrade Clarity from 7.5.3 to 8.1 and then to V12.

Please help me resolving this issue.

Activity : Upgrade Clarity from 7.5.3 to 8.1

Main Issue: Data are not getting copied from SRM_PROJECTS to INV_INVESTMENTS.

Errors in Admin Log: We got two errors in admin.log file.

Note: I have attached the admin.log file and Upgrade Steps file (Step by Step details of what we have done during this upgrade)

Error 1:


6/3/10 4:46 AM (admin) SQL error code: 102
6/3/10 4:46 AM (admin) Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '@R'.
6/3/10 4:46 AM (admin) SQL error code: 50000
6/3/10 4:46 AM (admin) Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20000_Error in CMN_ID_CREATE_CURRVAL_SP - Calling EXEC to create CMN_ID_CURRVAL_FCT:
6/3/10 4:46 AM (admin) Executed:
6/3/10 4:46 AM (admin) {call CMN_ID_SP(?,?,?,?)}
6/3/10 4:46 AM (admin) Derived from statement:
6/3/10 4:46 AM (admin) <?xml version="1.0" encoding="UTF-8"?>
6/3/10 4:46 AM (admin) <statement location="unionPMD.xml" id="union.genID_stmt" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
6/3/10 4:46 AM (admin) <sql dbVendor="all">
6/3/10 4:46 AM (admin) <text>{call CMN_ID_SP(?,?,?,?)}</text>
6/3/10 4:46 AM (admin) <param name="tableName" type="string" direction="IN" expressionListDelimiter=","/>
6/3/10 4:46 AM (admin) <param name="result" type="long" direction="OUT" expressionListDelimiter=","/>
6/3/10 4:46 AM (admin) <param name="size" type="long" direction="IN" expressionListDelimiter=","/>
6/3/10 4:46 AM (admin) <param name="sequenceName" type="string" direction="IN" expressionListDelimiter=","/>
6/3/10 4:46 AM (admin) </sql>
6/3/10 4:46 AM (admin) </statement>
6/3/10 4:46 AM (admin) Referenced by:
6/3/10 4:46 AM (admin) <?xml version="1.0" encoding="UTF-8"?>
6/3/10 4:46 AM (admin) <statementRef id="union.genID_stmt" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>
6/3/10 4:46 AM (admin) Using input:
6/3/10 4:46 AM (admin) {size=1, sequenceName=null, tableName=INV_OTHERS}
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:1742)
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1789)
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2247)
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:690)
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:599)
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:448)
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:219)
6/3/10 4:46 AM (admin) at com.niku.xql2.upgrade.BaseUpgrade.executePMDQuery(BaseUpgrade.java:215)
6/3/10 4:46 AM (admin) at com.niku.projmgr.upgrade.MigrateToInvestments.bumpSequences(MigrateToInvestments.java:177)
6/3/10 4:46 AM (admin) at com.niku.projmgr.upgrade.MigrateToInvestments.doUpgrade(MigrateToInvestments.java:68)
6/3/10 4:46 AM (admin) at com.niku.xql2.upgrade.BaseUpgrade.run(BaseUpgrade.java:134)
6/3/10 4:46 AM (admin) at com.niku.projmgr.upgrade.MigrateToInvestments.main(MigrateToInvestments.java:562)
6/3/10 4:46 AM (admin) Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '@R'.
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)
6/3/10 4:46 AM (admin) at com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)
6/3/10 4:46 AM (admin) at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
6/3/10 4:46 AM (admin) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
6/3/10 4:46 AM (admin) at java.lang.reflect.Method.invoke(Method.java:585)
6/3/10 4:46 AM (admin) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
6/3/10 4:46 AM (admin) at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$83fe3fda.execute(<generated>)
6/3/10 4:46 AM (admin) at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2226)
6/3/10 4:46 AM (admin) ... 9 more



Regards,
Mathan

Attachments

Outcomes