Good morning all,
Starting yesterday we are running into an issue that we haven't seen before. This is happening not at every 30 minute interval, but it's happening more than it isn't. Reprocessing PMQ manually seems to work fine and clear all the .ERR files. Have any of you ran into this before? We know of nothing that changed yesterday to cause it and our SQL dba says everything looks fine on his end. We're running 2021 R4 Patch 4 and everything has been fine for months until yesterday.
We have also thought about restarting StatServer and/or StatServer Agent. Do you guys know if that'll cause a switchover event and/or potentially clear this error?
The common error we see at most intervals is:
Data for StatServerWorkgroupU-w64:IC Report Logging7 failed processing with this message: PMDB ERROR - SQueueMsg [ SVer(4) ReportLog(85) Action(EICLogQueueInsert) Data[(100) rows with (0) fields, filter-() ] [I3ODBCCONNECTION.CPP, 1063] A database error was generated in function SQLEndTran: DBMS error code = -2147467259; SQLSTATE = 08S01; Message = '[Microsoft][SQL Server Native Client 11.0]Communication link failure'
Any insight or suggestions are greatly appreciated.
Thanks as always.
#PlatformAdministration#Reporting/Analytics#SystemAdministration------------------------------
Shane
------------------------------