DSXchange

Posted: **Mon Mar 15, 2010 7:59 am**

Hi,

I am receiving the error below whilst using an Oracle Key generator in a surrogate key stage. The source_type in the stage is Database Sequence.

we have been using the same method without this warning for months, but I have created a new job and it is now appearing. Has anyone come across this kind of error before, and if so, how did you resolve it?

Code: Select all

main_program: Operator "parallel APT_DBKeyGenerator in sk_Generate_Surrogate_Key" is not wave aware; the operator will be reset and rerun on each wave if multiple waves present. This may lead to incorrect results and memory issues. Update the operator to make it wave aware and calls setWaveAware() in describeOperator() to inform the framework that the operator knows how to handle waves.

I can see there is an existing issue (logged and closed) with IBM but I run the surrogate key generator in another job in a different folder (in the same project) and it doesn't get the error!!

IBM APAR
http://www-01.ibm.com/support/docview.w ... wg1JR30200

Thanks,

Daren

Posted: **Mon Mar 15, 2010 8:19 am**

In addition to the above, it seems this error is caused because I have added an ODBC Connection stage to read our Cross Reference table. I say that because, when I replace it with a row gen stage, the warning disappears...

I have tried setting the wave variables in the ODBC connection stage but it still doesn't work.

Daren

Posted: **Mon Mar 15, 2010 8:53 am**

What exact 8.x version / patch level of DataStage are you running?

Posted: **Mon Mar 15, 2010 9:20 am**

It's v8.0.1 - I suspect it's because of a missing patch, so have emailed the relevant persons. I'm unsure of our patch level to be honest.

Thanks for your reply, I will update when I have an update

Daren

Posted: **Mon Mar 15, 2010 9:25 am**

You really should get yourself up on the latest 8.1.x release at your earliest oppurtunity. Perhaps this is it?

Posted: **Mon Mar 15, 2010 9:55 am**

I know, I believe we are waiting on supoort personnel becoming available.

Thanks for taking the time to reply. I'll mark this as resolved for now

Daren

DSXchange

APT_DBKeyGenerator is not wave aware

APT_DBKeyGenerator is not wave aware