4 Replies Latest reply on Oct 27, 2009 7:26 PM by 1-A5CHD1

    Number Generator Duplicate

    Mike Yesesky

      I am having a problem with the sequential number generator inside of Enterprise PDM 2009.  We are using the generator to pull numbers for our ECN forms (engineering change notices). Each number follows the same format (ex: 0123-09) the 09 is for the year and the 123 is supposed to be pulled sequentially next would be 124, 125 etc. We use the template manager to create an individual folder, rename the document to the ECN # and place it in it own folder.  The problem we are having is every once in a while the number generator will duplicatea number that has already been used. Since we have must use unique names inside of our vault the generator will change the -09 to -092.  This will only happen once and then it will continue on in the correct order.  Could this be a connection error for the user?

       

      Thanks

        • Re: Number Generator Duplicate
          Jeff Sweeney

          I have a hard time believing it is a problem with the number generator, it is driven by SQL...that is a pretty tried and true technology.

           

          Is it possible you have several templates using the same counter? Could one of those counters have the setting "Disable standard serial number generation" in step 4 turned on? Maybe it is a template not used very often causing the problem?

            • Re: Number Generator Duplicate
              Kim Nguyen

              I've seen this kind of problem twice, each in a different vault.

               

              Case 1: Suddenly for no reason (?!) the number generator generates an old-existing number every time any user does Save As from within SolidWorks for Assembly/Part files.

              To "fix" the problem I had to do "Copy Paste" of files in the vault a few times to generate some more "old" serial numbers then suddenly the number generator starts generating correctly.


              Case 2: It still happens once in a while (mostly seen with MS Office files), when a user copies a file out of the vault, makes some modification and saves it back to the vault under a different name, the number generator sometimes does not generate a new value (even though in the data card, field "Document Number" is set to use "Serial Number").

               

              No templates are involved in any case.

               

              It's hard for me to believe too!!

              • Re: Number Generator Duplicate
                Mike Yesesky

                No, they have all happened using the same template and they do not have the Disable Serial Number Generation check box checked and this template is used every day.  We do have two templates using the same serial number but all of the duplication has happened on one template because the other is not used very often. 

                 

                 

                These excel files are being created inside of the vault, there is no saving outside of the vault or save as with a different name.

                 

                We have been able to look into the SQL server while the duplication is hapening and there are no errors or warnings.  The duplication will last for maybe 5 files (-09, -092, -093, -094) and then it will return to normal.