We are getting very strange and critical problem.
We are calling an Oracle stored procedure(without error handler) inside a package through Crystal Reports; when the stored procedure throws an error the Crystal Report Designer showing the error message box fine but when the same report run on demand on Business Object Info view it is not displaying the error instead it continuously hitting the database for every two seconds eventually database is failing because of continuously hitting the database.
Environment:
OS: Windows Server
Enterprise Database: SQL Server 2003
Report Database: Oracle 9i
Report: Crystal Reports XI
Business Objects: BO XI R2