what is the max value in key management next value

[deva]

HI ,
Please let me know what is the max value in key management next value in sdk function. (builtin functions),

when this sequence number will reset. what is the max value.

in which case this sequence number will reset.

Because of some times I am getting duplicate sequence number in my job.

Please advise me, I am using data stage 7.1 server

[kduke]

I am not sure what the maximum value is but I bet you are getting duplicates because your SDKSequeces hashed file is out of sync with the database. I think you should always reseed these values from the target database. I included a job to do this in EtlStats.

Select max(#jpColumnName#) from #jpTableName#;

So this code will work on any table and any database. The assumption is this is the primary key of the table so this is very fast to do for every table.

[DSguru2B]

That is one of the reasons I dont like to use SDKSequences. By doing a select max(id) from your table and incrementing it, you can never go wrong.
Never the less, you can reset its value. Search on "SDKSequences" to find out how to reset the value.

[G SHIVARANJANI]

wat does this error indicate if

32:52(000) <STG_AML_01,0> Delimiter for field "Change_status" not found; input: {U 0d}, at offset: 126
##W TOIX 000154 14:32:52(001) <STG_AML_01,0> Import warning at record 0.
##W TOIX 000018 14:32:52(002) <STG_AML_01,0> Import unsuccessful at record 0.
##W TOIX 000000 14:32:52(003) <STG_AML_01,0> Delimiter for field "Change_status" not found; input: {U 0d}, at offset: 146
##W TOIX 000154 14:32:52(004) <STG_AML_01,0> Import warning at record 1.
##W TOIX 000018 14:32:52(005) <STG_AML_01,0> Import unsuccessful at record 1.
##W TOIX 000000 14:32:52(006) <STG_AML_01,0> Delimiter for field "Change_status" not found; input: {U 0d}, at offset: 143
##W TOIX 000154 14:32:52(007) <STG_AML_01,0> Import warning at record 2.
##W TOIX 000018 14:32:52(008) <STG_AML_01,0> Import unsuccessful at record 2.
##W TOIX 000000 14:32:52(009) <STG_AML_01,0> Delimiter for field "Change_status" not found; input: {U 0d}, at offset: 124
##W TOIX 000154 14:32:52(010) <STG_AML_01,0> Import warning at record 3.
##W TOIX 000018 14:32:52(011) <STG_AML_01,0> Import unsuccessful at record 3.
##W TOIX 000000 14:32:52(012) <STG_AML_01,0> Delimiter for field "Change_status" not found; input: {U 0d}, at offset: 131
##W TOIX 000154 14:32:52(013) <STG_AML_01,0> Import warning at record 4.
##W TOIX 000018 14:32:52(014) <STG_AML_01,0> Import unsuccessful at record 4.
##I TOIX 000193 14:32:52(015) <STG_AML_01,0> No further reports will be generated from this partition until a successful import.
##I TOIX 000163 14:32:52(016) <STG_AML_01,0> Import complete; 0 records imported successfully, 6 rejected.

[ray.wurlod]

First it means you're in the wrong forum. This is a question about a parallel job.

Second it means that you've hijacked someone else's thread, with a totally unrelated question. That behaviour is severely frowned upon here.

Third, you don't seem to realize that a wat is a Buddhist temple.

Fourth, it suggests that you need to take a training class. The error message contains everything you need to deduce the cause.

On those bases, Shivaranjani's question will not be answered here. It needs to be posted as a new thread in the parallel jobs forum.

[G SHIVARANJANI]

sorry i am new to this ..