We are getting a head blocker for the query

(0) Share

Report

Posted on by shanawaz davood basha

561

Hi,

We are getting a head blocker for the below query.

(@P1 int,@P2 nvarchar(256))SELECT TOP 1 T1.SERVERID,T1.ISDEFAULTREPORTMODELSERVER,T1.SERVERURL,T1.ISDEFAULTREPORTLIBRARYSERVER,T1.AXAPTAREPORTFOLDER,T1.DESCRIPTION,T1.DATASOURCENAME,T1.REPORTMANAGERURL,T1.SERVERINSTANCE,T1.AOSID,T1.CONFIGURATIONID,T1.ISSHAREPOINTINTEGRATED,T1.RECVERSION,T1.RECID FROM SRSSERVERS T1 WHERE ((ISDEFAULTREPORTLIBRARYSERVER=@P1) AND (AOSID=@P2))

We are killing the process in the sql server management studio activity monitor.

Any idea to solve this issue.

Thanks

Shan

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

Hi Shan,

Are you able to resolve this issue , if so please let us know how.

Regards.

Rakshith

Was this reply helpful? Yes No