Report server intermittent Terradata errors
Hi all, I've build a few reports in visual studio, they work and they don't work, in a minute I can run them next minute I can't and I get this errors in event viewer every time they can't be run: Report Server (MSSQLSERVER) cannot load the SQLPDW extension. Report Server (MSSQLSERVER) cannot load the TERADATA extension. Any idea qhat I need to do to avoid this? Thanks in advance
January 24th, 2011 8:50am

You can try disabling the extension section in the config file. TERADATA is a data extension in the config file.
Free Windows Admin Tool Kit Click here and download it now
January 24th, 2011 9:21am

I have found that resolution online, but on my Config file I don't have that extension.
January 24th, 2011 10:53am

Hi Nrodri, This error occurs because the Teradata extension is registered in the Reporting Services configuration file by default, but the Teradata assemblies are not shipped with SQL Server 2008 or as part of the .NET Framework. If the error message does not bother you, you can ignore the error when it is logged. However, if you want to avoid this error, do one of the following: Open the Reporting Services configuration file located in folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer, remove or comment out the Teradata extension. Do this only if you do not require functionality that the Teradata extension provides. Install the .NET Data Provider for Teradata. Do this only if you require functionality that the Teradata extension provides. You can obtain the provider from the Teradata Web site. Reporting Services requires that the provider be version 12 or later. For more information about this issue, please see http://technet.microsoft.com/en-us/library/ms159704.aspx#TeradataException Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 28th, 2011 6:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics