October 27, 2014 at 6:50 pm
We have SQL Server 2008 R2 running on Windows 2008 Server. We are using Visual Studio 2005 and Report Builder 3.0. I created a Report Model which includes a data source and a data source view. (The data source is based on a .NET Provider ODBC with a CONNX Driver. I have tried both a User and System Data Source.) In Visual Studio, I can see the tables in the Report Model. After deployment, in Report Builder, I created a data source and then created a dataset from that data source. I click on Query Designer and the Report Model does not show up. I am able to type a SELECT Query on a table (which I know is inside the model) and it executes and returns data just fine.
Why is the Report Model not showing in Report Builder? What are somethings I can try to resolve this issue? Is this a security issue or something that needs to be configured on the Report Model on the Report Server?
Thanks in advance, Kevin
October 28, 2014 at 4:29 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply