I am on a new job and just found out that we do not use Visual Studio to deploy Report Datasources, Report Views and Report Models. (Visual Studio is not successfully deploying items on purpose.) The deployment process is done manually (for security reasons) by using the 'Upload File' option in Reports Manager and choosing the semantic model file (.smdl). Therefore, this morning I tried this method and it returned the following error:
"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "
I found the following article (in between the lines) which resolved the issue.
---------------------------------------------------------------------------------------------------------------------------------------------
How to deploy Semantic Models manually?
The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.
---------------------------------------------------------------------------------------------------------------------------------------------
Now, after that fix I am able to view the model/tables in the Report Builder. However, when I try to run a report in Report Builder, the below error (in between the lines) is returned:
---------------------------------------------------------------------------------------------------------------------------------------------
TITLE: Microsoft SQL Server Report Builder
------------------------------
An error occurred while retrieving the parameters in the query.
Failed to prepare query.
------------------------------
ADDITIONAL INFORMATION:
Failed to prepare query. (Microsoft.ReportingServices.DataExtensions)
---------------------------------------------------------------------------------------------------------------------------------------------
System.Web.Services.Protocols.SoapException: An attempt has been made to use a semantic query extension associated with the data extension 'OLEDB' that is not registered for this report server. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SemanticQueryExtensionNotFoundException: An attempt has been made to use a semantic query extension associated with the data extension 'OLEDB' that is not registered for this report server.
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.PrepareQuery(DataSource DataSource, DataSetDefinition DataSet, DataSetDefinition& DataSettings, Boolean& Changed, String[]& ParameterNames)
at Microsoft.ReportingServices.WebServer.ReportingService2010.PrepareQuery(DataSource DataSource, DataSetDefinition DataSet, DataSetDefinition& DataSettings, Boolean& Changed, String[]& ParameterNames) (System.Web.Services)
---------------------------------------------------------------------------------------------------------------------------------------------
Below is my research on this error. Note the below statements in red from the last url. I am trying to process "mainframe data" using CONNX Drivers. (CONNX is the vendor.) The statement in red states "The semantic query processing extensions included with Reporting Services provide support for SQL Server relational data, Oracle, and Analysis Services multidimensional data. Do not modify this section. Query processing is not extensible." I now believe the Reporting Services does not process this type of data provided by the CONNX drivers. Is this how you would interpret it? Any suggestions?
My Research on latest issue:
An attempt has been made to use a data extension OLEDB that is not registered for this report server
RSReportServer Configuration File
http://msdn.microsoft.com/en-us/library/ms157273(v=sql.105).aspx#Extensions
Semantic Query
Specifies semantic query processing extension used to process report models. The semantic query processing extensions included with Reporting Services provide support for SQL Server relational data, Oracle, and Analysis Services multidimensional data. Do not modify this section. Query processing is not extensible.
Thanks, Kevin