Reporting database can not be created, gfimreportingq MSMQ builds up

Versions / Builds Affected

20.3

Status

Open

TT / JIRAID

GFIME-3232

How to Identify

gfimreportingq MSMQ builds up slowly but steadily even when reporting is disabled, recovery queue is not being used by the software, main queue is simply not draining. Spam Digests are generated with 0 items due to the reporting issue Reports.FDB will not be created, when using SQL we see the following error: ReportingGenerator","Error: Problem when retrieving the Reporting servers at GetReportingServers(): System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'meces_servers'. No errors are logged to the middleman logs

Required Actions

Full logs and escalate.