1. Home
  2. Support
Article - CS208019

Unable to create CEProductGeneralActivity "Exception thrown "java.sql.SQLException: Missing IN or OUT parameter at index:: 45" in Windchill QMS10.2 M030

Modified: 19-Jun-2015   


Applies To

Windchill QMS 10.2 M030

Description

  • Unable to create CEProductGeneralActivity "Exception thrown "java.sql.SQLException: Missing IN or OUT parameter at index:: 45" 
  • Steps to Reproduce:
1) Run below commad to create standard attribute for CEProductGeneralActivity
AddColumns com.ptc.qualitymanagement.cem.activity.product.CEProductGeneralActivity String=2
2) Create standard attribute of string data type for CEProductGeneralActivity using type and attribute manager
3) Create a CEProductGeneralActivity, error is throw as shown below
 
 
User-added image


 
  • Method server logs:
 
Caused by: wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO CEProductGeneralActivity(classnameA2A2,updateCountA2,activityText,administrativeLockIsNull,typeadministrativeLock,blob$entrySetadHocAcl,closedDate,classnamekeycontainerReferen,idA3containerReference,classnamekeydomainRef,idA3domainRef,entrySetadHocAcl,eventSet,informant,inheritedDomain,classnamekeyinitiatedByRefer,idA3initiatedByReference,initiatedDate,name,ACTIVITYNUMBER,performReview,classnamekeyA7,idA3A7,requestCompleted,classnamekeyrespondentRefere,idA3respondentReference,response,responseAccepted,responseDate,review,reviewDate,classnamekeyreviewerReferenc,idA3reviewerReference,atGatestate,classnamekeyA2state,idA3A2state,statestate,teamIdIsNull,classnamekeyteamId,idA3teamId,teamTemplateIdIsNull,classnamekeyteamTemplateId,idA3teamTemplateId,markForDeleteA2,branchIdA2typeDefinitionRefe,idA2typeDefinitionReference,ptc_str_1typeInfoCEProductGe,ptc_str_2typeInfoCEProductGe,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('com.ptc.qualitymanagement.cem.activity.product.CEProductGeneralActivity',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
    java.sql.SQLException: Missing IN or OUT parameter at index:: 45
    ... 74 more
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 45
    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1844)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
    at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3172)
 

 
This is a printer-friendly version of Article 208019 and may be out of date. For the latest version click CS208019