• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Database Overrride Issue in 11g

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
9/15/2010 7:30 PM
Has anybody seen issues with the database override function with Oracle 11g and LBI 9.0.4. We have a number of odbc reports that were published and now with the oracle 11g upgrade from Oracle 10gR2 they have stpeed refreshing.

Basically the database override function is not working when the reports point to the new DSN on the reporting services page and we are seeing this only on our upgrade to 11gR2.


Has anybody experienced this?
Matthew Nye
Veteran Member Send Private Message
Posts: 514
Veteran Member
9/15/2010 7:44 PM
In previous releases there was an issue where the override wasnt working with ODBC and if you wanted to change data sources you had to change it in the Crystal file to match the override. I thought this was corrected but you might want to try this.
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
9/15/2010 8:00 PM
As you explained I changed the report source on lawson documents and saved the rpt. I then went into the data settings for the report and mapped it to the odbc datasource and refreshing it.

The results are not consistent. In some cases this seems to have resolved the issue and in some cases it gives the odbc login page when viewing t5he latest instance after I sucessfully created a historical instance.

Why would this happen where the results are not consisitent.