1. 主页
  2. 支持
技术文章 - CS367073

在 Windchill PDMLink 12.0.2.2 中，wt.phonehome.reports.BuildFileVaultElements.retrieveMasterVaultDetails 在 ReplicaVault 表上失败，并显示“SQLServerException: 无效的列名‘ida2a2’”

已修改: 20-Jun-2025   


注意：本文已使用机器翻译软件翻译，以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意， PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情，请单击 此处 。
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • Windchill PDMLink 12.0.2.2 to 12.1.1.0

说明

BackgroundMethodServer 日志抛出： 

 ERROR [commonScheduleQueue.SchedulingThread] wt.phonehome.reports.BuildFileVaultElements Administrator - Exception trying to retrieve replica vault information : (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows: - Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT SUM(A0.fileSize),A3.name,A3.idA2A2 FROM ApplicationData A0,MasteredOnReplicaItem A1,ReplicaFolder A2,ReplicaVault A3 WHERE ((A1.streamId = A0.streamId) AND (A2.idA2A2 = A1.idA3A4) AND (A3.idA2A2 = A2.idA3A5)) GROUP BY A3.name,A3.ida2a2; Bind Parameters=null". Database system message follows: Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ida2a2'.


从堆栈： 

at wt.phonehome.reports.BuildFileVaultElements.retrieveMasterVaultDetails(BuildFileVaultElements.java:242)
at wt.phonehome.reports.BuildFileVaultElements.fillInFileServerElements(BuildFileVaultElements.java:108)
at wt.phonehome.reports.BasicConfigurationReport.createReport(BasicConfigurationReport.java:38)
at com.ptc.wa.systemInfo.report.builder.WindchillSystemInformationElementBuilder.getWindchillSystemInfo(WindchillSystemInformationElementBuilder.java:65)
at com.ptc.wa.systemInfo.report.builder.WindchillSystemInformationElementBuilder.getElements(WindchillSystemInformationElementBuilder.java:50)
at com.ptc.wa.report.builder.WAReportBuilder.build(WAReportBuilder.java:51)
at com.ptc.wa.mbeans.WAAbstractPlugin.buildReport(WAAbstractPlugin.java:201)
at com.ptc.wa.mbeans.WAAbstractPlugin.buildReportAndSerialize(WAAbstractPlugin.java:230)
at com.ptc.wa.systemInfo.WindchillSystemInformationPlugin.collect(WindchillSystemInformationPlugin.java:96)
at com.ptc.wa.create.WAReportCreationManager.generateReport(WAReportCreationManager.java:685)
at com.ptc.wa.create.WAReportCreationManager.generateReportFromQueue(WAReportCreationManager.java:262)


这是文章 367073 的 PDF 版本，可能已过期。最新版本 CS367073