duplicate key in PK_CHUNK_LOG

[helpme]

ETL is refusing to write data into datamart and I get and error:
key violation in CHUNK_LOG

what do I do?

[ecki]

Hi Helpyou,

Could you post the whole error message you are getting?
Or better, could you post here the whole ETL logfile?

Cheers,

e.

[ecki]

It sounds you have problem with transfer process which probably died in the middle of transferring data and did not mark already transferred records in ODS ol_chunk_log table as transferred. Therefore when the ETL job tries to transfer the problematic chunks again it is getting back this violation error from DataMart. You would have to set manually transfer time for those records in ol_chunk_log table which were already transferred. Or, the easiest and fastest way would be you mark all records in ods as transferred event those which actually weren't yet transferred.  But in the last case you would lose all historical data from the troubled date up to now.

BUT, I haven't seen the ETL log yet, so DON'T do anything but post the logs here!!!

e.