Article - CS93244
"Ambiguous column name 'TypeID'" database error with isType("...") computation method in Windchill RV&S / Integrity Lifecycle Manager
Modified: 09-Feb-2021
Applies To
- PTC RV&S (formerly Integrity Lifecycle Manager) 2009 9.7 to 12.3
Description
- Ambiguous column name 'TypeID' database error with isType("...") computation method in Integrity Lifecycle Manager
- Using isType("...") computation within a field results in DB exception under certain circumstances
- MSSQL
- GENERAL(0): java.sql.SQLException -- java.sql.SQLException: Ambiguous column name 'TypeID'.
- DEBUG(5): mks.ci.exception.CIException: MKS131372: An unhandled database exception has occurred. Please contact your administrator.
The error supplied by the database is:
Ambiguous column name 'TypeID'.: -- java.sql.SQLException: MKS131372: An unhandled database exception has occurred. Please contact your administrator.
- Oracle DB
- GENERAL(0): java.sql.SQLSyntaxErrorException -- java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
- DEBUG mks.ci.exception.CIException: java.sql.SQLException: MKS131372: An unhandled database exception has occurred. Please contact your administrator.
The error supplied by the database is:
ORA-00918: column ambiguously defined
This is a printer-friendly version of Article 93244 and may be out of date. For the latest version click CS93244