After creating reporting table - new cases are struck in draft mode and routing to next task is not happening. Following error in log.
production ERROR: [wrapped: Could not execute query [Native Error: Unknown column 'PMT_PMS_EDIT_STATUS.FHEMPNO' in 'field list'
The referenced field FHEMPNO is part of the process, but not added into the report table. Only deleting the report table will solve this issue and we must restart the queues (laravel processes) so that ones struck in the queue are released.
Recreating the report table again - the issue is not there, everything works fine. This has happened with few reporting tables across a couple of processes so far since we installed three weeks before.
Not sure if anyone else has faced this.