1. Home
  2. Support
Article - CS55464

Unable to create new objects due to errors "The value is not set for the parameter number <some number>" or "Invalid column name 'ptc_zzz_1xxxx'" in Windchill

Modified: 13-Jan-2023   


Applies To

  • FlexPLM 10.2 M030 to 12.0
  • Windchill PDMLink 10.0 to 12.1

Description

  • Errors are thrown while creating new objects like WTPart, WTDocument or another type that uses Standard attributes
  • Redline Error seen on searching the document in FlexPLM
  • Error occuring when accessing/search Product objects after installing FlexPLM Patch  
    java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."CLASSNAMEKEY22TYPEINFOLCSDOC": invalid identifier
  • Errors observed in Method server log:
  1. Error 1 
    The value is not set for the parameter number <some number>
  2. Error 2 
    wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO WTPart( <table columns> ) VALUES (<Parameters>)". Database system message follows: com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number <some number>.
  3. Error 3  
    wt.pom.PersistenceException: A persistence error occurred. System message follows: Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO WTDocument(<table columns>) VALUES (<parameters>)". Database system message follows: Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ptc_zzz_1xxxx'.
  4. ​Error 4  
    java.sql.SQLSyntaxErrorException: ORA-00904: "<table column>": invalid identifier
  5. Error 5  
    Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: wt.query.QueryException: Attribute "typeInfoWTPart.ptc_rht_1" is not a member of class "class wt.part.WTPart"
Nested exception is: Attribute "typeInfoWTPart.ptc_rht_1" is not a member of class "class wt.part.WTPart"
2018-05-23 14:13:39,305 ERROR [PublisherQueueSIS1.PollingThread] wt.wvs.publish.CadConvertSIS Administrator - Errors in getComponentContent
This is a printer-friendly version of Article 55464 and may be out of date. For the latest version click CS55464