Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: helpme on April 16, 2009, 08:30:48 AM

Title: duplicate key in PK_CHUNK_LOG
Post by: helpme on April 16, 2009, 08:30:48 AM

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

what do I do?

Title: Re: duplicate key in PK_CHUNK_LOG
Post by: ecki on April 16, 2009, 10:21:54 AM

Hi Helpyou,

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

Cheers,

e.

Title: Re: duplicate key in PK_CHUNK_LOG
Post by: ecki on April 16, 2009, 10:44:18 AM

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.