Error loading ACS reporting .rdl files

[Manjun]

I am trying to deploy ACS in an environment of one management group &
multiple servers (2-node cluster for OpsMgr database and Data Warehouse
database; 1 RMS; 1 MS; 1 ACS collector & 1 OpsMgr reporting & ACS database
server, both on the same SQL 2005 instance ), I got the errors as listed
below when I loaded ACS report files from OpsMgr Reporting & ACS database
Server:
"Error Loading file
C:\ACS\Reports\Forensic_-_All_Events_For_Specified_User.rdl.
System.Web.Services.Protocols.SoapException: The value of parameter
'DataSourc
es' is not valid. --->
Microsoft.ReportingServices.Diagnostics.Utilities.Invalid
ParameterException: The value of parameter 'DataSources' is not valid.
at
Microsoft.ReportingServices.Library.Soap2005.DataSource.ThisArrayToDataSou
rceInfoCollection(DataSource[] dataSources)
at
Microsoft.ReportingServices.Library.SetItemDataSourcesAction.SetReportData
Sources(CatalogItem item, DataSource[] dataSources)
at
Microsoft.ReportingServices.Library.SetItemDataSourcesAction.PerformAction
Now()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemData
Sources(String Item, DataSource[] DataSources)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemData
Sources(String Item, DataSource[] DataSources)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.SetItemDataSour
ces(String Item, DataSource[] DataSources)
File will not be loaded."
Got the following error when load acs reporting files from RMS: "Error
Loading file D:\ACS\Reports\Forensic_-_All_Events_For_Specified_Computer.rdl.
The value of parameter 'DataSources' is not valid. ---> The value of
parameter
'DataSources' is not valid.
File will not be loaded."

And After I configured the Data Source of report and got the following error
when view the report: "• An error has occurred during report processing.
o Query execution failed for data set 'dataSet'.
 Incorrect syntax near 'datetime'. The label 'xmlns' has already been
declared. Label names must be unique within a query batch or stored
procedure. The label 'xmlns' has already been declared. Label names must be
unique within a query batch or stored procedure. The label 'xmlns' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. The label 'xsi' has already been declared. Label names must
be unique within a query batch or stored procedure. The label 'xsi' has
already been declared. Label names must be unique within a query batch or
stored procedure. "

My OpsMgr reporting is working fine, and I saw data were wrote in to the ACS
database by the ACS collector that is running on another server.

Any help or suggestion will be highly appreciated,

Thank you in advance,

Manjun

[Anders Bengtsson [MVP]]

Hi Manjun,

Can you please verify your steps with this guide http://contoso.se/blog/?p=198

--
Anders Bengtsson
Microsoft MVP - Operations Manager
Microsoft Certified Trainer (MCT)
http://www.contoso.se

[Manjun]

Anders,
Thank you for your reply, it seems you are hosting ACS reporting and
collector on one server, I am not sure that is the issue I encountered?
My problem is that I could upload the rdl files, and please shine some
lights on it,
Thanks,

Manjun

[Manjun]

I'd like to keep you update upon this wild and confused problem with me for
the acs reports uploading, I was trying to upload them using folders and
files from SP1.
I compared the acs installation files after applying SP1, all acs files are
kept the same as the official first release, and then I used folders and
files other than SP1 and successfully uploaded the reports and started
working.
Thank you all,

Manjun