Module: ETL Runtime Service
Encounter following error in log ETL_Service.20121213_214131_050.log?
15:39:30.593 Src.ChunkData.1 Chunk#1_2075 contains inappropriate object or statistic
Following is the step to troubleshoot
Connects to ODS database
Find out the schedule # from chunk #
select * from ol_chunk_log where log_id = 2075
LOG_ID SCHEDULE_ID BEGIN_TIME UPDATE_TIME CHUNK_TYPE TABLE_NAME IS_LAST_CHUNK RECEIVE_TIME TRANSFERRED_TIME DELETE_TIME IS_NULL_CHUNK DATA_RECORDS_NUM
------ ----------- ----------------------- ----------------------- ---------- ---------- ------------- ----------------------- ----------------------- ----------- ------------- ----------------
2075 9 2010-09-26 20:00:00.000 2010-09-26 20:15:00.000 NULL OL_DATA3 0 2010-09-26 20:15:02.000 2010-09-26 16:19:06.560 NULL 0 227
Its value is 9
Use schedule # to find layout #
select * from ol_schedule where schedule_id = 9
SCHEDULE_ID LAYOUT_ID TIME_PROFILE_ID START_TIME STOP_TIME REFRESH_RATE IS_NEEDS_TRANSFER FREEZE_TIME
----------- --------- --------------- ----------------------- --------- ------------ ----------------- -----------------------
9 9 1 2010-06-07 13:36:26.670 NULL NULL 1 2010-06-07 13:48:07.297
Its value is 9. This value is very often same as schedule #
select * from ol_report_layout where layout_id = 9
LAYOUT_ID OBJECT_TYPE_ID TENANT_ID LAYOUT_NAME METAGROUP_CLASS METAGROUP_DB_ID ADD_TIME DELETE_TIME LAYOUT_DESCRIPTION UPDATE_TIME TEMPLATE_NAME IS_BRKN
--------- -------------- --------- -------------- --------------- --------------- ----------------------- ----------------------- ---------------------------- ----------- ------------- -------
9 0 101 Agent_Layout_2 100 0 2010-06-10 11:42:40.147 2010-10-13 16:59:08.983 Agent Report Layout with AHT NULL AGENT_AHT1 NULL
This means the chunk belongs to Report Layout Agent_Layout_2 (see DMA), and time of the record is 2010-06-07 13:36:36
Normally this error appear if report layout is deleted from DMA before ETL service able to pull the data into DATAMART/REPORT database. If you confirmed these can be deleted, then take a backup of the ODS database and execute following statement to delete all the entries belongs to "Agent_Layout_2"
detete from ol_report_layout where layout_id = 0
This is no way to undo from DMA, or ETL service. The only way to undo is to restore from database backup, or flashback (Oracle) or similar technology offer by database server
No comments:
Post a Comment