アーティクル - CS406033
WTPart の構造内で検索すると、Windchill PDMLink で「エラー: UNION、INTERSECT、または EXCEPT 演算子を使用して結合されたすべてのクエリは、ターゲット リストに同じ数の式が必要です」がスローされます。
修正日: 14-Mar-2024
適用対象
- Windchill PDMLink 12.1
説明
- WTPart の構造内で検索するとエラーがスローされます: UNION、INTERSECT、または EXCEPT 演算子を使用して結合されたすべてのクエリは、ターゲット リストに同じ数の式が含まれている必要があります
- WTPart の構造内の検索を実行すると、mslog に次のエラーが表示されて失敗します。
com.ptc.cat.ops.server.internal.FindAndNavigateOperation XXXX - FindAndNavigateOperation threw an exception. (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 1,A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,CONVERT(DECIMAL(28),NULL),CONVERT(DECIMAL(28),NULL) FROM WTPartMaster A0,(SELECT A0.idA2A2 alias1 FROM WTPartMaster A0 WHERE ((A0.idA2A2 = ?))) A1 WHERE (((A0.WTPartNumber LIKE N'%16%') OR (UPPER(A0.name) LIKE N'%16%')) AND (A0.idA2A2 = A1.alias1))) UNION (SELECT A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,CONVERT(DECIMAL(28),NULL),A0.branchIdA2typeDefinitionRefe FROM WTPart A0,(SELECT A0.idA2A2 alias FROM WTPart A0 WHERE ((A0.idA2A2 = ?))) A1 WHERE (((A0.adhocVersionInfo IS NULL ) AND ((A0.idA2A2 IN ((SELECT A0.idA2A2 FROM WTPart A0,WTPartMaster A1 WHERE ((UPPER(A1.name) LIKE N'%16%')) AND (A0.idA3masterReference = A1.idA2A2)) UNION (SELECT A0.idA2A2 FROM WTPart A0,WTPartMaster A1 WHERE ((A1.WTPartNumber LIKE N'%16%')) AND (A0.idA3masterReference = A1.idA2A2)))) AND ((A0.statecheckoutInfo IS NULL ) OR (((A0.iopStateinteropInfo IS NULL ) OR (A0.iopStateinteropInfo NOT IN (?,?,?,?,?))) AND (((A0.statecheckoutInfo NOT IN (?,?,?,?,?)) AND (A0.idA2A2 NOT IN (SELECT A0.idA2A2 FROM WTPart A0 WHERE ((A0.idA3A2lock = ?))))) OR ((A0.statecheckoutInfo = ?) AND (A0.idA3B2iterationInfo = ?))))) AND ((A0.statecheckoutInfo IS NULL ) OR (((A0.iopStateinteropInfo IS NULL ) OR (A0.iopStateinteropInfo NOT IN (?,?,?,?,?))) AND (((A0.statecheckoutInfo NOT IN (?,?,?,?,?)) AND (A0.idA2A2 NOT IN (SELECT A0.idA2A2 FROM WTPart A0 WHERE ((A0.idA3A2lock = ?))))) OR ((A0.statecheckoutInfo = ?) AND (A0.idA3B2iterationInfo = ?))))))) AND (A0.idA2A2 = A1.alias))); Bind Parameters=[XXXX, XXXX, wt.query.ArrayExpression{[terminal, iop_abandoned]}, wt.query.ArrayExpression{[wrk, wrk-p]}, XXXX, wrk, XXXX, wt.query.ArrayExpression{[terminal, iop_abandoned]}, wt.query.ArrayExpression{[wrk, wrk-p]}, XXXX, wrk, XXXX]". Database system message follows: Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:577) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:544) at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282) at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234) at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1351) at com.ptc.cat.assocnav.server.LightweightNavUnitFinder.executeDBQuery(LightweightNavUnitFinder.java:2081) at com.ptc.cat.assocnav.server.LightweightNavUnitFinder.find(LightweightNavUnitFinder.java:474) at com.ptc.cat.ops.server.internal.FindAndNavigateOperation.run(FindAndNavigateOperation.java:167) at com.ptc.cat.ops.server.DefaultOperationDispatcher.dispatch(DefaultOperationDispatcher.java:161) at jdk.internal.reflect.GeneratedMethodAccessor579.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:571) at com.ptc.mvc.gwt.GwtHandlerAdapter.processCall(GwtHandlerAdapter.java:183) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at com.ptc.mvc.gwt.GwtHandlerAdapter.handle(GwtHandlerAdapter.java:135) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:528) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.licenseusage.licensing.LicenseFilter.doFilter(LicenseFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.ptc.core.ui.validation.URLValidationFilter.doFilter(URLValidationFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:104) at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:301) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:335) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1677) at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1801) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)ERROR [ajp-nio-127.0.0.1-8010-exec-2] wt.pds.exception XXXX- Suppressing internal message (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 1,A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,CONVERT(DECIMAL(28),NULL),CONVERT(DECIMAL(28),NULL) FROM WTPartMaster A0,(SELECT A0.idA2A2 alias1 FROM WTPartMaster A0 WHERE ((A0.idA2A2 = ?))) A1 WHERE (((A0.WTPartNumber LIKE N'%16%') OR (UPPER(A0.name) LIKE N'%16%')) AND (A0.idA2A2 = A1.alias1))) UNION (SELECT A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,CONVERT(DECIMAL(28),NULL),A0.branchIdA2typeDefinitionRefe FROM WTPart A0,(SELECT A0.idA2A2 alias FROM WTPart A0 WHERE ((A0.idA2A2 = ?))) A1 WHERE (((A0.adhocVersionInfo IS NULL ) AND ((A0.idA2A2 IN ((SELECT A0.idA2A2 FROM WTPart A0,WTPartMaster A1 WHERE ((UPPER(A1.name) LIKE N'%16%')) AND (A0.idA3masterReference = A1.idA2A2)) UNION (SELECT A0.idA2A2 FROM WTPart A0,WTPartMaster A1 WHERE ((A1.WTPartNumber LIKE N'%16%')) AND (A0.idA3masterReference = A1.idA2A2)))) AND ((A0.statecheckoutInfo IS NULL ) OR (((A0.iopStateinteropInfo IS NULL ) OR (A0.iopStateinteropInfo NOT IN (?,?,?,?,?))) AND (((A0.statecheckoutInfo NOT IN (?,?,?,?,?)) AND (A0.idA2A2 NOT IN (SELECT A0.idA2A2 FROM WTPart A0 WHERE ((A0.idA3A2lock = ?))))) OR ((A0.statecheckoutInfo = ?) AND (A0.idA3B2iterationInfo = ?))))) AND ((A0.statecheckoutInfo IS NULL ) OR (((A0.iopStateinteropInfo IS NULL ) OR (A0.iopStateinteropInfo NOT IN (?,?,?,?,?))) AND (((A0.statecheckoutInfo NOT IN (?,?,?,?,?)) AND (A0.idA2A2 NOT IN (SELECT A0.idA2A2 FROM WTPart A0 WHERE ((A0.idA3A2lock = ?))))) OR ((A0.statecheckoutInfo = ?) AND (A0.idA3B2iterationInfo = ?))))))) AND (A0.idA2A2 = A1.alias))); Bind Parameters=[XXXX, XXXX, wt.query.ArrayExpression{[terminal, iop_abandoned]}, wt.query.ArrayExpression{[wrk, wrk-p]}, XXXX, wrk, XXXX, wt.query.ArrayExpression{[terminal, iop_abandoned]}, wt.query.ArrayExpression{[wrk, wrk-p]}, XXXX, wrk, XXXX]". Database system message follows: Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:577) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:544) at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282) at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234) at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1351) at com.ptc.cat.assocnav.server.LightweightNavUnitFinder.executeDBQuery(LightweightNavUnitFinder.java:2081) at com.ptc.cat.assocnav.server.LightweightNavUnitFinder.find(LightweightNavUnitFinder.java:474) at com.ptc.cat.ops.server.internal.FindAndNavigateOperation.run(FindAndNavigateOperation.java:167) at com.ptc.cat.ops.server.DefaultOperationDispatcher.dispatch(DefaultOperationDispatcher.java:161) at jdk.internal.reflect.GeneratedMethodAccessor579.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:571) at com.ptc.mvc.gwt.GwtHandlerAdapter.processCall(GwtHandlerAdapter.java:183) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at com.ptc.mvc.gwt.GwtHandlerAdapter.handle(GwtHandlerAdapter.java:135) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:528) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.licenseusage.licensing.LicenseFilter.doFilter(LicenseFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.ptc.core.ui.validation.URLValidationFilter.doFilter(URLValidationFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:104) at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:301) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:335) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1677) at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1801) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)ERROR [ajp-nio-127.0.0.1-8010-exec-2] com.ptc.cat.ops.server.DefaultOperationDispatcher XXXX - A persistence error occurred. wt.util.WTException: A persistence error occurred. Nested exception is: (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 1,A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,CONVERT(DECIMAL(28),NULL),CONVERT(DECIMAL(28),NULL) FROM WTPartMaster A0,(SELECT A0.idA2A2 alias1 FROM WTPartMaster A0 WHERE ((A0.idA2A2 = ?))) A1 WHERE (((A0.WTPartNumber LIKE N'%16%') OR (UPPER(A0.name) LIKE N'%16%')) AND (A0.idA2A2 = A1.alias1))) UNION (SELECT A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,CONVERT(DECIMAL(28),NULL),A0.branchIdA2typeDefinitionRefe FROM WTPart A0,(SELECT A0.idA2A2 alias FROM WTPart A0 WHERE ((A0.idA2A2 = ?))) A1 WHERE (((A0.adhocVersionInfo IS NULL ) AND ((A0.idA2A2 IN ((SELECT A0.idA2A2 FROM WTPart A0,WTPartMaster A1 WHERE ((UPPER(A1.name) LIKE N'%16%')) AND (A0.idA3masterReference = A1.idA2A2)) UNION (SELECT A0.idA2A2 FROM WTPart A0,WTPartMaster A1 WHERE ((A1.WTPartNumber LIKE N'%16%')) AND (A0.idA3masterReference = A1.idA2A2)))) AND ((A0.statecheckoutInfo IS NULL ) OR (((A0.iopStateinteropInfo IS NULL ) OR (A0.iopStateinteropInfo NOT IN (?,?,?,?,?))) AND (((A0.statecheckoutInfo NOT IN (?,?,?,?,?)) AND (A0.idA2A2 NOT IN (SELECT A0.idA2A2 FROM WTPart A0 WHERE ((A0.idA3A2lock = ?))))) OR ((A0.statecheckoutInfo = ?) AND (A0.idA3B2iterationInfo = ?))))) AND ((A0.statecheckoutInfo IS NULL ) OR (((A0.iopStateinteropInfo IS NULL ) OR (A0.iopStateinteropInfo NOT IN (?,?,?,?,?))) AND (((A0.statecheckoutInfo NOT IN (?,?,?,?,?)) AND (A0.idA2A2 NOT IN (SELECT A0.idA2A2 FROM WTPart A0 WHERE ((A0.idA3A2lock = ?))))) OR ((A0.statecheckoutInfo = ?) AND (A0.idA3B2iterationInfo = ?))))))) AND (A0.idA2A2 = A1.alias))); Bind Parameters=[XXXX, XXXX, wt.query.ArrayExpression{[terminal, iop_abandoned]}, wt.query.ArrayExpression{[wrk, wrk-p]}, XXXX, wrk, XXXX, wt.query.ArrayExpression{[terminal, iop_abandoned]}, wt.query.ArrayExpression{[wrk, wrk-p]}, XXXX, wrk, XXXX]". Database system message follows: Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:577) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:544) at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282) at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234) at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1351) at com.ptc.cat.assocnav.server.LightweightNavUnitFinder.executeDBQuery(LightweightNavUnitFinder.java:2081) at com.ptc.cat.assocnav.server.LightweightNavUnitFinder.find(LightweightNavUnitFinder.java:474) at com.ptc.cat.ops.server.internal.FindAndNavigateOperation.run(FindAndNavigateOperation.java:167) at com.ptc.cat.ops.server.DefaultOperationDispatcher.dispatch(DefaultOperationDispatcher.java:161) at jdk.internal.reflect.GeneratedMethodAccessor579.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:571) at com.ptc.mvc.gwt.GwtHandlerAdapter.processCall(GwtHandlerAdapter.java:183) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at com.ptc.mvc.gwt.GwtHandlerAdapter.handle(GwtHandlerAdapter.java:135) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:528) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.licenseusage.licensing.LicenseFilter.doFilter(LicenseFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at com.ptc.core.ui.validation.URLValidationFilter.doFilter(URLValidationFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:104) at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:301) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:335) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1677) at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1801) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)
最新バージョンはこちらを参照ください CS406033