How to avoid "The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly"

Question

I am using 'MYSQL' datasource  in  ODBC' for my project.

My deployment is failing with the error "Error  1 An attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services. 0 0  "

When I went to the my manager url "http://localhost/Demo_Reports/Pages/DataSource.aspx", I found the following in the 'properties' 'under the 'Data Source Type'

"The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly"

What are the steps to follow to avoid this error.

---

Dharmendra

Answer 1

Hi Dharmendra,

Could you please find out the file rsreportserver.config located at MSSQL.X\Reporting Services\ReportServer to see whether it contain below code at <Data> section. If it not contain the code, add it to the <Data> section.
<Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

Besides, if you are using Express edition, then the report data source must be SQL Server relational databse that run locally. You can refer to the link below to see “Features supported by Reporting Services in SQL Server Express”.
http://msdn.microsoft.com/en-us/library/cc281020(v=sql.100).aspx

Hope this helps.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support

Answer 2

I got this " ReportingServicesService.exe  "  file which has a .exe extension      and has a "type"  XML configuration file

But there is no  section called <data> 

<configuration>
  <configSections>
    <section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
  </configSections>
  <system.diagnostics>
    <switches>
      <add name="DefaultTraceSwitch" value="3" />
    </switches>
  </system.diagnostics>
  <RStrace>
    <add name="FileName" value="ReportServerService_" />
    <add name="FileSizeLimitMb" value="32" />
    <add name="KeepFilesForDays" value="14" />
    <add name="Prefix" value="appdomain, tid, time" />
    <add name="TraceListeners" value="file" />
    <add name="TraceFileMode" value="unique" />
    <add name="Components" value="all:3" />
  </RStrace>
  <runtime>
    <alwaysFlowImpersonationPolicy enabled="true"/>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
             publicKeyToken="89845dcd8080cc91"
             culture="neutral" />
        <bindingRedirect oldVersion="8.0.242.0"
             newVersion="10.0.0.0"/>
        <bindingRedirect oldVersion="9.0.242.0"
             newVersion="10.0.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" 
             publicKeyToken="89845dcd8080cc91" 
             culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0" 
             newVersion="10.0.0.0"/>
      </dependentAssembly>
    </assemblyBinding>
    <gcServer enabled="true" />
  </runtime>
</configuration>

  Am I looking at the right place?? Should I make a new line  like this inside the file

<Data>
<Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>

I am using sql server 2012 express edition with advance services.

---

Dharmendra

Answer 3

Hi Dharmendra,

I am afraid you got the uncorrent file. it located at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. And the file name is rsreportserver.config.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support

Answer 4

Dear Charlie Liao,

You are right I was going on a wrong path. Any way I got this from the config file.

I am just pasting the data part here. Please review my config file and give feedback

<Data>
      <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
      <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
      <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,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="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,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" />
      <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
    </Data>

Thanks a lot.

---

Dharmendra

Answer 5

Hi Dharmendra,

Yes, you have found right rsreportserver.config, and the content is right. Does this solve your issue?

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support