Lookup aborting after few minutes

chitravallivenkat · Post by **chitravallivenkat** » Tue Jul 28, 2009 4:58 pm

Hi,

I have one lookup having one OLEDB stage and one Hash file stage. the function of this job is just extract the data from SQL database and create the hash file with the data.

The job is connecting and reading the data. After few minutes, the job aborts by itself, throwing the below error at any one of the link.

Warning: GSAP_LOOKUP_CreateLkpForFormatJobs..HashLookups.IDENT1: Failed to read the row.

Warning:
GSAP_LOOKUP_CreateLkpForFormatJobs..HashLookups.IDENT1: OLE DB provider error HRESULT=0x80004005.

Warning:
Attempting to Cleanup after ABORT raised in stage GSAP_LOOKUP_CreateLkpForFormatJobs..HashLookups.IDENT1

Fatal:
GSAP_LOOKUP_CreateLkpForFormatJobs..HashLookups.IDENT1: |-100|

Could anyone please give the solution for this?

Regards,
Venkat

chulett · Post by **chulett** » Tue Jul 28, 2009 6:53 pm

Please don't start multiple posts on the same subject. Why not stick with your original post on the problem?

viewtopic.php?p=335270

chitravallivenkat · Post by **chitravallivenkat** » Wed Jul 29, 2009 6:20 am

chulett wrote: Please don't start multiple posts on the same subject. Why not stick with your original post on the problem?

viewtopic.php?p=335270

Sorry Chulet. I thought the previous one does not give clear idea on problem.

chulett · Post by **chulett** » Wed Jul 29, 2009 6:34 am

Then make it clearer... over there.