Page 1 of 1

Unknown column in fieldlist issue with Reporting Tables

Posted: Fri Jan 22, 2021 4:05 am
by survia
Processmaker ver 3.5.7.
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.
Thanks

Re: Unknown column in fieldlist issue with Reporting Tables

Posted: Fri Jan 22, 2021 5:47 am
by survia
Another observation - if a field is added into the reporting table and then removed - subsequently this issue will come. But this is not always, happens most of the times.