SQLUA says "Upgrade Advisor detected one or more custom data processing extensions on the report server." though I have never added data processing extention to my SSRS.

PROBLEM

I’m upgrading from SQL Server 2008 to SQL Server 2008 R2. I installed and launched Upgrade Advisor and analyze Reporting Services. Then it gives me the following warning:

Upgrade Advisor detected one or more custom data processing extensions on the report server. Upgrade can continue, but you must move the data processing extension assemblies to the new installation folder.

I didn’t add any “custom data processing extensions”. What’s wrong?

 

ANSWER/RESOLUTION

Newly added TERADATA Data Processing Extension was detected as unknown extension. You can safely ignore the warning if you didn’t add any Custom Data Processing Extensions.

Or you can eliminate the warning by removing the entry of TERADATA Data Processing Extension from rsreportserver.config (if you don’t use it) as follows:

 

<Configuration>
…
  <Extensions>
…
    <Data>
      <Extension Name="SQL" 
       Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,
       Microsoft.ReportingServices.DataExtensions"/>
      <Extension Name="OLEDB"
       Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,
       Microsoft.ReportingServices.DataExtensions"/>
      <Extension Name="OLEDB-MD"
       Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,
       Microsoft.ReportingServices.DataExtensions"/>
      <Extension Name="ORACLE"
       Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,
       Microsoft.ReportingServices.DataExtensions"/>
      <Extension Name="ODBC"
       Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,
       Microsoft.ReportingServices.DataExtensions"/>
      <Extension Name="XML"
       Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,
       Microsoft.ReportingServices.DataExtensions"/>
      <Extension Name="SAPBW"
       Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,
       Microsoft.ReportingServices.DataExtensions.SapBw"/>
      <Extension Name="ESSBASE"
       Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,
       Microsoft.ReportingServices.DataExtensions.Essbase"/>
      <!—           comment out the following TERADATA extension                -->
 <!-- <Extension Name="TERADATA"
       Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,
       Microsoft.ReportingServices.DataExtensions"/> –>
<!-- <Extension Name="SSIS"
       Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,
       Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral,
       PublicKeyToken=89845dcd8080cc91"/> –>
    </Data>

NOTES

If you’re not familiar with Data Processing Extension, see the following BOL article(s).

Implementing a Data Processing Extension

http://msdn.microsoft.com/en-us/library/ms154655.aspx