Article - CS197834
Red Error occurs when navigatiogn to Line Sheet by clickong on the Side Menu in FlexPLM 10.1 M040
Modified: 24-Apr-2017
Applies To
- FlexPLM 10.1 M040
Description
- Red error occurs when navigatiogn to Line Sheet by clicking on the Side Menu
- Error on the page:
The system is unable to process your request at this time.
Please try again later. if the probolem persists contact your system administrator.
Please try again later. if the probolem persists contact your system administrator.
- Errors in the log:
#################################################################
url = ?activity=VIEW_LINE_PLAN&action=INIT&oid=VR:com.lcs.wc.season.LCSSeason:1343747&oidList=null&typeOid=null&typeAttributeOid=null&tabId=&tabPage=null
#################################################################
Fri Jan 23 23:30:35 GMT 2015: QueryTaskrunPreparedStatementQuery: EXCEPTION OCCURED ON STATEMENT: SELECT LCSProduct.idA2A2, LCSProduct.idA3A11, LCSProduct.versionIdA2versionInfo, LCSProduct.branchIditerationInfo, LCSProduct.idA3masterReference, LCSProduct.createStampA2, LCSProduct.modifyStampA2, LCSProduct.idA3B2iterationInfo, LCSProduct.idA3D2iterationInfo, LCSProduct.statestate, LCSProduct.typeDisplay, LCSProduct.partPrimaryImageURL, LCSProduct.idA3A12, FlexType.idA2A2, FlexType.typeName, LCSSKU.idA2A2, LCSSKU.versionIdA2versionInfo, LCSSKU.branchIditerationInfo, LCSSKU.idA3masterReference, LCSSKU.placeholder, LCSSKU.modifyStampA2, LCSSKU.partPrimaryImageURL, LCSSeasonProductLink.productSeasonRevId, LCSSeasonProductLink.skuState, LCSColor.colorHexidecimalValue, LCSColor.thumbnail, LCSSeasonProductLink.idA2A2, LCSSeasonProductLink.idA3A5, LCSSeasonProductLink.effectInDate, LCSSeasonProductLink.skuSeasonRevId, LCSSeasonProductLink.prodState, LCSSeasonProductLink.seasonRevId, LCSSourceToSeasonLink.branchIditerationInfo, LCSSourcingConfig.branchIditerationInfo, LCSSourcingConfig.idA3masterReference, LCSSourcingConfig.idA2A2, LCSSourcingConfig.modifyStampA2, LCSSourceToSeasonLink.idA2A2, LCSSKUSourcingLink.idA2A2, LCSSKUSourcingLink.active, LCSCostSheet.idA2A2, LCSCostSheet.branchIditerationInfo, LCSCostSheet.idA3masterReference, LCSCostSheet.modifyStampA2, LCSCostSheet.applicableColorNames, LCSCostSheet.applicableSizeCategoryNames, LCSCostSheet.applicableDestinationNames, LCSCostSheet.applicableSizes, LCSCostSheet.applicableSizes2, LCSCostSheet.costSheetType, LCSCostSheet.whatIf, LCSCostSheet.primaryCostSheet, LCSCostSheet.att1, FlexSpecification.att1, FlexSpecification.idA3masterReference, FlexSpecification.branchIditerationInfo, FlexSpecification.idA2A2, LCSSourceToSeasonLinkMaster.idA2A2, LCSSourceToSeasonLinkMaster.primarySTSL, T313818410.att1, T313818410.idA2A2, LCSProduct.num1, T45184474.att1, T45184474.branchIditerationInfo, LCSProduct.num14, T962367335.att1, T962367335.branchIditerationInfo, LCSProduct.num13, T17496343.att1, T17496343.branchIditerationInfo, LCSProduct.num11, T825048152.att1, T825048152.branchIditerationInfo, LCSProduct.num12, T162770371.att1, T162770371.idA2A2, LCSProduct.num9, T591741415.att1, T591741415.branchIditerationInfo, LCSProduct.num17, T438325674.att1, T438325674.idA2A2, LCSProduct.num16, T491421221.att1, T491421221.branchIditerationInfo, LCSProduct.num10, T123509774.att1, T123509774.branchIditerationInfo, LCSProduct.num15, LCSProduct.att1, LCSProduct.att34, LCSProduct.att18, LCSProduct.num4, LCSSKU.att6, LCSSKU.att5, LCSSKU.att9, LCSSKU.att7, LCSSKU.att1, T679280604.att1, T679280604.idA2A2, LCSSKU.num1, LCSSeasonProductLink.att23, T9563810.att1, T9563810.idA2A2, LCSSeasonProductLink.num18, T768507552.att1, T768507552.idA2A2, LCSSeasonProductLink.num19, LCSSeasonProductLink.att16, LCSSeasonProductLink.att18, T405467847.att1, T405467847.idA2A2, LCSSeasonProductLink.num17, LCSSeasonProductLink.att25, LCSSeasonProductLink.att24, T391012003.att1, T391012003.branchIditerationInfo, LCSSourcingConfig.num2, T1495930192.att1, T1495930192.branchIditerationInfo, LCSSourcingConfig.num1, T084113700.att1, T084113700.branchIditerationInfo, LCSSourcingConfig.num3, LCSSourcingConfig.att1, T243943226.materialSupplierName, T243943226.branchIditerationInfo, LCSSourceToSeasonLink.num3, LCSSKUSourcingLink.att4, LCSSeasonProductLink.idA3D8 FROM ((skuarev LCSSKU LEFT OUTER JOIN LCSColor ON LCSSKU.num1 = LCSColor.idA2A2) LEFT OUTER JOIN LCSColor T679280604 ON LCSSKU.num1 = T679280604.idA2A2),(lcscostsheet_eff LCSCostSheet LEFT OUTER JOIN LatestIterFlexSpecification FlexSpecification ON LCSCostSheet.idA3D11 = FlexSpecification.idA3masterReference),((((((((((prodarev LCSProduct LEFT OUTER JOIN LCSLifecycleManaged T313818410 ON LCSProduct.num1 = T313818410.idA2A2) LEFT OUTER JOIN LatestIterLCSRevisableEntity T45184474 ON LCSProduct.num14 = T45184474.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSRevisableEntity T962367335 ON LCSProduct.num13 = T962367335.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSRevisableEntity T17496343 ON LCSProduct.num11 = T17496343.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSRevisableEntity T825048152 ON LCSProduct.num12 = T825048152.branchIditerationInfo) LEFT OUTER JOIN LCSLifecycleManaged T162770371 ON LCSProduct.num9 = T162770371.idA2A2) LEFT OUTER JOIN LatestIterLCSDocument T591741415 ON LCSProduct.num17 = T591741415.branchIditerationInfo) LEFT OUTER JOIN LCSLifecycleManaged T438325674 ON LCSProduct.num16 = T438325674.idA2A2) LEFT OUTER JOIN LatestIterLCSLast T491421221 ON LCSProduct.num10 = T491421221.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSMaterial T123509774 ON LCSProduct.num15 = T123509774.branchIditerationInfo),(((skuseasonlink LCSSeasonProductLink LEFT OUTER JOIN LCSLifecycleManaged T9563810 ON LCSSeasonProductLink.num18 = T9563810.idA2A2) LEFT OUTER JOIN LCSLifecycleManaged T768507552 ON LCSSeasonProductLink.num19 = T768507552.idA2A2) LEFT OUTER JOIN LCSLifecycleManaged T405467847 ON LCSSeasonProductLink.num17 = T405467847.idA2A2),(((lcssourcingconfig_eff LCSSourcingConfig LEFT OUTER JOIN LatestIterLCSSupplier T391012003 ON LCSSourcingConfig.num2 = T391012003.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSSupplier T1495930192 ON LCSSourcingConfig.num1 = T1495930192.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSSupplier T084113700 ON LCSSourcingConfig.num3 = T084113700.branchIditerationInfo),(lcssourcetoseasonlink_eff LCSSourceToSeasonLink LEFT OUTER JOIN V_LCSMaterialSupplier T243943226 ON LCSSourceToSeasonLink.num3 = T243943226.branchIditerationInfo),FlexType,productseasonlink PRODSEASONLINK,LCSSKUSourcingLink,LCSSourceToSeasonLinkMaster WHERE LCSProduct.idA3A11 = FlexType.idA2A2 AND LCSProduct.idA3masterReference = LCSSKU.idA3A12 AND LCSProduct.idA3A12 = PRODSEASONLINK.idA3A5 AND LCSSKU.idA3masterReference = LCSSeasonProductLink.idA3A5 AND PRODSEASONLINK.productMasterId = LCSSeasonProductLink.productMasterId AND PRODSEASONLINK.idA3B5 = LCSSeasonProductLink.idA3B5 AND LCSSourcingConfig.productARevId = LCSProduct.branchIditerationInfo AND LCSSourcingConfig.idA3masterReference = LCSSourceToSeasonLink.sourcingConfigMasterId AND LCSSourceToSeasonLink.seasonMasterId = LCSSeasonProductLink.idA3B5 AND LCSSKUSourcingLink.idA3A5 = LCSSKU.idA3masterReference AND LCSSKUSourcingLink.idA3B5 = LCSSourcingConfig.idA3masterReference AND LCSSKUSourcingLink.idA3A7 = LCSSeasonProductLink.idA3B5 AND LCSCostSheet.seasonMasterId = LCSSeasonProductLink.idA3B5 AND LCSCostSheet.sourceMasterId = LCSSourcingConfig.idA3masterReference AND LCSCostSheet.skuMasterId = LCSSeasonProductLink.idA3A5 AND LCSSourceToSeasonLink.idA3masterReference = LCSSourceToSeasonLinkMaster.idA2A2 AND ( ((LCSSeasonProductLink.seasonRemoved IS NULL ) OR (LCSSeasonProductLink.seasonRemoved = '' )) OR LCSSeasonProductLink.seasonRemoved = '0' ) AND ( LCSCostSheet.primaryCostSheet = '1' OR LCSCostSheet.costSheetType = 'SKU' ) AND LCSCostSheet.whatIf = '0' AND LCSSourceToSeasonLinkMaster.primarySTSL = '1' AND LCSSeasonProductLink.idA3B5 = ? AND LCSSourceToSeasonLink.seasonMasterId = ? AND ( LCSProduct.idA3A11 = ? ) AND ( ( ) OR LCSSKU.placeholder = '1' ) ORDER BY LCSProduct.att1 , LCSSKU.att1
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.
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)
at com.lcs.wc.season.LineSheetQuery.runSeasonProductReport(LineSheetQuery.java:982)
at org.apache.jsp.rfa.jsp.season.LinePlan_jsp._jspService(LinePlan_jsp.java:749)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
at org.apache.jsp.rfa.jsp.main.MainTemplate_jsp._jspService(MainTemplate_jsp.java:467)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:746)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:716)
at org.apache.jsp.rfa.jsp.season.SeasonController_jsp._jspService(SeasonController_jsp.java:1163)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:746)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:716)
at org.apache.jsp.rfa.jsp.main.Main_jsp._jspService(Main_jsp.java:412)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.lcs.wc.client.PDMLinkHomePageFilter.doFilter(PDMLinkHomePageFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.lcs.wc.util.CharsetFilter.doFilter(CharsetFilter.java:85)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:98)
at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:248)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:327)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1594)
at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
at org.apache.tomcat.util.threads.TaskThread.run(TaskThread.java:77)
url = ?activity=VIEW_LINE_PLAN&action=INIT&oid=VR:com.lcs.wc.season.LCSSeason:1343747&oidList=null&typeOid=null&typeAttributeOid=null&tabId=&tabPage=null
#################################################################
Fri Jan 23 23:30:35 GMT 2015: QueryTaskrunPreparedStatementQuery: EXCEPTION OCCURED ON STATEMENT: SELECT LCSProduct.idA2A2, LCSProduct.idA3A11, LCSProduct.versionIdA2versionInfo, LCSProduct.branchIditerationInfo, LCSProduct.idA3masterReference, LCSProduct.createStampA2, LCSProduct.modifyStampA2, LCSProduct.idA3B2iterationInfo, LCSProduct.idA3D2iterationInfo, LCSProduct.statestate, LCSProduct.typeDisplay, LCSProduct.partPrimaryImageURL, LCSProduct.idA3A12, FlexType.idA2A2, FlexType.typeName, LCSSKU.idA2A2, LCSSKU.versionIdA2versionInfo, LCSSKU.branchIditerationInfo, LCSSKU.idA3masterReference, LCSSKU.placeholder, LCSSKU.modifyStampA2, LCSSKU.partPrimaryImageURL, LCSSeasonProductLink.productSeasonRevId, LCSSeasonProductLink.skuState, LCSColor.colorHexidecimalValue, LCSColor.thumbnail, LCSSeasonProductLink.idA2A2, LCSSeasonProductLink.idA3A5, LCSSeasonProductLink.effectInDate, LCSSeasonProductLink.skuSeasonRevId, LCSSeasonProductLink.prodState, LCSSeasonProductLink.seasonRevId, LCSSourceToSeasonLink.branchIditerationInfo, LCSSourcingConfig.branchIditerationInfo, LCSSourcingConfig.idA3masterReference, LCSSourcingConfig.idA2A2, LCSSourcingConfig.modifyStampA2, LCSSourceToSeasonLink.idA2A2, LCSSKUSourcingLink.idA2A2, LCSSKUSourcingLink.active, LCSCostSheet.idA2A2, LCSCostSheet.branchIditerationInfo, LCSCostSheet.idA3masterReference, LCSCostSheet.modifyStampA2, LCSCostSheet.applicableColorNames, LCSCostSheet.applicableSizeCategoryNames, LCSCostSheet.applicableDestinationNames, LCSCostSheet.applicableSizes, LCSCostSheet.applicableSizes2, LCSCostSheet.costSheetType, LCSCostSheet.whatIf, LCSCostSheet.primaryCostSheet, LCSCostSheet.att1, FlexSpecification.att1, FlexSpecification.idA3masterReference, FlexSpecification.branchIditerationInfo, FlexSpecification.idA2A2, LCSSourceToSeasonLinkMaster.idA2A2, LCSSourceToSeasonLinkMaster.primarySTSL, T313818410.att1, T313818410.idA2A2, LCSProduct.num1, T45184474.att1, T45184474.branchIditerationInfo, LCSProduct.num14, T962367335.att1, T962367335.branchIditerationInfo, LCSProduct.num13, T17496343.att1, T17496343.branchIditerationInfo, LCSProduct.num11, T825048152.att1, T825048152.branchIditerationInfo, LCSProduct.num12, T162770371.att1, T162770371.idA2A2, LCSProduct.num9, T591741415.att1, T591741415.branchIditerationInfo, LCSProduct.num17, T438325674.att1, T438325674.idA2A2, LCSProduct.num16, T491421221.att1, T491421221.branchIditerationInfo, LCSProduct.num10, T123509774.att1, T123509774.branchIditerationInfo, LCSProduct.num15, LCSProduct.att1, LCSProduct.att34, LCSProduct.att18, LCSProduct.num4, LCSSKU.att6, LCSSKU.att5, LCSSKU.att9, LCSSKU.att7, LCSSKU.att1, T679280604.att1, T679280604.idA2A2, LCSSKU.num1, LCSSeasonProductLink.att23, T9563810.att1, T9563810.idA2A2, LCSSeasonProductLink.num18, T768507552.att1, T768507552.idA2A2, LCSSeasonProductLink.num19, LCSSeasonProductLink.att16, LCSSeasonProductLink.att18, T405467847.att1, T405467847.idA2A2, LCSSeasonProductLink.num17, LCSSeasonProductLink.att25, LCSSeasonProductLink.att24, T391012003.att1, T391012003.branchIditerationInfo, LCSSourcingConfig.num2, T1495930192.att1, T1495930192.branchIditerationInfo, LCSSourcingConfig.num1, T084113700.att1, T084113700.branchIditerationInfo, LCSSourcingConfig.num3, LCSSourcingConfig.att1, T243943226.materialSupplierName, T243943226.branchIditerationInfo, LCSSourceToSeasonLink.num3, LCSSKUSourcingLink.att4, LCSSeasonProductLink.idA3D8 FROM ((skuarev LCSSKU LEFT OUTER JOIN LCSColor ON LCSSKU.num1 = LCSColor.idA2A2) LEFT OUTER JOIN LCSColor T679280604 ON LCSSKU.num1 = T679280604.idA2A2),(lcscostsheet_eff LCSCostSheet LEFT OUTER JOIN LatestIterFlexSpecification FlexSpecification ON LCSCostSheet.idA3D11 = FlexSpecification.idA3masterReference),((((((((((prodarev LCSProduct LEFT OUTER JOIN LCSLifecycleManaged T313818410 ON LCSProduct.num1 = T313818410.idA2A2) LEFT OUTER JOIN LatestIterLCSRevisableEntity T45184474 ON LCSProduct.num14 = T45184474.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSRevisableEntity T962367335 ON LCSProduct.num13 = T962367335.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSRevisableEntity T17496343 ON LCSProduct.num11 = T17496343.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSRevisableEntity T825048152 ON LCSProduct.num12 = T825048152.branchIditerationInfo) LEFT OUTER JOIN LCSLifecycleManaged T162770371 ON LCSProduct.num9 = T162770371.idA2A2) LEFT OUTER JOIN LatestIterLCSDocument T591741415 ON LCSProduct.num17 = T591741415.branchIditerationInfo) LEFT OUTER JOIN LCSLifecycleManaged T438325674 ON LCSProduct.num16 = T438325674.idA2A2) LEFT OUTER JOIN LatestIterLCSLast T491421221 ON LCSProduct.num10 = T491421221.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSMaterial T123509774 ON LCSProduct.num15 = T123509774.branchIditerationInfo),(((skuseasonlink LCSSeasonProductLink LEFT OUTER JOIN LCSLifecycleManaged T9563810 ON LCSSeasonProductLink.num18 = T9563810.idA2A2) LEFT OUTER JOIN LCSLifecycleManaged T768507552 ON LCSSeasonProductLink.num19 = T768507552.idA2A2) LEFT OUTER JOIN LCSLifecycleManaged T405467847 ON LCSSeasonProductLink.num17 = T405467847.idA2A2),(((lcssourcingconfig_eff LCSSourcingConfig LEFT OUTER JOIN LatestIterLCSSupplier T391012003 ON LCSSourcingConfig.num2 = T391012003.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSSupplier T1495930192 ON LCSSourcingConfig.num1 = T1495930192.branchIditerationInfo) LEFT OUTER JOIN LatestIterLCSSupplier T084113700 ON LCSSourcingConfig.num3 = T084113700.branchIditerationInfo),(lcssourcetoseasonlink_eff LCSSourceToSeasonLink LEFT OUTER JOIN V_LCSMaterialSupplier T243943226 ON LCSSourceToSeasonLink.num3 = T243943226.branchIditerationInfo),FlexType,productseasonlink PRODSEASONLINK,LCSSKUSourcingLink,LCSSourceToSeasonLinkMaster WHERE LCSProduct.idA3A11 = FlexType.idA2A2 AND LCSProduct.idA3masterReference = LCSSKU.idA3A12 AND LCSProduct.idA3A12 = PRODSEASONLINK.idA3A5 AND LCSSKU.idA3masterReference = LCSSeasonProductLink.idA3A5 AND PRODSEASONLINK.productMasterId = LCSSeasonProductLink.productMasterId AND PRODSEASONLINK.idA3B5 = LCSSeasonProductLink.idA3B5 AND LCSSourcingConfig.productARevId = LCSProduct.branchIditerationInfo AND LCSSourcingConfig.idA3masterReference = LCSSourceToSeasonLink.sourcingConfigMasterId AND LCSSourceToSeasonLink.seasonMasterId = LCSSeasonProductLink.idA3B5 AND LCSSKUSourcingLink.idA3A5 = LCSSKU.idA3masterReference AND LCSSKUSourcingLink.idA3B5 = LCSSourcingConfig.idA3masterReference AND LCSSKUSourcingLink.idA3A7 = LCSSeasonProductLink.idA3B5 AND LCSCostSheet.seasonMasterId = LCSSeasonProductLink.idA3B5 AND LCSCostSheet.sourceMasterId = LCSSourcingConfig.idA3masterReference AND LCSCostSheet.skuMasterId = LCSSeasonProductLink.idA3A5 AND LCSSourceToSeasonLink.idA3masterReference = LCSSourceToSeasonLinkMaster.idA2A2 AND ( ((LCSSeasonProductLink.seasonRemoved IS NULL ) OR (LCSSeasonProductLink.seasonRemoved = '' )) OR LCSSeasonProductLink.seasonRemoved = '0' ) AND ( LCSCostSheet.primaryCostSheet = '1' OR LCSCostSheet.costSheetType = 'SKU' ) AND LCSCostSheet.whatIf = '0' AND LCSSourceToSeasonLinkMaster.primarySTSL = '1' AND LCSSeasonProductLink.idA3B5 = ? AND LCSSourceToSeasonLink.seasonMasterId = ? AND ( LCSProduct.idA3A11 = ? ) AND ( ( ) OR LCSSKU.placeholder = '1' ) ORDER BY LCSProduct.att1 , LCSSKU.att1
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.
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)
at com.lcs.wc.season.LineSheetQuery.runSeasonProductReport(LineSheetQuery.java:982)
at org.apache.jsp.rfa.jsp.season.LinePlan_jsp._jspService(LinePlan_jsp.java:749)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
at org.apache.jsp.rfa.jsp.main.MainTemplate_jsp._jspService(MainTemplate_jsp.java:467)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:746)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:716)
at org.apache.jsp.rfa.jsp.season.SeasonController_jsp._jspService(SeasonController_jsp.java:1163)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:746)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:716)
at org.apache.jsp.rfa.jsp.main.Main_jsp._jspService(Main_jsp.java:412)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.lcs.wc.client.PDMLinkHomePageFilter.doFilter(PDMLinkHomePageFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.lcs.wc.util.CharsetFilter.doFilter(CharsetFilter.java:85)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:98)
at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:248)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:327)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1594)
at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
at org.apache.tomcat.util.threads.TaskThread.run(TaskThread.java:77)
This is a printer-friendly version of Article 197834 and may be out of date. For the latest version click CS197834