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

Connection error when refreshing an ODBC connected Crystal report

Hi experts,

I've got an issue when trying to refresh or Publish a report crystal based on an ODBC connection (excel or access).

I've 2 kind of reports on my BI Launch pad (BOE 4.0) :

- Ones with BICS connection which works perfectly

- Ones with ODBC connection.

If I open the ODBC's ones with Crystal reports client, I can refresh them without trouble.

If I try to refresh them from BI Launch pad or if try to publish them with update I face the following message(publish without update works) :

"The viewer could not process an event. The data source is invalid: '[] <java.lang.NullPointerException: while trying to invoke the method org.eclipse.emf.common.util.URI.isPlatform() of an object loaded from local variable 'uri'>'. Please contact the maintainer of the data source to solve the problem. [JRC00005380]

-


Error code:0 [CRWEB00000119]".

The BO database is on MS SQL Express 2008.

The BO version is BOE 4.0 SP2

The CR version is Crystal Reports for Enterprise SP2.

Thanks in advance for your help.

Regards,

Thomas.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2011 at 08:12 AM

    Little update :

    The source files (.mdb and .xls) are not secured. So on Database Connection tab of the report on CMC I have the following :

    "This report does not require any database configuration"

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 12, 2013 at 09:09 PM

    Hi:

    Someone resolved this issue?

    This Resolution don't works with BICS

    1. Log in to CMC.

    2. Locate the report.

    3. Right click on the report, select 'Database Configuration'.

    4. Provide correct database connection details and click on 'Update'.

    5. Re-run the report from Infoview.

    I'm using CR for Enterprise 4 with SP5 & BI 7.0

    Greetings

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 06, 2013 at 05:49 PM

    I have the same issue.

    I've created 32 and 64 bit ODBC drivers with the same DNS names and still receive this error when running any report from the BI Launch pad:

    The viewer could not process an event. The data source is invalid: '[] <java.lang.IllegalArgumentException: Invalid shortcut: LATE_BINDING_URI.lbu>'. Please contact the maintainer of the data source to solve the problem. [JRC00005380]

    ---- Error code:0 [CRWEB00000119]

    Please help someone

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Salim Shaikh

      Hi,

      We have almost the same issue on our side. When we try to View CR reports for Auditing (delivered by SAP without support) we get connection error. But same report runs fine by scheduling .

      We have also created the ODBC Connection in SQL Server 2008 with 32 bit and 64 bit , but it did not solve the problem.


      It is obvious that client CR uses ODBC 32 conn, But BI Launchpad uses ODBC 64 bit conn.


      Any ideas ?.

      Regards

      M. Zeybek.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2014 at 05:45 PM

    Hi,

    I think that not one have found a solution so I am still looking for a source of solution

    Denis

    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.