Skip to Content
author's profile photo Former Member
Former Member

CRCAF00000030 error from OpenDocument

Running 4.1 SP1 Patch 2 (on Windows, with Tomcat) and we run into an error

"This error occurred: org.apache.jasper.JasperException: java.lang.StringIndexOutOfBoundsException: String index out of range: -1 [CRCAF00000030]"

when opening Crystals via OpenDocument links. The issue appears to be that OD is expecting prompt parameters and fails if it does not get them. I have found that by appending "&lsS" anywhere in the existing link query parameters it will work as intended, but there is nothing in the documentation that indicates the prompt parameters are required. The same works fine in XI3.1.

My only possible workaround right now is to use a URLRewriteFilter to correct the URL, but it's a bit brutish, and I'm wondering if anyone else has encountered this issue? If so how did you resolve it?

(Yes, I have an open support case, but they are "not able to reproduce the issue")

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2014 at 03:03 PM

    Hey Brian,

    We have that exact issue in 4.1 SP2 Patch 1 (happened when we upgraded from 4.0 to 4.1 SP1). We found that a user preference setting in the BI launch pad causes the error for crystal reports with parameters of the DateTime data type (steps to recreate below). Can you try these steps in your environment? Please keep us posted with any updates.

    1. Log into http://<BOE_SERVER>/BOE/BI and open the user's preferences

    2. Click on 'Crystal Reports' in the left panel

    3. Under 'Select printing control (for Web):' select the option for 'PDF one-click printing' and Save

    4. Attempt to open a crystal report with at least one date parameter through it's OpenDocument URL using the same user as in step 1

    5. Verify CRCAF00000030 error message

    6. Repeat steps 1 and 2

    7. Under 'Select printing control (for Web):' select the option for 'ActiveX one-click printing' and Save

    8. Repeat step 4 with the same OpenDocument URL

    9. Verify the report parameter form opens (no error)

    By the way, appending "&lsS" to the OpenDoc URL works in our environment as well. However, we have a custom Java SDK component that this workaround may not work for.

    Regards,

    Justin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2014 at 02:22 PM

    Hi Brian,

    I've replicated this issue in 4.1 SP2 Patch 1. Did you have any luck in finding the cause of this issue? Let me know as it might save me some investigative work.

    Cheers

    James

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I have a few environments with this version and not all of them are showing the issue.

      Couple questions:

      Are you seeing this issue across all browsers?

      If you look at cookie info for OpenDocumentPLATFORMSVC_COOKIE_CMS, does it list the correct CMS?

      If you look at the POST body sent with view.do, note the &objIds=??? &containerId=??? ids, do they match the id of the object and the parent folder of the object in enterprise for which you specified a CUID?

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2014 at 04:26 PM

    I managed to resolve this issue but unfortunately I still don't know the exact cause of the problem, however I will add that it would appear to relate to an issue in the system database rather than the web application deployment.

    The fix below is good enough for a scratch environment but I might need to do some comparisons against the before and after system databases to see if I can identify the root cause. I'd like to avoid carrying out the the below post deployment of 4.1 in production.

    Rebuilding the system database via the properties of the SIA in the CCM, followed by a reimport of the content using UMT resolved the issue. This fixed the problem in Chrome and Firefox however I was still seeing an issue in IE. After a bit of troubleshooting I spotted an issue with the cookies being sent back in the POST of view.do, flushing the winINET cache and winINET cookies using Fiddler fixed the residual problem in IE - hence the earlier questioning.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 13, 2014 at 06:26 PM

    Hi Brian,

    I've encountered this message before, however I was unable to reproduce this in-house with my own systems. It seems to be be environment specific.

    The discovered workaround is to append the end of the OpenDoc URL with:

    &lsS

    For reasons unknown it's been successful. Give it a try and let me know.

    Regards,

    Wallie

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2014 at 11:27 PM

    This post has been helpful, but I have a question. Using the below URL, if I want to test the work around of adding the &IsS where in this URL would I put this?

    http://pdboe01:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Aegxxem8RHpOuN0Cf3N2M9o&sIDType=CUID

    thanks!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2014 at 09:43 PM

    Hello,

    We are on BI 4.1 SP3, we went live 2 weeks ago with this version and everything was working fine until today that we start experiencing this error.

    The proposed solution appending the "lsS" works, but just wanted to let everyone know that still on BI 4.1 SP3 has not been resolved.

    Thanks,

    Daniel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.