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.
Re: Unknown column in fieldlist issue with Reporting Tables
Posted: Fri Jan 21, 2022 9:50 am
by RobertoB
Hi survia,
same problem here, with same PM version.
Happens systematically when you edit a column name of a Report Table or when you delete a column. Re-adding the column or renaming it back to its original name does not solve the problem.
Deleting and re-creating the table with the same name does NOT solve the problem. It seems that PM keeps some state of the edited PM tables.
The only solution is to delete the report table and create a new one with a different name.
This bug is really unforgiving, i.e. you cannot fix it if you make errors in the report table definition.
Also it forces you to be very selective with the columns you add to a report table. You will never be able to remove them.
Help would be appreciated
Roberto
Re: Unknown column in fieldlist issue with Reporting Tables
Posted: Sat Apr 02, 2022 10:51 am
by ronrich
Hello Survia,
This has been identified as a bug in ProcessMaker and I ha e reported it to the Engineering Team. Still don't know about a fix version, but the steps you described are the current valid workaround.
Cheers,
Re: Unknown column in fieldlist issue with Reporting Tables
Posted: Fri Apr 22, 2022 5:28 am
by mamyjx88
I face the same case. I will try you guys' way. Hope that it work well.
https://fireboyand-watergirl.co/
Re: Unknown column in fieldlist issue with Reporting Tables
Posted: Fri Apr 22, 2022 9:50 am
by ronrich
Hello Survia,
Please try restarting the supervisord service:
service supervisord restart
The problem here is that since PM 3.5 uses async mode for routing and for table generation, the job will grab a snapshot of the report table when it was created, so, even after editing it, it will still look o the initial snapshot, in this case, restarting the supervisord service will help, on the other hand, you could disable the async mode and make it sync, you add this line in the envñini file under [installation_path]/workflow/engine/config/env.ini
disable_task_manager_routing_async = 1
https://wiki.processmaker.com/3.5/Configuration_File_env.ini#Available_Settings
Unfortunately, this is only available from 3.5.8
Let me know if any of these suggestions worked.
Regards,