Wednesday, June 06, 2012

Report Server cannot load the TERADATA / SQLPDW extension

Problem

In the Windows Application Log of a Windows 2008 server that hosts SQL server 2008 R2 reporting service, the following Error messages appear daily:

“Report Server (MSSQLSERVER) cannot load the SQLPDW extension.”

“Report Server (MSSQLSERVER) cannot load the TERADATA extension.”

Cause

I’ve found the explanation in the SSRS forums on MSDN (link can be found here)

“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.”

Solution

With SQL server configuration Manager or with Reporting Services Configuration manager, stop the reporting service.

Edit the file As suggested in the above article, edit the file rsreportserver.config in <C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer>

Search for SQLPDW, comment out 2 entries:

<!--Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/—>

<!--Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
    <Configuration>
        <EnableMathOpCasting>False</EnableMathOpCasting>
    </Configuration>
</Extension-->

 

Search for TERADATA, comment out 3 entries:

<!--Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/—>

<!--Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
    <Configuration>
        <EnableMathOpCasting>True</EnableMathOpCasting>
        <ReplaceFunctionName>oREPLACE</ReplaceFunctionName>
    </Configuration>
</Extension—>

<!--Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/-->

Start the reporting service.

10 comments:

GUNEET KALRA said...

where can we find the configuration setting when reporting service is installed as a sharepoint shared servic.

I saw in webservices in 14 hive but could not find the configuration.

Unknown said...
This comment has been removed by a blog administrator.
Anonymous said...

My brother recommended I might like this website. He was entirely right.

This post actually made my day. You can not imagine just how
much time I had spent for this information! Thanks!

My blog ... watch live porn free

Anonymous said...

Thanks for the marvelous posting! I truly enjoyed reading it, you might be a great author.
I will always bookmark your blog and will eventually come back someday.

I want to encourage continue your great posts, have a nice
day!

Stop by my website; free adult chat room ::
::

Anonymous said...

Good way of telling, and nice post to take facts
regarding my presentation topic, which i am going to convey in institution of higher education.


my site ... http://www.darmowaerotyka.net.pl/

Yogita Bharti said...
This comment has been removed by the author.
Unknown said...

I have commented both the extensions after that reporting services got stopped.

Can any one please suggest on this..

Dansmith said...

If the service does not start, it is because the ending comment has been auto corrected in this blog to a large - instead of 2 --
eg -->
Change all closing comments to be --> and the service should start

Anonymous said...

Thanks for the post, i think am very to fix this issue, have couple of questions

1> Why do you need TERADATA and SQLPWD in SQL 2012 or report.
2> If TERADATA/SQLPWD not loaded, can it cause the Report sever to be not accessible ?

Thanks in Advance

Moving said...

For SQL 2014:

C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer