Symptoms

We get the following error message when calling a sql report on the Workspace errors:

Message: Method Execution Failure. Message: 'Error in getting report: '/Car Insurance/Car Insurance' Message: 'andltErrorCode xmlns="http://www.microsoft.com/sql/reportingservices"andgtrsProcessingAbortedandlt/ErrorCodeandgtandltHttpStatus xmlns="http://www.microsoft.com/sql/reportingservices"andgt400andlt/HttpStatusandgtandltMessage xmlns="http://www.microsoft.com/sql/reportingservices"andgtAn error has occurred during report processing.andlt/MessageandgtandltHelpLink xmlns="http://www.microsoft.com/sql/reportingservices"andgthttp://go.microsoft.com/fwlink/?LinkId=20476andampEvtsrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStringsandampEvtID=rsProcessingAbortedandampProdName=Microsoft%20SQL%20Server%20Reporting%20ServicesandampProdVer=11.0.2218.0andlt/HelpLinkandgtandltProductName xmlns="http://www.microsoft.com/sql/reportingservices"andgtMicrosoft SQL Server Reporting Servicesandlt/ProductNameandgtandltProductVersion xmlns="http://www.microsoft.com/sql/reportingservices"andgt11.0.2218.0andlt/ProductVers

If we try to run the report directly through SQL, I get this error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'CarDetails'. (rsErrorExecutingCommand)
Invalid archive type

 

Diagnoses

Please check to see if the SSRS report is making use of the SOURCECODE data provider for querying SmartObjects in SSRS reports. This is evident in the error stating "Invalid archive type". If so, this means that the client components on the SSRS server also require an upgrade to the latest versions.

First check if a K2 installation has been performed on the SSRS server to install the client components. This can be checked in Programs and Features on the SSRS server, then simply perform an upgrade of the K2 components on the SSRS server. If there is no K2 installation then it means the K2 DLLs were manually copied across and would have to be updated manually.

 

Resolution

The error indicates the reporting components are not present on the server, after installing the SSRS components the issue was resolved.

http://help.k2.com/onlinehelp/k2blackpearl/icg/4.7/default.htm#Install/Manual/Farm_bp_K2RS.htm?Highlight=SSRS