技术文章 - CS371948

升级到 FlexPLM 12.0 后无法使用默认系统视图执行文档库搜索

已修改: 28-Jun-2022   


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

适用于

  • FlexPLM 12.0

说明

  • 升级到 FlexPLM 12.0 后无法使用特定的默认系统视图执行文档库搜索
  • 用户界面错误:
    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
这是文章 371948 的 PDF 版本,可能已过期。最新版本 CS371948