my environment details, app server- on prim, DB - on prim, on 28th Otc 2021 our DB instance moved from one location to other, since then we are encountering DBV connection break. we have done troubleshooting checking SQL DB logs, network connectivity, jobs etc, nothing is helping us out , is anyone had similar exp or any help or suggestion , below is the error message
- 3rd Jan 2022:
4977,"00:00:00+01:00",4977,"QServer.exe","EUDVMAPPRABR101","10.41.150.89",111388,"Trans_11",43044,"",1000000089,"Error","QUINTIQ_DB: ErrorCode 1000000089: \nError executing statement: SELECT ""Key_SITE"", ""Key_MAJOR"", ""Key_MINOR"", ""Q_ACTIVECALENDARS"", ""Q_ACTIVEDAEMONS"", ""Q_ACTIVETIMERS"", ""Q_ACTIVITYSTATE"", ""Q_AUDITFAILSTRATEGY"", ""Q_AUDITTRAILKEY_SITE"", ""Q_AUDITTRAILKEY_MAJOR"", ""Q_AUDITTRAILKEY_MINOR"", ""Q_DATASETSTORETX"", ""Q_DESCRIPTION"", ""Q_FOLDERID_SITE"", ""Q_FOLDERID_MAJOR"", ""Q_FOLDERID_MINOR"", ""Q_KIND"", ""Q_LOCKEDBY"", ""Q_MODELVERSION"", ""Q_NAME"", ""Q_STATE"", ""Q_PROPAGATORVERSION"", ""Q_TIMEZONESUPPORT"", ""Q_TIMEZONEID"" FROM dbo.""Q_MDSCOMPANY"" WHERE ""MDSID_SITE"" = 713756 AND ""MDSID_MAJOR"" = 0 AND ""MDSID_MINOR"" = 335716945 ORDER BY ""Key_SITE"", ""Key_MAJOR"", ""Key_MINOR""ODBC-return-code -1 : State = 08S01, ErrorCode = 10054, Message = [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host.\r\n\nState = 08S01, ErrorCode = 10054, Message = [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure\n","",72189,[713756.0.335716945]
