DSXchange

Out of curiosity, why is the main Sequence job multi-instance - are you running multiple copies of it as well? Unless someone has a better idea as to what might be going on, in your shoes I'd try adding a delay to two for the three Job Activity stages. Build a routine to sleep X seconds (it's just a...

Okay... that's almost word for word was is in the other post and you can see that really wasn't enough information for someone to be able to help. :? So this a single Sequence job that is somehow trying to run a multi-instance job more than once "in parallel" and that's failing? Can you be...

Rather than jump on an eight year old post, best to start a new one and give us the details of your version of the problem. Thanks.

So... support. They can help you work out the "why" of your issue, perhaps you are in need of a patch.

Why not contact your official support provider and get some help? You are clearly not seeing something that should be there.

Let us know what you find out!

Support time!

Right, start with that and see where the rest goes.

I'm no longer able to see your images where I could before... are they still on that hosting site? Have you involved your official support provider yet? And just to play Devil's Advocate, it probably isn't really "working fine" in your older version, all you know is that it just wasn't blo...

Looks like you had a spot of trouble with your "J" key...

Serious question - how does one access the database outside of DataStage? I'm guessing they support ODBC or JDBC access. And from a quick google it looks like they have both a Java and a REST-based API. So definitely possible!

parilango - If would be best if you started a new post with all of the details of your version of this issue, including the job design and actual error message.

Are those both strings in your job?

After SQL would typically mean it would only be called once unless the Wave Generator effects that? I assume so, hence the suggestion.

GSKit? Not something that's ever been posted here before, can you (or anyone else) elaborate a bit? Thanks.

Not really a "looping" scenario to me. In your shoes I would probably try splitting off to another link whatever you need to call the procedure and then use a MOD(counter, 1000) function on a count of the records to call it when the function returns 0, leveraging a filter or transformer. Y...