When multiple SSRS API try to access the same parent folder, get the folder does not exist error for one call, another call success, how to manage this bottle neck.

Yuvaraj Duraisamy 0 Reputation points
2024-12-18T09:41:49.4266667+00:00

I am using report server api to access the rdl using powershell script , to upload the rdl files

The below api format I am using in the script ,

https://{dnsname}/Reports/api/v2.0/Folders(Path='/Parentfolder/subfolder1/subfolder2/subfolder3')

eg**: https://contos.com/reports/api/v2.0/folders(Path='/Asia/India/chenai/reports')**

The api call works fine if we deploy one application , but if multiple application try to access "chennai" folder (6 apps in my case )folder , it say chennai folder not exists .

but some calls works as expected.

server details ,

Edition Windows Server 2022 Datacenter Azure Edition

Version 21H2

Installed on ‎11/‎27/‎2024

OS build 20348.2849

SSRS server details

Image

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,960 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 38,951 Reputation points
    2024-12-19T03:23:22.1533333+00:00

    Hi @Yuvaraj Duraisamy,

    Could you please help check if you access the "chennai" folder one by one via the application, will the error occur?

    I'm not familiar with powershell script, if it only happens when multiple Api send request, is it possible to queue the requests and process them sequentially or in smaller batches?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.