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!
Surrogate Key Generator - Database Sequence (Oracle) Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
Surrogate Key Generator - Database Sequence (Oracle) Error
Last edited by datastagenewbie on Tue Nov 19, 2013 10:17 pm, edited 1 time in total.
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?
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?
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am