Troubleshooting SQL Server 2008 Business Intelligence Development Studio

If you have problems with SQL Server 2008 Business Intelligence Development Studio, review this troubleshooting checklist to find potential solutions.

Best Microsoft MCTS Certification, Microsoft MCITP Training
at certkingdom.com

1. Install the latest SQL Server 2008 service pack.
Because many Business Intelligence Development Studio (BIDS) bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack.
At the time this article was written the latest SQL Server 2008 service pack was service pack 2.

You can download the SQL Server 2008 service pack 2 at here:
https://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17&displaylang=en

2. You cannot open a Business Intelligence (BI) project after you upgrade this project to the Visual Studio 2010 format.
This problem occurs because Visual Studio 2010 does not let you edit a BI project that is created by using BIDS in SQL Server 2008. To resolve this problem, you should create a new SQL Server BIDS project with the same name as the original BI project in a different directory, add all relevant project items from the upgraded BI project folder and then save the new BI project. Now, you can open a new BI project in Visual Studio 2010 or in SQL Server 2008 BIDS.

3. You may be prompted for credentials indefinitely when you use BIDS to deploy a SQL Server 2008 Reporting Services report.

This problem occurs when you configure SQL Server 2008 Reporting Services to run in SharePoint integrated mode. This bug was first fixed in Cumulative update package 9 for SQL Server 2008. You can download the Cumulative update package 9 for SQL Server 2008 at here:
https://support.microsoft.com/kb/977444

4. The error occurs when you run a SQL Server 2008 Reporting Services report in Business Intelligence Development Studio.

This is the error message text: “An item with the same key has already been added”. This problem occurs when a subreport is shared two or more times for use in an outer subreport. This bug was first fixed in Cumulative update package 3 for SQL Server 2008 Service Pack 1. You can download the Cumulative update package 3 for SQL Server 2008 Service Pack 1 at here:
https://support.microsoft.com/kb/971491/LN

5. When you try to deploy the Data Mining Model Training task in an Integration Services project in BIDS, the mining model opens a blank task editor window.

This is SQL Server 2008 bug. This bug was first fixed in Cumulative update package 1 for SQL Server 2008. You can download the Cumulative update package 1 for SQL Server 2008 at here: https://support.microsoft.com/kb/956717

6. SQL Server 2008 BIDS may stop responding when you stop debugging a SQL Server 2008 Integration Services (SSIS) package.

This is SQL Server 2008 bug. This bug was first fixed in Cumulative update package 4 for SQL Server 2008 Service Pack 2. You can download the Cumulative update package 4 for SQL Server 2008 Service Pack 2 at here: https://support.microsoft.com/kb/2527180

7. When you select a dimension as a nested table in a Data Mining model in BIDS, some attributes of the dimension do not appear.

This problem occurs when you select a cube as the data source for the Data Mining model. This bug was first fixed in Cumulative update package 3 for SQL Server 2008. You can download the Cumulative update package 3 for SQL Server 2008 at here: https://support.microsoft.com/kb/960484

8. When you try to install BIDS on a SQL Server 2008-based computer, the installation is not successful.

This problem occurs when Visual Studio is installed in a non-default location. This bug was first fixed in Cumulative update package 2 for SQL Server 2008. You can download the Cumulative update package 2 for SQL Server 2008 at here: https://support.microsoft.com/kb/9581861

9. The error occurs when you run a SSIS package that uses a configuration table in BIDS.

This is the error message text: ?The connection “<Connection Name>” is not found?. This problem usually occurs when you use a shared configuration table in multiple packages and the configuration filter values in the configuration table are the same for each package. This bug was first fixed in Cumulative update package 5 for SQL Server 2008 Service Pack
1. You can download the Cumulative update package 5 for SQL Server 2008 Service Pack 1 at here:
https://support.microsoft.com/kb/975977/LN

To work around this problem, do not use the same configuration filter in a shared configuration table for multiple packages.

10. When you install SQL Server 2008 without the SSIS feature, you cannot edit or debug an SSIS package in BIDS.

This is SQL Server 2008 bug. This bug was first fixed in Cumulative update package 4 for SQL Server 2008. You can download the Cumulative update package 4 for SQL Server 2008 at here:
https://support.microsoft.com/kb/963036

To work around this problem, you can add the “Integration Services” feature to the existing installation of BIDS.

11. The error occurs when you resize a Chart control in the Report Designer in BIDS on a computer that is running Windows 7.

This is the error message text: “Chart Exception: Parameter is not valid”. This bug was first fixed in Cumulative update package 4 for SQL Server 2008 Service Pack 1. You can download the Cumulative update package 4 for SQL Server 2008 Service Pack 1 at here: https://support.microsoft.com/kb/973602/LN

12. The “Page 1 of 1” may be displayed for all the pages after you export a report to Excel format in BIDS.

This is SQL Server 2008 bug. This bug was first fixed in Cumulative update package 3 for SQL Server 2008. You can download the Cumulative update package 3 for SQL Server 2008 at here: https://support.microsoft.com/kb/960484

13. The error occurs when you try to deploy a report to a server that is running Windows SharePoint Services in SQL Server 2008 BIDS.

This is the error message text: “Error rsInvalidItemName: The name of the item ‘Data%20Sources’ is not valid”. This problem occurs when the target folder does not already exist on the target server. To work around this problem, you should manually create the target folder on the server that is running Windows SharePoint Services and then deploy the report in SQL Server 2008 BIDS.

14. The error occurs when you create a report server project in SQL Server 2008 BIDS and then export a report to a PDF or TIFF file.

This is the error message text: “An item with the same key has already been added”. This problem occurs with Cumulative update package 1 for SQL Server 2008 Service Pack 2. This bug was first fixed in Cumulative update package 2 for SQL Server 2008 Service Pack 2. You can download the Cumulative update package 2 for SQL Server 2008 Service Pack 2 at here: https://support.microsoft.com/kb/2467239/LN

.

Best Microsoft MCTS Certification, Microsoft MCITP Training
at certkingdom.com