- Wed Feb 05, 2020 2:07 am
#827510
Hi,
I am facing a problem while regenrating a report table of type Grid. The error is
Update
Unable to execute INSERT statement. [wrapped: Could not execute update [Native Error: Column 'APP_NUMBER' cannot be null] [User Info: INSERT INTO PMT_PMS_MONT_GRID (`APP_UID`,`APP_NUMBER`,`APP_STATUS`,`ROW`,`DAILY_TARGET`,`ENTRY`,`POINT`,`TASK`) VALUES ('5977759195de903ff929fe2024258015',NULL,'DRAFT',5,'1','0.5','0.5',NULL)]]
Actually the report table contain 4 more columns ISSELECT, PROJECT, REASON and CASE_NUMBER. And also the table is not listing all the cases. PM version 3.2.1 -community
Please tell me how to fix the same.
I am facing a problem while regenrating a report table of type Grid. The error is
Update
Unable to execute INSERT statement. [wrapped: Could not execute update [Native Error: Column 'APP_NUMBER' cannot be null] [User Info: INSERT INTO PMT_PMS_MONT_GRID (`APP_UID`,`APP_NUMBER`,`APP_STATUS`,`ROW`,`DAILY_TARGET`,`ENTRY`,`POINT`,`TASK`) VALUES ('5977759195de903ff929fe2024258015',NULL,'DRAFT',5,'1','0.5','0.5',NULL)]]
Actually the report table contain 4 more columns ISSELECT, PROJECT, REASON and CASE_NUMBER. And also the table is not listing all the cases. PM version 3.2.1 -community
Please tell me how to fix the same.