on 07-30-2009 10:49 PM
Hi,
From my jsp I am calling a rpt which is using a stored proc. When I try to pass the parameter values which is same as the default values in the report it works fine but for all other values I am getting the error as shown below.
Pls help.
<br><br>
detected an exception: Unexpected database connector error
at com.crystaldecisions.reports.datafoundation.DFQuery.for(Unknown Source)
at com.crystaldecisions.reports.datalayer.a.do(Unknown Source)
at com.crystaldecisions.reports.datalayer.a.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.b(Unknown Source)
at com.crystaldecisions.reports.dataengine.j.b(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.o(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.ContextNode.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.ContextNode.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.j.case(Unknown Source)
at com.crystaldecisions.reports.dataengine.h.<init>(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataContext.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.new(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.try(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.int(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.I(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.fl(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.if(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.X(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.moveToPageN(Unknown Source)
at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(Unknown Source)
at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.byte(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(Unknown Source)
at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
at com.businessobjects.sdk.erom.jrc.a.a(Unknown Source)
at com.businessobjects.sdk.erom.jrc.a.execute(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ds.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.getPage(Unknown Source)
at com.businessobjects.report.web.event.s.a(Unknown Source)
at com.businessobjects.report.web.event.s.a(Unknown Source)
at com.businessobjects.report.web.event.bt.a(Unknown Source)
at com.businessobjects.report.web.event.bw.broadcast(Unknown Source)
at com.businessobjects.report.web.event.am.a(Unknown Source)
at com.businessobjects.report.web.a.t.if(Unknown Source)
at com.businessobjects.report.web.e.a(Unknown Source)
at com.businessobjects.report.web.e.a(Unknown Source)
at com.businessobjects.report.web.e.a(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unknown Source)
at org.apache.jsp.pages.CrystalReportViewer_jsp._jspService(CrystalReportViewer_jsp.java:90)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
Edited by: sb-onward on Jul 31, 2009 8:10 PM
Hi there,
I currently have the same stacktrace when I open a report. I tried to remove the java code which adds the parameters to the ReportClientDocument. when I open the report I get a parameter popup without inputfields.
Other reports with parameters are opening correct. Can anyone tell me what my problem is?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check whether you are running report with saved data,
Is is prompting for parameter value?
Regards,
Tej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for your reply. When I run the report without the saved data it does prompts for the new value but then it gives the same error. Also from the crystal designer if I pass the same new values(the one that I am trying to pass from jsp) there it works fine from designer. But from jsp it still is not working. Any suggestion pls.
Regards,
Sanjay
I got the problem why I was getting this error. Just listing my findings here. The stored procedures takes 4 parameters and one of the parameter has a data type of Varchar(MAX). The report works fine from the crystal designer for this procedure. For some reason unknown crsytal sdk throws the error for this same procedure. I changed the procedure for varchar(MAX) to varchar(255) and created a new report. Now it works fine in designer as well as in jsp
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.