{"id":15893,"date":"2018-08-16T23:08:42","date_gmt":"2018-08-17T06:08:42","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=15893"},"modified":"2020-08-26T15:48:03","modified_gmt":"2020-08-26T22:48:03","slug":"kb0022761-to-clean-up-chunks-of-reports-of-data-when-overwhelmed","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/kb0022761-to-clean-up-chunks-of-reports-of-data-when-overwhelmed\/","title":{"rendered":"KB00023359: Resolving report job failure when overwhelmed with data quantity"},"content":{"rendered":"
delete from\u00a0batch_instance\u00a0where\u00a0last_modified\u00a0<\u00a0(select\u00a0last_execution_at\u00a0from\u00a0last_execution\u00a0where\u00a0job='BATCH_INSTANCE_LAST_UPDATE');\r\ndelete from\u00a0finished_batch_instance;\r\ndelete from\u00a0finished_batch_xml_data;\r\ndelete from\u00a0modified_batch_instance;\r\ndelete from throughput_common_data\u00a0where\u00a0end_time\u00a0<\u00a0(select\u00a0last_execution_at\u00a0from\u00a0last_execution\u00a0where\u00a0job='BATCH_INSTANCE_LAST_UPDATE');\r\ndelete from\u00a0throughput_common_module_data\u00a0where\u00a0end_time\u00a0<\u00a0(select\u00a0last_execution_at\u00a0from\u00a0last_execution\u00a0where\u00a0job='BATCH_INSTANCE_LAST_UPDATE');\r\n<\/pre>\n<\/li>\n<\/ul>\n\n
- \n
Once you have successfully execute this query, place the attached files in below location:<\/div>\n<\/li>\n<\/ol>\n\n
- {Ephesoft Installation Directory}\\Application\\WEB-INF\\classes\\META-INF\\dcma-reporting\\Dashboard<\/li>\n<\/ul>\n
\n
- Restart the server.<\/li>\n<\/ol>\n
<\/div>\nSuggestion:<\/strong><\/div>\nEphesoft can adjust the cron expressions for cleanup to run during non-working hours, or during a time when the load on the server is known not to be high.<\/p>\n
This could be a dashboard job run in an interval of 4 hours.<\/p>\n","protected":false},"excerpt":{"rendered":"
KB Article #: KB0023359 Topic\/Category:\u00a0Report Applies to:\u00a0v4.1.2.1 without Advanced Reporting Issue:\u00a0Report jobs fail when a large quantity data is processed […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12363],"tags":[1397,553,1398,1430,968],"yoast_head":"\n
KB00023359: Resolving report job failure when overwhelmed with data quantity | Ephesoft Docs<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n