Article - CS192776

"java.sql.SQLSyntaxErrorException: ORA-00904: "IDA3B5": invalid identifier" when navigating BinaryLinks from a WTPart related to an effectivity in Windchill 10.1 M050

Modified: 05-Nov-2015   


Applies To

  • Windchill PDMLink 10.1 M050 to 10.2

Description

  • "java.sql.SQLSyntaxErrorException: ORA-00904: "IDA3B5": invalid identifier" when navigating BinaryLinks from a WTPart related to an effectivity (ProductMSNEffectivity assigned to a WTPart).
For example :
QueryResult aqr = PersistenceHelper.manager.navigate(part, "roleAObject", BinaryLink.class, false);
  • Note that once the issue has occurred, it will be faced for all the parts in the system, until the Method Server is restarted.
  • Same issue with <Query-Links> webject
This is a printer-friendly version of Article 192776 and may be out of date. For the latest version click CS192776