SQL HeadBlocker issue SRSServers table AX 2012 R2 CU9

(0) Share

Report

Posted on by DynamicsAXExplorer

431

Hi All,

We keep getting this SQL Head Blocker Issue when we check SQL Server Management Studio. It stops many other processes. When we kill this, everything goes fine. Any ideas about this?

(@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))

Ax2012r2 cu9

FYI: We recently upgrade from Cu7 to cu9.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DynamicsAXExplorer 431 on at

Like (0)

Report

Hi All,

We are able to resolve this error.

This is happening because of the customized code. When we are trying to release production order we are running report similar to Route card and tables defined in that report are regular tables instead of in memory tables and some code changes using best practices. . Those changes resolved this headblocker

Was this reply helpful? Yes No