DhruvClarity

***Upgrade Issue: Error on Pre-Upgrade Step ***

Discussion created by DhruvClarity on Jun 7, 2010
Hi,

Has anyone faced an error in admin.log file, like mentioned this below:

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>

Any workaround for this OOTB functionality.

Regards,
Dhruv_Clarity

Outcomes