I was trying to create a team project based on my own process template...
Event Description: TF30162: Task "Populate Reports" from Group "Reporting" failed
Exception Details: The Project Creation Wizard encountered a problem while
creating reports on the SQL Server Reporting Services on MyServer.
The reason for the failure cannot be determined at this time.
Because the operation failed, the wizard was not able to finish
creating the SQL Server Reporting Services site.
Exception Message: The data source 'TFS Warehouse Model' cannot be found.
The named data source, TFS Warehouse Model, does exist. And I have enough privileges to create Reporting Services sites. Can you explain me what else is wrong Thanks in advance.
Project Creation Wizard Didn't Find Reports Data Source
Arjen Stolk
You can use the report designer to create RDL files based on reporting data sources( .rds files) rather than a model as the report uploader limitation is specific to reports based on a report model.
Thanks,
Othmane
zoomkat
Unfortunately the report uploader doesn't support report builder reports at this time. You can use RS scripts to deploy your reports after PCW.
http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsadmin/htm/arp_rstools_v1_4z02.asp
Lee Hambley
Hi Stanislav,
Would you provide the following info to help us diagnose the issue
What did you put under the <datasources> node in your ReportsTasks.xml for your reports
Where is the data source 'TFS Warehouse Model' located on your report server
Did you double check to make sure the datasource name in your RDL files match 'TFS Warehouse Model' exactly
Thx!
-Jim
rsd_za
This is what I did put under the <datasources> node in my ReportsTasks.xml for my reports:
<datasources>
<reference name="/Models/TFS Warehouse Model" dsname="TFS Warehouse Model" />
</datasources>
The data source TFS Warehouse Model is located exactly in the /Home/Models folder of my report server. It looks a little bit strange that the containing folder is /Home/Models but is specified as just /Models, without /Home, however, it is the same for the standard data source, TfsOlapReportDS, located in /Home and specified without /Home.
Moreover, I have another team project, reports for which were created after the project's creation, and these reports use the same data source, TFS Warehouse Model, and it works!
Yes, I did double check to make sure the data source name in my RDL files match TFS Warehouse Model exactly:
<Report...
<DataSets>
<DataSet Name="dataSet">
<Query>
<DataSourceName>dataSource1</DataSourceName>
...
</Query>
</DataSet>
</DataSets>
<DataSources>
<DataSource Name="dataSource1">
<DataSourceReference>/Models/TFS Warehouse Model</DataSourceReference>
<rd:DataSourceID>d5f56c1f-639c-4e41-8e44-6b8f4e4dbded</rd:DataSourceID>
</DataSource>
</DataSources>
</Report>
This ^^^ was taken from one of the reports that successfully use the named data source been created for the other project after its creation.
Roco72