Dimension update result in element loss
Posted: Thu Oct 19, 2017 1:41 pm
We had a data loss issue due to element loss during dimension update.
The TI process created to update this GL account dimension has been running for a few years without problem. One process will call on another at epilog.
I checked the log and no other process is running at the same time.
Below is the log. The process can be identified by "4148". As you can see, the process resulted in error due to a rule in one cube. However we never had this problem before and I wonder why we had the problem this time.
Any help is appreciated.
Kenneth
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Chore Chore "6. Transfer SAL RPT to SAL OBM MAPPING" executed by scheduler
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Process Process 06AM_Chorequit executed by chore 6. Transfer SAL RPT to SAL OBM MAPPING
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Process Process "06AM_Chorequit": finished executing normally, elapsed time 0.00 seconds
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Process Process corp_obm_sal_int_data_transfer_corp_SAL_RPT_to_corp_SAL_OBM_MAPPING executed by chore 6. Transfer SAL RPT to SAL OBM MAPPING
3640 [] INFO 2017-10-18 16:33:27.346 TM1.Process Process "corp_obm_sal_int_data_transfer_corp_SAL_RPT_to_corp_SAL_OBM_MAPPING": finished executing normally, elapsed time 57.21 seconds
3640 [] INFO 2017-10-18 16:33:27.346 TM1.Chore Chore "6. Transfer SAL RPT to SAL OBM MAPPING" time = 57.21 seconds
3640 [] INFO 2017-10-18 16:33:28.890 TM1.Chore Chore "6. Transfer SAL RPT to SAL OBM MAPPING" finished executing
4148 [eaa] INFO 2017-10-18 16:33:57.657 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV" executed by user "ABC"
4148 [eaa] ERROR 2017-10-18 16:33:58.733 TM1.Dimension corp_OBM_CALENDARIZATION Dimension Update Fail. Rule Is Invalid: Error compiling rule, line number 49: Element not found "01000"
[{'01000','01005','02500','29009','26110','26115','26125','57900','57910','70190'},'Method'] = S: 'N/A';
4148 [eaa] ERROR 2017-10-18 16:34:00.636 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV": : Execution was aborted. Error file: <TM1ProcessError_20171018163400_meta_dim_update_corp_obm_account_FROM_CSV.log>
5740 [] INFO 2017-10-18 16:34:30.105 TM1.Chore Chore "7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT" executed by scheduler
5740 [] INFO 2017-10-18 16:34:30.105 TM1.Process Process corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_INPUT executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] ERROR 2017-10-18 16:34:30.324 TM1.Process Process "corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_INPUT": : Execution was aborted. Error file: <TM1ProcessError_20171018163430_corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_INPUT.log> : Dimension element not found
5740 [] INFO 2017-10-18 16:34:30.324 TM1.Process Process corp_obm_data_update_corp_OBM_BUDGET_INPUT_zero_FTE_n_CF_SnB_Amount executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] ERROR 2017-10-18 16:34:31.291 TM1.Process Process "corp_obm_data_update_corp_OBM_BUDGET_INPUT_zero_FTE_n_CF_SnB_Amount": finished executing with errors. Error file: <TM1ProcessError_20171018163430_corp_obm_data_update_corp_OBM_BUDGET_INPUT_zero_FTE_n_CF_SnB_Amount.log> : Invalid key: Dimension Name: "corp_obm_account", Element Name (Key): "02500"
5740 [] INFO 2017-10-18 16:34:31.291 TM1.Process Process corp_SAL_OBM_MAPPING_to_corp_SPM_REORG_MAPPING executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
4148 [eaa] INFO 2017-10-18 16:34:34.130 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV" executed by user "ABC"
5740 [] INFO 2017-10-18 16:34:42.195 TM1.Process Process "corp_SAL_OBM_MAPPING_to_corp_SPM_REORG_MAPPING": finished executing normally, elapsed time 10.90 seconds
5740 [] INFO 2017-10-18 16:34:42.195 TM1.Process Process corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_INPUT executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] ERROR 2017-10-18 16:34:42.445 TM1.Process Process "corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_INPUT": : Execution was aborted. Error file: <TM1ProcessError_20171018163442_corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_INPUT.log> : Dimension element not found
5740 [] INFO 2017-10-18 16:34:42.445 TM1.Process Process meta_dim_update_corp_obm_BVE_alias executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] INFO 2017-10-18 16:34:43.069 TM1.Process Process "meta_dim_update_corp_obm_BVE_alias": finished executing normally, elapsed time 0.62 seconds
5740 [] INFO 2017-10-18 16:34:43.069 TM1.Chore Chore "7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT" time = 12.96 seconds
5740 [] INFO 2017-10-18 16:34:43.209 TM1.Chore Chore "7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT" finished executing
4148 [eaa] ERROR 2017-10-18 16:34:44.317 TM1.Dimension corp_OBM_CALENDARIZATION Dimension Update Fail. Rule Is Invalid: Error compiling rule, line number 49: Element not found "01000"
[{'01000','01005','02500','29009','26110','26115','26125','57900','57910','70190'},'Method'] = S: 'N/A';
4148 [eaa] ERROR 2017-10-18 16:34:44.566 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV": : Execution was aborted. Error file: <TM1ProcessError_20171018163444_meta_dim_update_corp_obm_account_FROM_CSV.log>
5204 [] INFO 2017-10-18 16:37:50.053 TM1.Chore Chore "8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT" executed by scheduler
5204 [] INFO 2017-10-18 16:37:50.053 TM1.Process Process corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_REPORT executed by chore 8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT
5204 [] ERROR 2017-10-18 16:37:50.256 TM1.Process Process "corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_REPORT": : Execution was aborted. Error file: <TM1ProcessError_20171018163750_corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_REPORT.log> : Dimension element not found
5204 [] INFO 2017-10-18 16:37:50.256 TM1.Process Process corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all executed by chore 8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT
5204 [] INFO 2017-10-18 16:37:50.256 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT" run from process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all" by user "R*8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT"
5204 [] INFO 2017-10-18 16:38:01.691 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT": finished executing normally, elapsed time 11.43 seconds
5204 [] INFO 2017-10-18 16:38:01.691 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_sal_from_obm" run from process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all" by user "R*8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT"
5204 [] ERROR 2017-10-18 16:38:01.784 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_sal_from_obm": : Execution was aborted. Error file: <TM1ProcessError_20171018163801_corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_sal_from_obm.log> : Dimension element not found
5204 [] INFO 2017-10-18 16:38:01.784 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_WWW_Fcst_Adj" run from process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all" by user "R*8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT"
5204 [] INFO 2017-10-18 16:38:01.940 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_WWW_Fcst_Adj": finished executing normally, elapsed time 0.16 seconds
5204 [] ERROR 2017-10-18 16:38:01.956 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all": finished executing with errors. Error file: <TM1ProcessError_20171018163801_corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all.log>
5204 [] INFO 2017-10-18 16:38:01.956 TM1.Process Process corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_REPORT executed by chore 8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT
5204 [] ERROR 2017-10-18 16:38:02.205 TM1.Process Process "corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_REPORT": : Execution was aborted. Error file: <TM1ProcessError_20171018163802_corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_REPORT.log> : Dimension element not found
5204 [] INFO 2017-10-18 16:38:02.205 TM1.Chore Chore "8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT" time = 12.15 seconds
5204 [] INFO 2017-10-18 16:38:03.266 TM1.Chore Chore "8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT" finished executing
The TI process created to update this GL account dimension has been running for a few years without problem. One process will call on another at epilog.
I checked the log and no other process is running at the same time.
Below is the log. The process can be identified by "4148". As you can see, the process resulted in error due to a rule in one cube. However we never had this problem before and I wonder why we had the problem this time.
Any help is appreciated.
Kenneth
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Chore Chore "6. Transfer SAL RPT to SAL OBM MAPPING" executed by scheduler
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Process Process 06AM_Chorequit executed by chore 6. Transfer SAL RPT to SAL OBM MAPPING
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Process Process "06AM_Chorequit": finished executing normally, elapsed time 0.00 seconds
3640 [] INFO 2017-10-18 16:32:30.140 TM1.Process Process corp_obm_sal_int_data_transfer_corp_SAL_RPT_to_corp_SAL_OBM_MAPPING executed by chore 6. Transfer SAL RPT to SAL OBM MAPPING
3640 [] INFO 2017-10-18 16:33:27.346 TM1.Process Process "corp_obm_sal_int_data_transfer_corp_SAL_RPT_to_corp_SAL_OBM_MAPPING": finished executing normally, elapsed time 57.21 seconds
3640 [] INFO 2017-10-18 16:33:27.346 TM1.Chore Chore "6. Transfer SAL RPT to SAL OBM MAPPING" time = 57.21 seconds
3640 [] INFO 2017-10-18 16:33:28.890 TM1.Chore Chore "6. Transfer SAL RPT to SAL OBM MAPPING" finished executing
4148 [eaa] INFO 2017-10-18 16:33:57.657 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV" executed by user "ABC"
4148 [eaa] ERROR 2017-10-18 16:33:58.733 TM1.Dimension corp_OBM_CALENDARIZATION Dimension Update Fail. Rule Is Invalid: Error compiling rule, line number 49: Element not found "01000"
[{'01000','01005','02500','29009','26110','26115','26125','57900','57910','70190'},'Method'] = S: 'N/A';
4148 [eaa] ERROR 2017-10-18 16:34:00.636 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV": : Execution was aborted. Error file: <TM1ProcessError_20171018163400_meta_dim_update_corp_obm_account_FROM_CSV.log>
5740 [] INFO 2017-10-18 16:34:30.105 TM1.Chore Chore "7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT" executed by scheduler
5740 [] INFO 2017-10-18 16:34:30.105 TM1.Process Process corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_INPUT executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] ERROR 2017-10-18 16:34:30.324 TM1.Process Process "corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_INPUT": : Execution was aborted. Error file: <TM1ProcessError_20171018163430_corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_INPUT.log> : Dimension element not found
5740 [] INFO 2017-10-18 16:34:30.324 TM1.Process Process corp_obm_data_update_corp_OBM_BUDGET_INPUT_zero_FTE_n_CF_SnB_Amount executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] ERROR 2017-10-18 16:34:31.291 TM1.Process Process "corp_obm_data_update_corp_OBM_BUDGET_INPUT_zero_FTE_n_CF_SnB_Amount": finished executing with errors. Error file: <TM1ProcessError_20171018163430_corp_obm_data_update_corp_OBM_BUDGET_INPUT_zero_FTE_n_CF_SnB_Amount.log> : Invalid key: Dimension Name: "corp_obm_account", Element Name (Key): "02500"
5740 [] INFO 2017-10-18 16:34:31.291 TM1.Process Process corp_SAL_OBM_MAPPING_to_corp_SPM_REORG_MAPPING executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
4148 [eaa] INFO 2017-10-18 16:34:34.130 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV" executed by user "ABC"
5740 [] INFO 2017-10-18 16:34:42.195 TM1.Process Process "corp_SAL_OBM_MAPPING_to_corp_SPM_REORG_MAPPING": finished executing normally, elapsed time 10.90 seconds
5740 [] INFO 2017-10-18 16:34:42.195 TM1.Process Process corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_INPUT executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] ERROR 2017-10-18 16:34:42.445 TM1.Process Process "corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_INPUT": : Execution was aborted. Error file: <TM1ProcessError_20171018163442_corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_INPUT.log> : Dimension element not found
5740 [] INFO 2017-10-18 16:34:42.445 TM1.Process Process meta_dim_update_corp_obm_BVE_alias executed by chore 7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT
5740 [] INFO 2017-10-18 16:34:43.069 TM1.Process Process "meta_dim_update_corp_obm_BVE_alias": finished executing normally, elapsed time 0.62 seconds
5740 [] INFO 2017-10-18 16:34:43.069 TM1.Chore Chore "7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT" time = 12.96 seconds
5740 [] INFO 2017-10-18 16:34:43.209 TM1.Chore Chore "7. Transfer SAL OBM MAPPING to OBM BUDGET INPUT" finished executing
4148 [eaa] ERROR 2017-10-18 16:34:44.317 TM1.Dimension corp_OBM_CALENDARIZATION Dimension Update Fail. Rule Is Invalid: Error compiling rule, line number 49: Element not found "01000"
[{'01000','01005','02500','29009','26110','26115','26125','57900','57910','70190'},'Method'] = S: 'N/A';
4148 [eaa] ERROR 2017-10-18 16:34:44.566 TM1.Process Process "meta_dim_update_corp_obm_account_FROM_CSV": : Execution was aborted. Error file: <TM1ProcessError_20171018163444_meta_dim_update_corp_obm_account_FROM_CSV.log>
5204 [] INFO 2017-10-18 16:37:50.053 TM1.Chore Chore "8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT" executed by scheduler
5204 [] INFO 2017-10-18 16:37:50.053 TM1.Process Process corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_REPORT executed by chore 8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT
5204 [] ERROR 2017-10-18 16:37:50.256 TM1.Process Process "corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_REPORT": : Execution was aborted. Error file: <TM1ProcessError_20171018163750_corp_obm_data_transfer_corp_SAL_OBM_MAPPING_to_corp_OBM_BUDGET_REPORT.log> : Dimension element not found
5204 [] INFO 2017-10-18 16:37:50.256 TM1.Process Process corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all executed by chore 8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT
5204 [] INFO 2017-10-18 16:37:50.256 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT" run from process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all" by user "R*8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT"
5204 [] INFO 2017-10-18 16:38:01.691 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT": finished executing normally, elapsed time 11.43 seconds
5204 [] INFO 2017-10-18 16:38:01.691 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_sal_from_obm" run from process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all" by user "R*8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT"
5204 [] ERROR 2017-10-18 16:38:01.784 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_sal_from_obm": : Execution was aborted. Error file: <TM1ProcessError_20171018163801_corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_sal_from_obm.log> : Dimension element not found
5204 [] INFO 2017-10-18 16:38:01.784 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_WWW_Fcst_Adj" run from process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all" by user "R*8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT"
5204 [] INFO 2017-10-18 16:38:01.940 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_BUDGET_REPORT_WWW_Fcst_Adj": finished executing normally, elapsed time 0.16 seconds
5204 [] ERROR 2017-10-18 16:38:01.956 TM1.Process Process "corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all": finished executing with errors. Error file: <TM1ProcessError_20171018163801_corp_obm_data_transfer_corp_OBM_BUDGET_INPUT_to_corp_OBM_REPORT_all.log>
5204 [] INFO 2017-10-18 16:38:01.956 TM1.Process Process corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_REPORT executed by chore 8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT
5204 [] ERROR 2017-10-18 16:38:02.205 TM1.Process Process "corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_REPORT": : Execution was aborted. Error file: <TM1ProcessError_20171018163802_corp_obm_data_transfer_corp_SPM_REORG_MAPPING_to_corp_OBM_BUDGET_REPORT.log> : Dimension element not found
5204 [] INFO 2017-10-18 16:38:02.205 TM1.Chore Chore "8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT" time = 12.15 seconds
5204 [] INFO 2017-10-18 16:38:03.266 TM1.Chore Chore "8. Transfer SAL OBM MAPPING and OBM BUDGET INPUT to OBM REPORT" finished executing