Skip to Content
0
Former Member
Jan 05, 2009 at 05:32 PM

Question on InfoView Multiple Connections opening on SQL Database

14 Views

Hi, we are using Business Objects XI Release 2 and I am having an ODBC issue to a SQL 2005 database. I have a Crystal XI report that contains 2 parameters and selects roughly 100,000 rows of data and summarizes the data to 1 page. In Crystal Developer it runs fine in several seconds. Within Infoview it runs fine if I do a schedule now and select the parameters. The Issue is if I click on the published report, update the parameters, it then starts to run and run. Looking at the database it opens roughly 32 connections and just keeps opening and closing connections. Since I am invoking infoview through a url it is running on the same server that I can schedule on. I am not sure where or what the problem is, why so many connections open and the report never finishes. Also the connections are bogging down the SQL Database due to high CPU utilization. Any help/insight/explanations would be appreciated.

Thank You