topic Re: ISAM error: record is locked. - How do I skip locked records ? in Talend Studio

ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Sat, 16 Nov 2024 12:59:12 GMT

I am running a job. reading data from database and writing it to dataware database using Talend. I get an error saying record is locked. How Do I skip records that are locked in database and continue with next records?

Re: ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Tue, 12 Apr 2011 08:57:15 GMT

Hi
Does the error occur on input component or output component? Please show us the whole error message.
Best regards
Shong

Re: ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Tue, 12 Apr 2011 16:10:44 GMT

it happens on Input componant. when it is reading data from a table.

Re: ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Tue, 12 Apr 2011 16:22:50 GMT

which database sys?
according to the transactional isolation level, database must guarantee transactional consistency so they can't just "skip", at least they can return an "old" consistent version of the rows being locked.
check the transaction isolation of your read statements.

Re: ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Tue, 12 Apr 2011 19:51:53 GMT

I usally put set isolation dirty read at beginging of select statement. But Talend doesn't allow that. Can you tell me how to transaction isoalation of select statement?

Re: ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Tue, 12 Apr 2011 19:53:10 GMT

Thanks emaxt6.
Informix.

Re: ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Wed, 13 Apr 2011 07:34:35 GMT

I usally put set isolation dirty read at beginging of select statement. But Talend doesn't allow that. Can you tell me how to transaction isoalation of select statement?

Using a tInformixConnection to create a db connection, and then write your set isolation dirty query on tInformixRow component, the job looks like:
tInformixConnection
|
onsubjobok
|
tInformixRow
|
onsubjobok
|
tInformixInput---main-->tLogRow
|
onsubjobok
|
tInformixCommit
Both tInformixRow and tInformixInput use the an existing connection created by tInformixConnection .
Best regards
Shong

Re: ISAM error: record is locked. - How do I skip locked records ?

Anonymous — Wed, 13 Apr 2011 18:16:33 GMT

Thank You Shong. So should I have set isolation dirty read on tInformixRow and then have select statement query on tInformixInput componant?

Re: ISAM error: record is locked. - How do I skip locked records ?

_AnonymousUser — Fri, 03 Jun 2011 20:48:58 GMT

I run my job and in the output file no of records is not equal to the input file records neither does it show up in rejects.
Kindly suggest.