技术文章 - CS101599
Windchill PDMLink 9.1中某些Cognos报告出现UDA-SQL-0196错误
已修改: 15-Dec-2017
适用于
- Windchill PDMLink 所有日期代码
- Windchill ProjectLink 所有日期代码
- Windchill Business Reporting (Cognos Business Intelligence) 所有日期代码
- Microsoft SQL Server 所有日期代码
说明
- 某些Cognos报告出现UDA-SQL-0196错误
- 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
- 站点 > 实用程序 > 报告管理 提示错误:
- java.sql.SQLException: [ptc][SQLServer JDBC Driver][SQLServer]Warning: Fatal error 824
这是文章 101599 的 PDF 版本，可能已过期。最新版本 CS101599