Error uploading report to Infoview

building reports crystal reports
1

Hi,

I’m using Crystal XI2 with Oracle backend. I defined a dynamic paramater in my report, it’s working fine when ran it in Crystal however when I tried to upload it to Infoview, it’s giving me this err msg : An unexpected error has occured.

Any idea?

Thanks

sofia (BOB member since 2009-01-09)

2

At what point does this error come up? When you are just uploading the report - or when you try to run the uploaded report?

Also, what happens when yuo try to publish/upload a really, really simple report based on Oracle (that way you can figure out if it has anything to do with the complexity of the report)?

And (important as well) what happens when you do the same thing with a report based on the sample Xtreme (Access) database (that way you can figure out if it has anything to do with Oracle)?

Orange :netherlands: (BOB member since 2006-09-18)

3

Hi,

I encountered the error when uploading the report to Infoview. But when I ran in Crystal editor, it’s working fine.

I tried to save it directly to the enterprise, still unsuccessful with the ff error message

Failed to read data from report file … Reason: Failed to read parameter object.

Tried to connect to xtreme database and upload to infoview : same error

Changed report pointing to xtreme database with parameter set to static.
This was uploaded successfully to infoview.

I don’t know what or where the problem is. :?

sofia (BOB member since 2009-01-09)

4

Could it be that you have a different Oracle Client version installed on the Crystal Reports designer machine compared to the Enterprise server?

Do you also have Crystal Reports installed on the actual Enterprise machine (not by default)? This would enable you to go through the same steps and narrow down the issue.

Also - you say that a new report based on Xtreme (Access) works fine without a parameter but gives the “Failed to read data from report file … Reason: Failed to read parameter object.” error message when you add a parameter?

Orange :netherlands: (BOB member since 2006-09-18)

5

I’ll check/try the first 2 things you suggested.

As for the xtreme report, I defined first a parameter that’s dynamic and uploaded to infoview. This didn’t work as well. I set it to static and uploaded to infoview successfully.

sofia (BOB member since 2009-01-09)

6

There is a suggestion on this site that you might want to check:

To resolve the error

1. Log on to Business View Manager as administrator.
2. Click View > Repository Explorer.
3. Right-click Dynamic Cascading Prompts. Click Edit Rights.
4. Click the appropriate user or group receiving the error.
5. Click the Granted option for the right to View, Edit & Set Security rights.
6. Click OK. Close Business View Manager.

The user or group is now able to save a report with dynamic parameters to Enterprise.

Also, when you have checked what version of XI you have, and it turns out you have and old version, try installing a servicepack (as suggested on that same page).

Also, here on this forum there was a suggestion to try and not use ODBC connections (create a dynamic cascading prompt) but I’d guess you’d be using a proper native Oracle connection. Can you verify that?

Orange :netherlands: (BOB member since 2006-09-18)

7

Thanks for all your input. I’ve also tried the sugggestion from the 2nd link you sent to no avail. Anyway, i will check the first link.

Thanks

sofia (BOB member since 2009-01-09)