Article - CS367073
wt.phonehome.reports.BuildFileVaultElements.retrieveMasterVaultDetails failing with "SQLServerException: Invalid column name 'ida2a2'" on ReplicaVault table in Windchill PDMLink 12.0.2.2
Modified: 19-Jun-2025
Applies To
- Windchill PDMLink 12.0.2.2 to 12.1.1.0
Description
BackgroundMethodServer log throwing:
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'.
From Stack:
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)
This is a printer-friendly version of Article 367073 and may be out of date. For the latest version click CS367073