cancel
Showing results for 
Search instead for 
Did you mean: 

Unexpected database connector error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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?

Former Member
0 Kudos

Hi,

Please check whether you are running report with saved data,

Is is prompting for parameter value?

Regards,

Tej

Former Member
0 Kudos

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

Former Member
0 Kudos

Well, If you dont pass any values from code then it always prompts for the values.

Try by passing no values from code.

Regards,

Tej

Former Member
0 Kudos

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