Surrogate Key Generator - Database Sequence (Oracle) Error

datastagenewbie · Post by **datastagenewbie** » Tue Nov 19, 2013 8:15 pm

Hi I am getting this following error when I use the Surrogate Key Generator , Database option using Oracle DB sequence. I used Decimal, Number, Integer, BigInt datatypes, but nothing helped.
APT_CombinedOperatorController,0: Sequence <<SequenceName>> returned invalid next value: 1387369372.

Please advise.

Thanks!

chulett · Post by **chulett** » Tue Nov 19, 2013 9:26 pm

So... not a Server job then. Off you go to the PX forum.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Nov 20, 2013 10:31 am

Per the documentation: Generated keys are unsigned 64-bit integers. That should support numbers up to 18,446,744,073,709,551,615. So the error message is a bit puzzling.

Just to verify - can you put in $APT_DISABLE_COMBINATION (set to True) in your job and re-run? That should define the error message down to a specific component.

Have you verified that the problem isn't the key definition in the Oracle database that's generating it?

datastagenewbie · Post by **datastagenewbie** » Wed Nov 20, 2013 12:21 pm

I tried $APT_DISABLE_COMBINATION (set to True) in the job and re-ran . It gave the same error.

The Oracle sequence is working fine in the database.