Article - CS101599
Certain Cognos reports throw a UDA-SQL-0196 error in Windchill PDMLink 9.1
Modified: 15-Dec-2017
Applies To
- Windchill PDMLink 9.1 to 11.0
- Windchill ProjectLink 9.1 to 11.0
Description
Certain Cognos reports throw a UDA-SQL-0196 error in Windchill PDMLink 9.1
-
WBR_HOME/logs/cogserver.log:
- UDA-SQL-0196 The table or view <REPORT_NAME> was not found in the dictionary
-
WT_HOME/logs/MethodServer.log
- wt.pom.DatastoreException: A SQL error has occurred for the statement SELECT 'wt.access.PolicyAcl',A0.blob$entrySet,A0.entrySet,A0.classnamekeyA2A4,A0.idA3A2A4,A0.stateNameA4,A0.classNameA4,CONVERT(varchar,A0.createStampA2,120),A0.markForDeleteA2,CONVERT(varchar,A0.modifyStampA2,120),A0.idA2A2,A0.updateCountA2,CONVERT(varchar,A0.updateStampA2,120) FROM PolicyAcl A0 WHERE ((A0.idA3A2A4 = ?) AND (A0.classNameA4 = ?) AND (A0.stateNameA4 = ?)); Bind Parameters=[#######, wt.projmgmt.execution.ProjectActivity, ALL]. Database system message follows: java.sql.SQLException: [ptc][SQLServer JDBC Driver][SQLServer]Server failed to resume the transaction, desc: 3f00001d2
-
Certain Reports in Site - Utilities - Report Manager throw error:
- java.sql.SQLException: [ptc][SQLServer JDBC Driver][SQLServer]Warning: Fatal error 824
This is a printer-friendly version of Article 101599 and may be out of date. For the latest version click CS101599