Ax 2009 SSRS Error

Venkatesh

unread,

Jun 24, 2008, 3:12:04 AM6/24/08

to

Hi All,

I have configured SSRS in Ax 2009 and i have deployed all the report
libraries.
When i run the report from Ax 2009 client, i am getting the following error.
I have also created a configuration for Business connector.

Error during processing of ‘AX_CompanyName’ report parameter.
(rsReportParameterProcessingError)

What need to be done in order to address this error?
--
Venkatesh

Stranta

unread,

Jul 6, 2008, 12:32:00 AM7/6/08

to

Hi Microsoft guys,
I am getting the same error. Any words of advice?

Role Center is also giving me:
This error was caused by the following exception: Cannot read information
from SQL Server Reporting Services. Validate that the Report Manager URL is
correct.

The validate has success from Reporting Servers form, and all reports all
deployed without issue. Even un-installed, deleted all deployed reports and
reinstalled. Same problem.

Database and SSRS (SQL SP2) are running on Windows 2008 x64. AOS is running
Windows 2008 x64.

Thanks!

Volodymyr

unread,

Jul 15, 2008, 9:06:00 AM7/15/08

to

Hi
Could you give us more information about which Role center you are
configuring and which report you are using?

Thanks
Volodymyr

Rasmus

unread,

Jul 17, 2008, 4:20:01 AM7/17/08

to

You can try a couple of things.

You can verify that the identity of the application pool(AXReportServer)
matches the account defined in the rsreportserver.config file. Search for
the "<WebServiceAccount>Domain/Account</WebServiceAccount>" tag.
The rsreportserver.config file can be found here:
{Drive_Root}:\Program Files\Microsoft SQL
Server\MSSQL.{RS_Instance_ID}\Reporting Services\ReportServer

Also in the rsreportserver.config file you can verify that the report server
path is correct. Look for the "<UrlRoot> </UrlRoot>" tag. The path defined
here should be the path of your report server. For example
“<UrlRoot>http://localhost:81/Reports</UrlRoot>”

If you make changes to the config file remember to restart the IIS.

I hope this helps.
Rasmus

Venkatesh

unread,

Jul 18, 2008, 12:39:02 AM7/18/08

to

Thanks Rasmus.

As you specified, there was a difference in Appl Pool Identity and RSConfig
file. Once i changed that, i was able to run the report without any errors.

Thanks again.
--
Venkatesh

sb

unread,

Aug 12, 2008, 8:54:01 AM8/12/08

to

Hi,

We have the same issue, but the web service account is the same as the
Application Pool.

We have to application Pools: AxReportServer (ReportServer) and
DefaultAppPool (Reports)

DefaultAppPool uses Network Service (to avoid SPNs)

The account is a sharepoint service account that is also used for the
enterprise portal (which works fine).

We had several problems deploying the solution with DLL errors, and a report
that had a missing method (GetColor). The DLL errors were solved by
installing VS2008; although I found that copying ClrBridge from the location
in the GAC to the Report Deployment tools root folder also fixes the error.

Thanks in Advance

RajAx

unread,

Dec 4, 2009, 8:13:01 AM12/4/09

to

Hey,

I have got the same problem for reporting services,But i could not locate
the Webserver tags or the url in the config file.

Can u help me to find the tags in the config files.

Raj

Lawrence Garvin

unread,

Dec 4, 2009, 12:13:35 PM12/4/09

to

"RajAx" <Ra...@discussions.microsoft.com> wrote in message
news:C19DC36B-EC84-4749...@microsoft.com...

The webserver tags don't exist in the config file, nor does the AppPool
account, when SSRS 2008 is used, because SSRS 2008 does not use IIS.

So I'm interested in the answer to this question with SSRS2008 on Win2008 as
well!

--
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2009)

My Blog: http://onsitechsolutions.spaces.live.com
Microsoft WSUS Website: http://www.microsoft.com/wsus
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin