I am blocked with this error message:
HTTP Status 500 – Internal Server Error
Type Exception Report
Message An exception occurred processing [/index.jsp] at line [27]
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.apache.jasper.JasperException: An exception occurred processing [/index.jsp] at line [27]
24: StiReport report = StiSerializeManager.deserializeReport(new File(reportPath));
25: StiJDBCDatabase dbOracleCPA_RT1 = (StiJDBCDatabase)report.getDictionary().getDatabases().get("OracleCXRT");
26: dbOracleCPA_RT1.setConnectionString("url=jdbc:oracle:thin:@db.awfm.co:11521/test.awfm.co;user=XXXXXXXXX;password=*************");
27: report.render();
28: StiWebViewerOptions options = new StiWebViewerOptions();
29: pageContext.setAttribute("report", report);
30: pageContext.setAttribute("options", options);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:625)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:514)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Root Cause
java.lang.RuntimeException: Missing IN or OUT parameter at index:: 1
StiJDBCDatabase [promptUserNameAndPassword=false, url=jdbc:oracle:thin:@db.awfm.co:11521/test.awfm.co, user=XXXXXXXXXXXXXXXXXX, password=YYYYYYYYY, driver=oracle.jdbc.OracleDriver, other={}]
com.stimulsoft.report.dictionary.StiDictionary.connect(StiDictionary.java:1260)
com.stimulsoft.report.dictionary.StiDictionary.connect(StiDictionary.java:1233)
com.stimulsoft.report.engine.engineV2.StiRenderProviderV2.ConnectToData(StiRenderProviderV2.java:442)
com.stimulsoft.report.engine.engineV2.StiRenderProviderV2.Render(StiRenderProviderV2.java:129)
com.stimulsoft.report.engine.engineV2.builders.StiReportV2Builder.RenderSingleReport(StiReportV2Builder.java:64)
com.stimulsoft.report.StiReport.RenderReport(StiReport.java:2064)
com.stimulsoft.report.StiReport.Render(StiReport.java:1979)
com.stimulsoft.report.StiReport.Render(StiReport.java:1914)
com.stimulsoft.report.StiReport.Render(StiReport.java:1904)
com.stimulsoft.report.StiReport.Render(StiReport.java:1889)
com.stimulsoft.report.StiReport.render(StiReport.java:1872)
org.apache.jsp.index_jsp._jspService(index_jsp.java:177)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
My Query has 2 parameters and those are set based on variables. In Reports Designer it is working.
Attaching report for reference.
