Home > SCCM > ACS Well known error: The application threw exception: CreateSRSDataSource: Exception The request failed with HTTP status 404: Not Found…

ACS Well known error: The application threw exception: CreateSRSDataSource: Exception The request failed with HTTP status 404: Not Found…


Hi,

During the ACS ( Audit Collection Services) reporting configuration I have encountered this well known error : “The application threw exception: CreateSRSDataSource: Exception The request failed with HTTP status 404: Not Found…”. If you have also this error “the application threw exception create datasource exception invalid uri the uri scheme is not valid”, this post is for you.

So before giving the small solution to fix this error, let us describe my environment:

  • 2 Management Servers; one of them is the ACS collector.
  • 1 Database server DBServer with configured reporting services for the SCOM reports.
  • The ACS server ACSServer hosts the ACS database.

The default instances were installed on the two servers.

In my case, I’d like to install the ACS reporting extension on my reporting instance server DBServer. To do that, you have just to follow these steps:

  1. Log on to the server that will be used to host ACS reporting as a user that is an administrator of the SSRS instance.
  2. Create a temporary folder, such as C:\acs.
  3. On your installation media, go to \ReportModels\acs and copy the directory contents to the temporary installation folder.There are two folders (Models and Reports) and a file named UploadAuditReports.cmd.
  4. On your installation media, go to \SupportTools and copy the file ReportingConfig.exe into the temporary acsfolder.
  5. Open a Command Prompt window by using the Run as Administrator option, and then change directories to the temporary acs folder.
  6. Run the following command UploadAuditReports “<AuditDBServer\Instance>” “<Reporting Server URL>” “<path of the copied acs folder>” .For example: UploadAuditReports “myAuditDbServer\Instance1” “http://myReportServer/ReportServer$instance1” “C:\acs”. This example creates a new data source called Db Audit, uploads the reporting models Audit.smdl andAudit5.smdl, and uploads all reports in the acs\reports directory.

In my case the Report Manager URL is “http://DBServer/Reports&#8221;. I have executed the following command on my reporting server DBServer  UploadAuditReports “ACSServer” “http://DBServer/Reports” “C:\acs”

And of course the error was generated. Even you read the solutions on Internet, you can not easily notice that what is needed is the Report Server URL and not the Report Manager URL!

The Report Server manager is the Web Service used by the Report manager to manage the reports. In my case: the address is http://DBServer/ReportServer_SQL2008.

So the new command to type is UploadAuditReports “ACSServer”  “http://DBServer/ReportServer_SQL2008” “C:\acs”

For advanced troubleshooting, try to take a look on the UploadAuditReports batch source:

@echo off

@if .%1 == “?” goto usage
@if .%1 == “/?” goto usage

REM Set defaults for optional parameters
set SRSFolder=”Audit Reports”
set DataSourceName=”DB Audit”

@if .%1 == . goto errormissingvariable
@if .%2 == . goto errormissingvariable
@if .%3 == . goto errormissingvariable

ReportingConfig.exe /DoAction:CreateDataSource /DBServerName:%1 /DBName:”OperationsManagerAC” /SRSUrl:%2 /SRSFolder:%SRSFolder% /DataSourceName:%DataSourceName% /WindowsIntegrated /LoadReportsFromFolder:%3\Models

ReportingConfig.exe /DoAction:CreateDataSource /DBServerName:%1 /DBName:”OperationsManagerAC” /SRSUrl:%2 /SRSFolder:%SRSFolder% /DataSourceName:%DataSourceName% /WindowsIntegrated /LoadReportsFromFolder:%3\Reports

@goto end

:errormissingvariable
@echo Error: Parameter Missing
@goto usage

:usage
@echo UploadAuditReports {DatabaseServerAndInstance} {ReportingServiceURL} {ReportFolder}
@echo Example (database with instance):
@echo UploadAuditReports MyDBServer\Instance1 http://MyDbServer/ReportServer$Instance1 C:\MyReports
@echo Example (database with no instance):
@echo UploadAuditReports MyDBServer http://MyDbServer/ReportServer C:\MyReports

@goto end

:end

For example, if during ACS database installation, you have changed the default name “OperationsManagerAC”, you will have some surprises!

Advertisements
Categories: SCCM
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: