Hi,
We have jobs that use this function to generates keys for our reference table. Recently we have installed EE that replaces our SE. During this time we exported complete project and imported back to EE. Now when we are running the jobs involving this function, we have noticed it is starting from 1.
Does anybody know if, this migration caused reset?
In general, what else would cause this reset...for a given 'Sequence Name' ?
I have read several posts and updated the initial value of the sequence (in has file?) to max existing value in table.. as a solution.
For other.. who have similar problem.. here are couple of solutions that we can use:
viewtopic.php?t=92652
viewtopic.php?t=89726
KeyMgtGetNextValueConcurrent sequence number reset to 1
Moderators: chulett, rschirm, roy
When using the KeyMgt Utilities, all your key values are stored in a hash file call SDKSequences.
When you migrated this file did not get moved. The KeyMgt routines look for the KeyName in the SDKSequences file. When it doesnt find the name it creates it and starts at 1.
You can edit your current SDKSequences file to change the KeyValues to what ever you like or you might consider creating a simple DS Job that updates the SDKSequences file to the values you want.
Use a flat file that has a row for each of your keys and thier values as the source and the SDKSequences file is your target.
When you migrated this file did not get moved. The KeyMgt routines look for the KeyName in the SDKSequences file. When it doesnt find the name it creates it and starts at 1.
You can edit your current SDKSequences file to change the KeyValues to what ever you like or you might consider creating a simple DS Job that updates the SDKSequences file to the values you want.
Use a flat file that has a row for each of your keys and thier values as the source and the SDKSequences file is your target.
Lance Short
"infinite diversity in infinite combinations"
***
"The absence of evidence is not evidence of absence."
"infinite diversity in infinite combinations"
***
"The absence of evidence is not evidence of absence."
Thank you for that clarification.
Yeah. Thats what I have done. Just wanted to confirm that migration caused this. I thought complete project export/import would include SDKSequences as well. Thanks again!!lshort wrote: You can edit your current SDKSequences file to change the KeyValues to what ever you like or you might consider creating a simple DS Job that updates the SDKSequences file to the values you want.
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
ukyrvd wrote:Thank you for that clarification.
Yeah. Thats what I have done. Just wanted to confirm that migration caused this. I thought complete project export/import would include SDKSequences as well. Thanks again!!lshort wrote: You can edit your current SDKSequences file to change the KeyValues to what ever you like or you might consider creating a simple DS Job that updates the SDKSequences file to the values you want.
Complete Project import/Export doesn't backup your SDK sequences. You have to take a backup of it from the projects/ project name directory.
Now that you have already over written your SDK file, you have to set the sequences to start from a specified point or if you have a backup of the projects direcotry, you can just re-import them into the projects direcotry.
kab123,
the source of these programs is visible to you - open up the job in the Manager and you will see a section of code that checks if the file exists and if not, creates a type 2 hashed fille called SDKSequences in the local project directory.
the source of these programs is visible to you - open up the job in the Manager and you will see a section of code that checks if the file exists and if not, creates a type 2 hashed fille called SDKSequences in the local project directory.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>