Exporting / Printing problems in Infoview / CMC

[jazbar]

Hi All

I'm using Crystal Reports Server XI and Apache Tomcat 5.0.27.

The problem I have is with some reports that I run from either Infoview or from directly within the CMC by clicking "Preview".

Some reports run perfectly and allow you to export the report, however, some reports don't. These tend to be reports that take over 2 minutes or so to run.

The effected reports will run and display, but when you try to either print or export the report, the following messages are displayed:

In Infoview....

"An error has occurred: null"

In CMC...

"HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: String index out of range: -1
com.businessobjects.enterprise.wca.viewer.ReportViewerServlet.doGet(Unknown Source)
com.businessobjects.enterprise.wca.viewer.ReportViewerServlet.doPost(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.lang.StringIndexOutOfBoundsException: String index out of range: -1
java.lang.String.substring(String.java:1444)
com.crystaldecisions.sdk.occa.security.internal.l.logonWithToken(Unknown Source)
com.crystaldecisions.sdk.framework.internal.b.logonWithToken(Unknown Source)
com.businessobjects.enterprise.wca.viewer.ReportViewerServlet.doGet(Unknown Source)
com.businessobjects.enterprise.wca.viewer.ReportViewerServlet.doPost(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


note The full stack trace of the root cause is available in the Apache Tomcat/5.0.27 logs."

I have looked at the Apache log files and the full log for the error is as follows...

"2007-07-03 15:50:38 StandardWrapperValve[reportviewer]: Servlet.service() for servlet reportviewer threw exception
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1444)
at com.crystaldecisions.sdk.occa.security.internal.l.logonWithToken(Unknown Source)
at com.crystaldecisions.sdk.framework.internal.b.logonWithToken(Unknown Source)
at com.businessobjects.enterprise.wca.viewer.ReportViewerServlet.doGet(Unknown Source)
at com.businessobjects.enterprise.wca.viewer.ReportViewerServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)"

I wonder if anyone knows of any settings that I need to change to prevent this issue occurring. The reports work and are able to be exported directly from within CRXI.

Thank you in anticipation of your help.

 

[hilfy]

What database are you using? The one entry in the knowledgebase that I found for this particular error (StringIndexOutOfBoundsException) has to do with numeric precision in Oracle.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[jazbar]

Hi hily, Thanks for your reply.

It's an IBM iSeries server (or AS400) that is running db2.

I too found the same article relating to the numeric precision in Oracle.

I'm going to try and the suggestions made in the article and see if the same principle applies in this case.

I'll post my findings afterwards!

 

[jazbar]

Unfortunatley, still no joy.

 

[hilfy]

You may end up having to open a support case with Business Objects on this one....:-(

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[bleuys]

hi jazbar,

we had a simliar Problem whith viewing some Reports.

After Redeploying the CMC Application on Tomcat the Problem was solved.

 

[jazbar]

Hi bleuys

Thanks for your reply.

Did you have to reinstall the Crystal Reports Server software to do this? Would I lose all of the user account details, published reports, etc, if I did this?

Thanks again.

 

[bleuys]

Hi jazbar,

you don't have to reinstall the whole server software. You have only to redeploy the war archive of the CMC Application. If you don't know how to do it, search in Google for Tomcat and Deploying Apps.
The only thing is to find the war archive. As I remember you will find it under a folder named java whitin the installation folder of CR Server.