When I run my application from the localhost, the report runs fine. The report has drilldown functionality. so when the data on the report is clicked, the report processes a SP and fetches the child nodes. Everything works fine on localhost. We are using weblogic to host the application. Now when I deploy the report to the server, the report fetches the data and drilldown works. After I repeat the process for a couple of times, i get an error as follows:
Failed to retrieve data from the database. Failed to retrieve data from the database. Error in File {1679199D-A6D6-11DE-B5FE-01005E000001}.rpt: Failed to retrieve data from the database.
However on the local host ,this issue is not there. The admin folks are saying that it might be an issue with the connection pool on the crystal reporting server. I am new to working on the server, Has anyone encountered this problem and the possible solution if there is one to debug this problem.
Thanks,
Kiran
IP Logged