加载项目或数据源的模型时发生错误 [英] An error occurred while loading the model for the item or data source

问题描述

当我尝试创建新月报告时，我收到以下错误。

 

< detail>< ErrorCode xmlns =" http://www.microsoft.com / sql / reportingservices"> rsCannotRetrieveModel< / ErrorCode>< HttpStatus
xmlns =" http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns =" http://www.microsoft.com/sql/reportingservices">An
error在加载项目或数据源'http：// njlsql2011 / Dynamics AX BI Tool / BI Tool.bism'的模型时发生。验证连接信息是否正确以及您是否有权访问数据源。< / Message>< HelpLink
xmlns =" http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId = 20476&放大器;放大器; EvtSrc = Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&放大器;放大器; EvtID = rsCannotRetrieveModel&放大器;放大器; PRODNAME =微软％20SQL％20Server％20Reporting％20Services&放大器;放大器; ProdVer = 11.0.1440.19< / HELPLINK>< ; ProductName
xmlns =" http://www.microsoft的.com / SQL / reportingservi ces"> Microsoft SQL Server Reporting Services< / ProductName>< ProductVersion xmlns =" http://www.microsoft.com/sql/reportingservices">11.0.1440.19</ProductVersion><ProductLocaleId
xmlns = " http://www.microsoft.com/sql/ reportingservices"> 127< / ProductLocaleId>< OperatingSystem xmlns =" http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId
xmlns =" http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns =" http://www.microsoft.com/sql/reportingservices"><Source> ReportingServicesLibrary< / Source><消息
msrs：ErrorCode =" rsCannotRetrieveModel" msrs：HelpLink =" http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp ; EvtID = rsCannotRetrieveModel&放大器;放大器; PRODNAME =微软％20SQL％20Server％20Reporting％20Services&放大器;放大器; ProdVer = 11.0.1440.19 "
xmlns：msrs =" http://www.microsoft.com/sql / reportingservices">加载项目或数据源'http：// njlsql2011 / Dynamics AX BI Tool / BI Tool.bism'的模型时出错。
验证连接信息是否正确以及您是否有权访问数据源。< / Message>< MoreInformation>< Source> Microsoft.ReportingServices.ProcessingCore< / Source>< Message msrs：ErrorCode = QUOT; rsErrorOpeningConnection"
msrs：HelpLink =" http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings& ;安培; EvtID = rsErrorOpeningConnection&放大器;放大器; PRODNAME =微软％20SQL％20Server％20Reporting％20Services&放大器;放大器; ProdVer = 1.0 "
xmlns：msrs =" http://www.microsoft.com/sql / reportingservices">无法创建与数据源'TemporaryDataSource'的连接。< / Message>< MoreInformation>< Source> Microsoft.AnalysisServices.AdomdClient< / Source>< Message> A
无法与重定向器建立连接。确保"SQL浏览器"服务正在运行。< / Message>< MoreInformation>< Source> System< / Source>< Message>请求的名称有效，但未找到所请求类型的数据< / Message> ;< / MoreInformation>< / MoreInformation>< / MoreInformation>< / MoreInformation><警告
xmlns =" http://www.microsoft.com/sql/reportingservices " />< / detail>

解决方案

请验证BISM连接文件中指定的目标AS服务器是否允许远程连接：

< Source> Microsoft.AnalysisServices.AdomdClient< / Source>< Message>无法与重定向器建立连接。确保'SQL Browser'服务正在运行。< / Message>

 

HTH，

Robert

When I try to create a crescent report I get the following error.

 

<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://njlsql2011/Dynamics AX BI Tool/BI Tool.bism'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.1440.19</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.1440.19</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsCannotRetrieveModel" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.1440.19" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://njlsql2011/Dynamics AX BI Tool/BI Tool.bism'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsErrorOpeningConnection" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsErrorOpeningConnection&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=1.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot create a connection to data source 'TemporaryDataSource'.</Message><MoreInformation><Source>Microsoft.AnalysisServices.AdomdClient</Source><Message>A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running.</Message><MoreInformation><Source>System</Source><Message>The requested name is valid, but no data of the requested type was found</Message></MoreInformation></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

解决方案

Please verify that the target AS server specified inside the BISM connection file does allow remote connections:

<Source>Microsoft.AnalysisServices.AdomdClient</Source><Message>A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running.</Message>

 

HTH,
Robert

这篇关于加载项目或数据源的模型时发生错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！