Bypass error SQL

[Former Member]

I,

My scenorio is FILE--> JDBC,

If I have 4 messages from my File, and my 2nd messages fall in error, I would like my last message reach the database.

I have used the multi mapping process to isolate all my messages, but when one of my message failed the status is WAITING and my other messages are HOLDING.

Here is the parameters of my JDBC :

Processing

Maximum Concurrency : 5

Persistence : Local

Concfilt Resolution : Redo

Advanced

Number of Retried of Database Transcation on SQL Error : 2

Transaction Isolation Level : : read_commited

Disconnect from Database After Processing Each Message : TRUE

Do I missed something ?

Regards

[Shabarish_Nair · Accepted solution]

in interface determination, remove the checkbox maintain order during runtime and try.

[prateek]

Do you have EOIO set as your QOS? What is your receiver side structure.

If I remember it correctly, you have raised some similar issue regarding commit and rollback. Any updates on it?

Regards,

Prateek

[Former Member]

You solved my problem guys.

Thanks

Regarding my other post, it has been solved as well thanks to that checkbox. (it was the same post but written down differently).

Regards

[former_member206760]

Dear Joseph,

How did u solve this one ?

Did multimapping + removal of maintain order at runtime work ?

[Former Member]

With two things :

1. The multi mapping which split the message into multiple messages

2. the checkbox Maintain Order At Runtime that I should uncheck to allow message treatment randomly (more or less)

Regards

[former_member206760]

1. As u have already suggested , use target message with 0...unbounded as the occurence in combination with the suggestion of sabarish "remove maintain order at runtime ".

2. if this doe snot work....BPM would surely work .

use a transformation step and inside that give the multi mapping that you created in step1.

then use a block step in PAR FOR EACH mode and inside that use a async send step which

will send each of the message generated by the transformation step to the database table

Giving points is another way to say thanks