Article - CS237119
Getting error SQLServerException: Invalid column name 'column_value' when using incremental publishing on Information Structure bundle in Windchill Service Information Manager 10.2
Modified: 03-Jul-2020
Applies To
- Windchill Service Information Manager 10.2 M032-CPS01 to 11.0
- SQL Server
Description
- Getting error SQLServerException: Invalid column name 'column_value' when using incremental publishing on Information Structure bundle
- The database being used is SQL Server
- Incremental Publish of Information Structure bundle fails with the below error:
- 2016-05-13 14:17:52,810 ERROR [PublisherQueueSIS1.PollingThread] wt.wvs.publish.CadConvertSIS Administrator - Errors in getComponentContent
(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 A0.column_value FROM (SELECT column_value FROM #TABLE_OF_NUMBER WHERE paramIndex = 1) A0 WHERE (NOT (EXISTS (SELECT 1 FROM ServiceEffectivity B0 WHERE ((B0.branchIditerationInfo = A0.column_value))))); Bind Parameters=null". Database system message follows:
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'column_value'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:559)
at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:523)
at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282)
at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234)
- 2016-05-13 14:17:52,810 ERROR [PublisherQueueSIS1.PollingThread] wt.wvs.publish.CadConvertSIS Administrator - Errors in getComponentContent
This is a printer-friendly version of Article 237119 and may be out of date. For the latest version click CS237119