Article - CS210373
When running a customized report from Linesheet, "com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'." is encountered in FlexPLM 10.1 M020
Modified: 19-Aug-2017
Applies To
- FlexPLM 10.1 M020
Description
- When running a customized report from Linesheet, com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'. is encountered
- Errors:
wt.util.WTException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'.
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'.
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 com.lcs.wc.db.QueryTask.runPreparedStatementQuery(QueryTask.java:93)
at com.lcs.wc.db.QueryTask.runQuery(QueryTask.java:53)
at com.lcs.wc.db.Query.runPreparedQuery(Query.java:229)
at com.lcs.wc.db.Query.runQuery(Query.java:194)
at com.lcs.wc.foundation.LCSQuery.runDirectQuery(LCSQuery.java:218)
at com.lcs.wc.foundation.LCSQuery.runDirectQuery(LCSQuery.java:208)a
at com.lcs.wc.material.MaterialPricingEntryQuery.getPrice(MaterialPricingEntryQuery.java:696)
This is a printer-friendly version of Article 210373 and may be out of date. For the latest version click CS210373