SSRS deployment Error

Finance and Operations/AX Developer Forum
1

Hi,

When am trying to deploys SSRS reprots using wizard am getting the follwing error

One or more libraries built with warnings. Please see MSBuild log at C:\Users\administrator.DPL\AppData\Local\Temp\2\tmp6DB5.tmp

Unable to modify the security policy file: ‘C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config’.

Deploying 1 data source(s) and 154 design(s) in 42 culture(s) (6469 item(s) total)…

Deployment failed unexpectedly with the message:

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

See the log file for further details.

The deployment log file can be found at "C:\Users\administrator.\AppData\Local\Temp\2\tmp47F4.txt"

How i can solve this.

Please help

2

Hi,

The message has given you some possible issues. Have you checked all these issues?

Also have you looked into the log file yet? What does it say?

3

Hi,

This is happening because the Dynamics AX entries in the rsreportserver.config (used
by SSRS) file are lost or overwritten due to some reason.

Re-installing Reporting Extensions may work.

Regards,
Vinay

4

Hai harish,

first log file --says 0 errors and build succeeded

2nd log file -

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

See the log file for further details.

Deployment failed with the following exception:

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> System.Data.SqlClient.SqlException: Transaction (Process ID 66) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item)

at Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item)

and posible issues-- means?
i have no clue on how to correct the error:modify the security policy

Please suggest–

5

Hi,

It appears that SqlException and ReportServerStorageException errors are due to one common issue.

How much free space do you have in the drive in which Reporting database is placed in SQL Server? Also what errors do you see in the Event viewer?

Another option for you is instead of deploying entire report library, you may want to deploy one by one. Though this will take long, at least this will help you to identify the report library which is causing this issue.

6

Hi Harish/Vinay,

Thanks for the support and appreciate your help. I re-installed the reporting extensions and deployed the reports again .

Success is the result.