アーティクル - CS371948
FlexPLM 12.0にアップグレードした後、デフォルトのシステムビューでドキュメントライブラリ検索を実行できませんでした
修正日: 28-Jun-2022
適用対象
- FlexPLM 12.0
説明
- FlexPLM 12.0にアップグレードした後、特定のデフォルトのシステムビューでドキュメントライブラリ検索を実行できませんでした
- UIのエラー:
The system is unable to process your request at this time. Please try again later. If the problem persists contact your system administrator.
- Methodserverログのエラー:
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) at com.lcs.wc.db.QueryTask.runPreparedStatementQuery(QueryTask.java:139) at com.lcs.wc.db.QueryTask.runQuery(QueryTask.java:93) at com.lcs.wc.db.Query.runPreparedQuery(Query.java:260) at com.lcs.wc.db.Query.runQuery(Query.java:219) at com.lcs.wc.foundation.LCSQuery.runDirectQuery(LCSQuery.java:314) at com.lcs.wc.foundation.LCSQuery.runDirectQuery(LCSQuery.java:304) at com.lcs.wc.document.LCSDocumentQuery.getDocumentResults(LCSDocumentQuery.java:374) at org.apache.jsp.rfa.jsp.document.FindDocumentResults_jsp._jspService(FindDocumentResults_jsp.java:976) ... at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:906) at org.apache.jsp.rfa.jsp.v2.main.MainTemplate_jsp._jspService(MainTemplate_jsp.java:742) ... at org.apache.jsp.rfa.jsp.v2.document.DocumentController_jsp._jspService(DocumentController_jsp.java:2107) ... at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: Error : 936, Position : 4207, Sql = SELECT DISTINCT LCSDocument.ptc_str_1typeInfoLCSDocument, LCSDocument.branchIditerationInfo, ... FROM LCSDocument, WTUser CREATOR, WTUser MODIFIER, WTTypeDefinition, LatestIterLCSSeason T1527423027, LatestIterLCSProduct T1022227229 WHERE LCSDocument.idA3D2iterationInfo = CREATOR.idA2A2 AND LCSDocument.idA3B2iterationInfo = MODIFIER.idA2A2 AND LCSDocument.branchIdA2typeDefinitionRefe = WTTypeDefinition.branchIditerationInfo AND ... OR LCSDocument.branchIdA2typeDefinitionRefe = ? OR LCSDocument.branchIdA2typeDefinitionRefe = ? OR LCSDocument.branchIdA2typeDefinitionRefe = ? ) ORDER BY , LCSDocument.ptc_str_1typeInfoLCSDocument ASC, LCSDocument.versionSortIdA2versionInfo ASC, Error Msg = ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ... 132 more
最新バージョンはこちらを参照ください CS371948