![\"\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-HouseKeeping-1024x379.png\" "\\"\\"")
<\/figure>\n\n\n\nBusiness Rules<\/strong><\/h2>\n\n\n\n\n- Only active HouseKeeping configurations are available for selection at runtime.<\/li>\n\n\n\n
- Each configuration targets one table using an optional WHERE clause to limit affected rows.<\/li>\n\n\n\n
- Records can be archived to a history table (hst_<table>) before deletion.<\/li>\n\n\n\n
- Records can be exported as XML backup files before deletion.<\/li>\n\n\n\n
- Deleted record count and last run date are updated automatically after each execution.<\/li>\n\n\n\n
- The process can be run interactively or submitted as a background job.<\/li>\n\n\n\n
- If no WHERE clause is defined, all rows in the target table are deleted.<\/li>\n<\/ul>\n\n\n\n
Prerequisites<\/strong><\/h2>\n\n\n\n\n- HouseKeeping configuration record created.<\/li>\n\n\n\n
- Target table identified in the Application Dictionary.<\/li>\n\n\n\n
- WHERE clause tested and validated for correct row selection.<\/li>\n\n\n\n
- Backup folder path configured and accessible, if XML export is enabled.<\/li>\n\n\n\n
- History table (hst_<tablename>) exists, if Save in Historic is enabled.<\/li>\n\n\n\n
- User has System Administrator role access to run the process.<\/li>\n<\/ul>\n\n\n\n
Navigation<\/strong><\/h2>\n\n\n\nMenu \u2192 System Admin \u2192 General Rules \u2192 Server \u2192 House Keeping<\/p>\n\n\n\n
Configuration Steps<\/strong><\/h2>\n\n\n\nStep 1: Identify the Target Table and Data Volume<\/strong><\/h3>\n\n\n\nIn the Application Dictionary, note the table name and its growth pattern. Decide a retention period, for example preserving the last week of data.<\/p>\n\n\n\n
Step 2: Create the House Keeping Configuration Record<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, enter a Name, select the target table, and enter a WhereClause to filter rows outside the retention period.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Name<\/td> Delete T_ReportStatement records preserving last week<\/td> Identifies the configuration in the dropdown<\/td><\/tr> AD_Table_ID<\/td> T_ReportStatement<\/td> Target table for cleanup<\/td><\/tr> WhereClause<\/td> Created < (SysDate – 7)<\/td> Limits deletion to records older than 7 days<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Configure Historic Backup<\/strong><\/h3>\n\n\n\nEnable IsSaveInHistoric to copy matching rows into hst_<tablename> before the delete step runs.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSaveInHistoric<\/td> Yes<\/td> Preserves a copy of deleted rows in the history table<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Configure XML Export Backup (Optional)<\/strong><\/h3>\n\n\n\nEnable IsExportXMLBackup and set a BackupFolder path. The process writes a file named tablename plus timestamp with an .xml extension.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsExportXMLBackup<\/td> Yes<\/td> Enables file-based export before deletion<\/td><\/tr> BackupFolder<\/td> \/idempiere\/backups\/housekeeping<\/td> Storage path for the exported XML file<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Run the HouseKeeping Process<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, select a configuration from the dropdown, optionally check Run as Job, then click Start.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nStep 6: Review the Process Result<\/strong><\/h3>\n\n\n\nAfter execution, review the “@Deleted@” count message. Reopen the configuration record to verify LastRun and LastDeleted were updated.<\/p>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Process deletes more rows than expected<\/td> WhereClause is missing or too broad<\/td> Add a specific date or status filter before running in production<\/td><\/tr> “Cannot insert into hst_” error<\/td> History table does not exist for the target table<\/td> Create the matching hst_<tablename> table before enabling Save in Historic<\/td><\/tr> XML export file is not created<\/td> Backup folder path is invalid or inaccessible<\/td> Verify the folder exists and the application server has write permission<\/td><\/tr> Configuration not visible in dropdown<\/td> Record is marked inactive<\/td> Activate the HouseKeeping configuration record<\/td><\/tr> Deleted count returns zero<\/td> WhereClause matches no current rows<\/td> Review the clause syntax against the current data range<\/td><\/tr> Large table deletion times out<\/td> No index on the filtered column<\/td> Add an index on the filter column or submit the process as a Job<\/td><\/tr> Unexpected duplicate rows in history table<\/td> Same configuration rerun over overlapping data<\/td> Adjust WhereClause so each run only targets new, undeleted rows<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Configure the Scheduler window to automate recurring HouseKeeping runs.<\/li>\n\n\n\n
- Review Application Dictionary table definitions for other candidate tables.<\/li>\n\n\n\n
- Set up backup folder monitoring for XML export files<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The HouseKeeping window in iDempiere lets retailers schedule automatic cleanup of high-volume transactional tables such as report statements and temporary […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22363","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=22363"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions"}],"predecessor-version":[{"id":22367,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions\/22367"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Prerequisites<\/strong><\/h2>\n\n\n\n\n- HouseKeeping configuration record created.<\/li>\n\n\n\n
- Target table identified in the Application Dictionary.<\/li>\n\n\n\n
- WHERE clause tested and validated for correct row selection.<\/li>\n\n\n\n
- Backup folder path configured and accessible, if XML export is enabled.<\/li>\n\n\n\n
- History table (hst_<tablename>) exists, if Save in Historic is enabled.<\/li>\n\n\n\n
- User has System Administrator role access to run the process.<\/li>\n<\/ul>\n\n\n\n
Navigation<\/strong><\/h2>\n\n\n\nMenu \u2192 System Admin \u2192 General Rules \u2192 Server \u2192 House Keeping<\/p>\n\n\n\n
Configuration Steps<\/strong><\/h2>\n\n\n\nStep 1: Identify the Target Table and Data Volume<\/strong><\/h3>\n\n\n\nIn the Application Dictionary, note the table name and its growth pattern. Decide a retention period, for example preserving the last week of data.<\/p>\n\n\n\n
Step 2: Create the House Keeping Configuration Record<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, enter a Name, select the target table, and enter a WhereClause to filter rows outside the retention period.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Name<\/td> Delete T_ReportStatement records preserving last week<\/td> Identifies the configuration in the dropdown<\/td><\/tr> AD_Table_ID<\/td> T_ReportStatement<\/td> Target table for cleanup<\/td><\/tr> WhereClause<\/td> Created < (SysDate – 7)<\/td> Limits deletion to records older than 7 days<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Configure Historic Backup<\/strong><\/h3>\n\n\n\nEnable IsSaveInHistoric to copy matching rows into hst_<tablename> before the delete step runs.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSaveInHistoric<\/td> Yes<\/td> Preserves a copy of deleted rows in the history table<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Configure XML Export Backup (Optional)<\/strong><\/h3>\n\n\n\nEnable IsExportXMLBackup and set a BackupFolder path. The process writes a file named tablename plus timestamp with an .xml extension.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsExportXMLBackup<\/td> Yes<\/td> Enables file-based export before deletion<\/td><\/tr> BackupFolder<\/td> \/idempiere\/backups\/housekeeping<\/td> Storage path for the exported XML file<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Run the HouseKeeping Process<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, select a configuration from the dropdown, optionally check Run as Job, then click Start.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nStep 6: Review the Process Result<\/strong><\/h3>\n\n\n\nAfter execution, review the “@Deleted@” count message. Reopen the configuration record to verify LastRun and LastDeleted were updated.<\/p>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Process deletes more rows than expected<\/td> WhereClause is missing or too broad<\/td> Add a specific date or status filter before running in production<\/td><\/tr> “Cannot insert into hst_” error<\/td> History table does not exist for the target table<\/td> Create the matching hst_<tablename> table before enabling Save in Historic<\/td><\/tr> XML export file is not created<\/td> Backup folder path is invalid or inaccessible<\/td> Verify the folder exists and the application server has write permission<\/td><\/tr> Configuration not visible in dropdown<\/td> Record is marked inactive<\/td> Activate the HouseKeeping configuration record<\/td><\/tr> Deleted count returns zero<\/td> WhereClause matches no current rows<\/td> Review the clause syntax against the current data range<\/td><\/tr> Large table deletion times out<\/td> No index on the filtered column<\/td> Add an index on the filter column or submit the process as a Job<\/td><\/tr> Unexpected duplicate rows in history table<\/td> Same configuration rerun over overlapping data<\/td> Adjust WhereClause so each run only targets new, undeleted rows<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Configure the Scheduler window to automate recurring HouseKeeping runs.<\/li>\n\n\n\n
- Review Application Dictionary table definitions for other candidate tables.<\/li>\n\n\n\n
- Set up backup folder monitoring for XML export files<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The HouseKeeping window in iDempiere lets retailers schedule automatic cleanup of high-volume transactional tables such as report statements and temporary […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22363","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=22363"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions"}],"predecessor-version":[{"id":22367,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions\/22367"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Navigation<\/strong><\/h2>\n\n\n\nMenu \u2192 System Admin \u2192 General Rules \u2192 Server \u2192 House Keeping<\/p>\n\n\n\n
Configuration Steps<\/strong><\/h2>\n\n\n\nStep 1: Identify the Target Table and Data Volume<\/strong><\/h3>\n\n\n\nIn the Application Dictionary, note the table name and its growth pattern. Decide a retention period, for example preserving the last week of data.<\/p>\n\n\n\n
Step 2: Create the House Keeping Configuration Record<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, enter a Name, select the target table, and enter a WhereClause to filter rows outside the retention period.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Name<\/td> Delete T_ReportStatement records preserving last week<\/td> Identifies the configuration in the dropdown<\/td><\/tr> AD_Table_ID<\/td> T_ReportStatement<\/td> Target table for cleanup<\/td><\/tr> WhereClause<\/td> Created < (SysDate – 7)<\/td> Limits deletion to records older than 7 days<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Configure Historic Backup<\/strong><\/h3>\n\n\n\nEnable IsSaveInHistoric to copy matching rows into hst_<tablename> before the delete step runs.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSaveInHistoric<\/td> Yes<\/td> Preserves a copy of deleted rows in the history table<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Configure XML Export Backup (Optional)<\/strong><\/h3>\n\n\n\nEnable IsExportXMLBackup and set a BackupFolder path. The process writes a file named tablename plus timestamp with an .xml extension.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsExportXMLBackup<\/td> Yes<\/td> Enables file-based export before deletion<\/td><\/tr> BackupFolder<\/td> \/idempiere\/backups\/housekeeping<\/td> Storage path for the exported XML file<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Run the HouseKeeping Process<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, select a configuration from the dropdown, optionally check Run as Job, then click Start.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nStep 6: Review the Process Result<\/strong><\/h3>\n\n\n\nAfter execution, review the “@Deleted@” count message. Reopen the configuration record to verify LastRun and LastDeleted were updated.<\/p>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Process deletes more rows than expected<\/td> WhereClause is missing or too broad<\/td> Add a specific date or status filter before running in production<\/td><\/tr> “Cannot insert into hst_” error<\/td> History table does not exist for the target table<\/td> Create the matching hst_<tablename> table before enabling Save in Historic<\/td><\/tr> XML export file is not created<\/td> Backup folder path is invalid or inaccessible<\/td> Verify the folder exists and the application server has write permission<\/td><\/tr> Configuration not visible in dropdown<\/td> Record is marked inactive<\/td> Activate the HouseKeeping configuration record<\/td><\/tr> Deleted count returns zero<\/td> WhereClause matches no current rows<\/td> Review the clause syntax against the current data range<\/td><\/tr> Large table deletion times out<\/td> No index on the filtered column<\/td> Add an index on the filter column or submit the process as a Job<\/td><\/tr> Unexpected duplicate rows in history table<\/td> Same configuration rerun over overlapping data<\/td> Adjust WhereClause so each run only targets new, undeleted rows<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Configure the Scheduler window to automate recurring HouseKeeping runs.<\/li>\n\n\n\n
- Review Application Dictionary table definitions for other candidate tables.<\/li>\n\n\n\n
- Set up backup folder monitoring for XML export files<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The HouseKeeping window in iDempiere lets retailers schedule automatic cleanup of high-volume transactional tables such as report statements and temporary […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22363","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=22363"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions"}],"predecessor-version":[{"id":22367,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions\/22367"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Step 1: Identify the Target Table and Data Volume<\/strong><\/h3>\n\n\n\nIn the Application Dictionary, note the table name and its growth pattern. Decide a retention period, for example preserving the last week of data.<\/p>\n\n\n\n
Step 2: Create the House Keeping Configuration Record<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, enter a Name, select the target table, and enter a WhereClause to filter rows outside the retention period.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Name<\/td> Delete T_ReportStatement records preserving last week<\/td> Identifies the configuration in the dropdown<\/td><\/tr> AD_Table_ID<\/td> T_ReportStatement<\/td> Target table for cleanup<\/td><\/tr> WhereClause<\/td> Created < (SysDate – 7)<\/td> Limits deletion to records older than 7 days<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Configure Historic Backup<\/strong><\/h3>\n\n\n\nEnable IsSaveInHistoric to copy matching rows into hst_<tablename> before the delete step runs.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSaveInHistoric<\/td> Yes<\/td> Preserves a copy of deleted rows in the history table<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Configure XML Export Backup (Optional)<\/strong><\/h3>\n\n\n\nEnable IsExportXMLBackup and set a BackupFolder path. The process writes a file named tablename plus timestamp with an .xml extension.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsExportXMLBackup<\/td> Yes<\/td> Enables file-based export before deletion<\/td><\/tr> BackupFolder<\/td> \/idempiere\/backups\/housekeeping<\/td> Storage path for the exported XML file<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Run the HouseKeeping Process<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, select a configuration from the dropdown, optionally check Run as Job, then click Start.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nStep 6: Review the Process Result<\/strong><\/h3>\n\n\n\nAfter execution, review the “@Deleted@” count message. Reopen the configuration record to verify LastRun and LastDeleted were updated.<\/p>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Process deletes more rows than expected<\/td> WhereClause is missing or too broad<\/td> Add a specific date or status filter before running in production<\/td><\/tr> “Cannot insert into hst_” error<\/td> History table does not exist for the target table<\/td> Create the matching hst_<tablename> table before enabling Save in Historic<\/td><\/tr> XML export file is not created<\/td> Backup folder path is invalid or inaccessible<\/td> Verify the folder exists and the application server has write permission<\/td><\/tr> Configuration not visible in dropdown<\/td> Record is marked inactive<\/td> Activate the HouseKeeping configuration record<\/td><\/tr> Deleted count returns zero<\/td> WhereClause matches no current rows<\/td> Review the clause syntax against the current data range<\/td><\/tr> Large table deletion times out<\/td> No index on the filtered column<\/td> Add an index on the filter column or submit the process as a Job<\/td><\/tr> Unexpected duplicate rows in history table<\/td> Same configuration rerun over overlapping data<\/td> Adjust WhereClause so each run only targets new, undeleted rows<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Configure the Scheduler window to automate recurring HouseKeeping runs.<\/li>\n\n\n\n
- Review Application Dictionary table definitions for other candidate tables.<\/li>\n\n\n\n
- Set up backup folder monitoring for XML export files<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The HouseKeeping window in iDempiere lets retailers schedule automatic cleanup of high-volume transactional tables such as report statements and temporary […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22363","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=22363"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions"}],"predecessor-version":[{"id":22367,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions\/22367"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Open the House Keeping window, enter a Name, select the target table, and enter a WhereClause to filter rows outside the retention period.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>Name<\/td> Delete T_ReportStatement records preserving last week<\/td> Identifies the configuration in the dropdown<\/td><\/tr> AD_Table_ID<\/td> T_ReportStatement<\/td> Target table for cleanup<\/td><\/tr> WhereClause<\/td> Created < (SysDate – 7)<\/td> Limits deletion to records older than 7 days<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 3: Configure Historic Backup<\/strong><\/h3>\n\n\n\nEnable IsSaveInHistoric to copy matching rows into hst_<tablename> before the delete step runs.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsSaveInHistoric<\/td> Yes<\/td> Preserves a copy of deleted rows in the history table<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 4: Configure XML Export Backup (Optional)<\/strong><\/h3>\n\n\n\nEnable IsExportXMLBackup and set a BackupFolder path. The process writes a file named tablename plus timestamp with an .xml extension.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nField<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>IsExportXMLBackup<\/td> Yes<\/td> Enables file-based export before deletion<\/td><\/tr> BackupFolder<\/td> \/idempiere\/backups\/housekeeping<\/td> Storage path for the exported XML file<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nStep 5: Run the HouseKeeping Process<\/strong><\/h3>\n\n\n\nOpen the House Keeping window, select a configuration from the dropdown, optionally check Run as Job, then click Start.<\/p>\n\n\n\n
Field Reference<\/strong><\/h3>\n\n\n\nStep 6: Review the Process Result<\/strong><\/h3>\n\n\n\nAfter execution, review the “@Deleted@” count message. Reopen the configuration record to verify LastRun and LastDeleted were updated.<\/p>\n\n\n\n
Common Issues and Resolutions<\/strong><\/h2>\n\n\n\nIssue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>Process deletes more rows than expected<\/td> WhereClause is missing or too broad<\/td> Add a specific date or status filter before running in production<\/td><\/tr> “Cannot insert into hst_” error<\/td> History table does not exist for the target table<\/td> Create the matching hst_<tablename> table before enabling Save in Historic<\/td><\/tr> XML export file is not created<\/td> Backup folder path is invalid or inaccessible<\/td> Verify the folder exists and the application server has write permission<\/td><\/tr> Configuration not visible in dropdown<\/td> Record is marked inactive<\/td> Activate the HouseKeeping configuration record<\/td><\/tr> Deleted count returns zero<\/td> WhereClause matches no current rows<\/td> Review the clause syntax against the current data range<\/td><\/tr> Large table deletion times out<\/td> No index on the filtered column<\/td> Add an index on the filter column or submit the process as a Job<\/td><\/tr> Unexpected duplicate rows in history table<\/td> Same configuration rerun over overlapping data<\/td> Adjust WhereClause so each run only targets new, undeleted rows<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nNext Steps<\/strong><\/h2>\n\n\n\n\n- Configure the Scheduler window to automate recurring HouseKeeping runs.<\/li>\n\n\n\n
- Review Application Dictionary table definitions for other candidate tables.<\/li>\n\n\n\n
- Set up backup folder monitoring for XML export files<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
The HouseKeeping window in iDempiere lets retailers schedule automatic cleanup of high-volume transactional tables such as report statements and temporary […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22363","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=22363"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions"}],"predecessor-version":[{"id":22367,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22363\/revisions\/22367"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Field<\/strong><\/td>| Sample Value<\/strong><\/td> | Description<\/strong><\/td><\/tr><\/thead> | Name<\/td> | Delete T_ReportStatement records preserving last week<\/td> | Identifies the configuration in the dropdown<\/td><\/tr> | AD_Table_ID<\/td> | T_ReportStatement<\/td> | Target table for cleanup<\/td><\/tr> | WhereClause<\/td> | Created < (SysDate – 7)<\/td> | Limits deletion to records older than 7 days<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n | Step 3: Configure Historic Backup<\/strong><\/h3>\n\n\n\n
|