Monday, October 7, 2013

SharePoint 2013 - SSRS Removing unused Teradata and SQLPDW extensions



By default Reporting Services includes references to TeraData and PQLPDW extensions that are not included in the install. This will generate “Unexpected” level errors in the SharePoint ULS logs. While these errors don’t hurt anything, they do create a lot of noise in the log files. These errors can be resolved by removing these references from the Reporting Services configuration. 

1.       Open PowerShell on the App server
2.       Create the below PowerShell Scripts
3.       Run the following scripts in your PowerShell window:
a.       Remove_TeraData_Extension_From_SSRS.ps1
b.      Remove_SQLPDW_Extension_From_SSRS.ps1



Remove_TeraData_Extension_From_SSRS.ps1:

<##start##>
 <##########################################################
Description: Remove TeraData from Reporting Services to stop the following errors in the ULS log:
    "Exception caught instantiating TERADATA report server extension:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
    ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider'...
Source: http://timpanariuovidiu.wordpress.com/2013/03/05/sql-2012-reporting-service-sp1-and-sharepoint-2013/
##########################################################>
$ssrs = Get-SPRSServiceApplication
$ext = Get-SPRSExtension -Identity $ssrs.Id

$eData = $ext | Where-Object {$_.Name -eq “TERADATA” -and $_.ExtensionType -eq “Data” }
#$eData

$eSemanticQuery = $ext | Where-Object {$_.Name -eq “TERADATA” -and $_.ExtensionType -eq “SemanticQuery” }
#$eSemanticQuery

$eModelGeneration = $ext | Where-Object {$_.Name -eq “TERADATA” -and $_.ExtensionType -eq “ModelGeneration” }
#$eModelGeneration

Remove-SPRSExtension -Name $eData.Name -ExtensionType $eData.ExtensionType -Identity $ssrs.Id
Remove-SPRSExtension -Name $eSemanticQuery.Name -ExtensionType $eSemanticQuery.ExtensionType -Identity $ssrs.Id
Remove-SPRSExtension -Name $eModelGeneration.Name -ExtensionType $eModelGeneration.ExtensionType -Identity $ssrs.Id

<##end##>

Remove_SQLPDW_Extension_From_SSRS.ps1:

<##start## >
<##########################################################
Description: Remove SQLPDW from Reporting Services to stop the following errors in the ULS log:
    "Exception caught instantiating SQLPDW report server extension:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
    ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider'...
Source: http://timpanariuovidiu.wordpress.com/2013/03/05/sql-2012-reporting-service-sp1-and-sharepoint-2013/
##########################################################>
$ssrs = Get-SPRSServiceApplication
$ext = Get-SPRSExtension -Identity $ssrs.Id

$eData = $ext | Where-Object {$_.Name -eq “SQLPDW” -and $_.ExtensionType -eq “Data” }
#$eData

$eSemanticQuery = $ext | Where-Object {$_.Name -eq “SQLPDW” -and $_.ExtensionType -eq “SemanticQuery” }
#$eSemanticQuery

$eModelGeneration = $ext | Where-Object {$_.Name -eq “SQLPDW” -and $_.ExtensionType -eq “ModelGeneration” }
#$eModelGeneration

Remove-SPRSExtension -Name $eData.Name -ExtensionType $eData.ExtensionType -Identity $ssrs.Id
Remove-SPRSExtension -Name $eSemanticQuery.Name -ExtensionType $eSemanticQuery.ExtensionType -Identity $ssrs.Id
Remove-SPRSExtension -Name $eModelGeneration.Name -ExtensionType $eModelGeneration.ExtensionType -Identity $ssrs.Id
 <##end##>




No comments:

Post a Comment

Thank you for your comments!