AzureWarehouse database DimTeamProject table reportpath column is null

zocnutevrp 1 Reputation point
2021-04-16T15:21:16.583+00:00

Hello,

We as a company migrated from TFS 2013 to AzureDevops 2019 Server(On-Prem) and had to move old reports to the new report server. To do so we used a powershell script that uses /ReportServer/ReportService2005.asmx web service to create folders and reports. We couldn't do it manually because we have lots of collections and projects under them.

We have realized that the projects created after the migration had problems with the reports. Reports we use include default CMMI reports and some custom ones we have created. Most of these by default uses a SQL system function called [GetProjectNodeInfoFromReportFolder] that is located in warehouse database. This function returns the project guid and project name based on the current path of the report folder. This function uses the table DimTeamProject under the warehouse database and the column 'ReportPath' to determine which report is triggered against.

The problem we have is that the newly created projects after the migration all have NULL values in this ReportPath column, which fails our reports.

I couldn't seem to find where this ReportPath column is being filled upon so I couldn't find the core of the problem.

Based on research I've tried rebuilding the warehouse database in the administration console but it doesn't change anything. I've also checked in the administration console that the Default Report Folder path is set correctly for all the collections.

I've also tried uploading reports manually on the ssrs web portal.

As a side note, when I check the project in the visual studio Team Explorer I cant see the Reports tab. I can for the older projects. So I believe there should be something wrong in the project configuration.

I appreciate any feedback, thanks.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,120 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2021-04-19T08:30:00.027+00:00

    Hi @zocnutevrp ,
    [GetProjectNodeInfoFromReportFolder] is a method of TFS, from SSRS side there not much we could do. Unfortunately I am not familiar with TFS.

    I suggest you could consult on the TFS forum.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments