Page 1 of 1
Surrogate Key Generator - Database Sequence (Oracle) Error
Posted: Tue Nov 19, 2013 8:15 pm
by datastagenewbie
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!
Posted: Tue Nov 19, 2013 9:26 pm
by chulett
So... not a Server job then. Off you go to the PX forum.
Posted: Wed Nov 20, 2013 10:31 am
by asorrell
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?
Posted: Wed Nov 20, 2013 12:21 pm
by datastagenewbie
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.