16 Replies Latest reply on May 4, 2017 1:01 PM by Shaun Toms

    ECN Serial Number

    Shaun Toms
    Shaun Toms Mar 28, 2017 10:35 AM

      So, we have our datacard and it pulls a ECN # based on the next serial number when someone does the New ECN command. No problem there and technically this isn't a huge problem, but I'm trying to figure out why it changed on me.

       

      As mentioned, when we do the New ECN command it pulls the serial number for the new ECN. Sometime between yesterday and a month ago, something must have changed, a setting or something that I haven't located. But what used to happen was, I would demonstrate the system by right clicking and selecting New ECN. Then I would just hit cancel so an ECN wasn't created. This had the added benefit that it would also not use up the next serial number and I could demo it all the time for everyone we were training on the ECN process.

       

      Yesterday though, I noticed that it is now incrementing the serial number even when I hit cancel instead of when it created the actual file. I'm trying to figure out what setting I changed or what I did to make this happen as it was pretty convenient the old way to just hit cancel when I was training someone new. Again, last training I did was beginning of the month and it worked as I originally described. Yesterday though it now seems to want to increment the serial number whether I press cancel or not.

       

      Thoughts?

      • 1957 Views
      • Categories: Enterprise PDM
      • Tags:
        • Re: ECN Serial Number
          Paul Wyndham
          Paul Wyndham Apr 7, 2017 2:02 PM (in response to Shaun Toms)

          At the moment when I use the menu to create a new part using a template that pulls a serial number it appears not to increment the serial number when I click cancel.

           

          Here are the settings from my Template:

           

           

           

          Here are my serial number settings:

           

           

          I don't see anything that stands out as looking like it would cause the serial number to increment. But maybe one of the checkboxes on the edit template file dialog could do it.

           

          It would be great if you posted back if you got it fixed just in case someone else runs into your issue. Good luck.

            • Re: ECN Serial Number
              Shaun Toms
              Shaun Toms Apr 24, 2017 11:58 AM (in response to Paul Wyndham)

              Ok, so I didn't want to post back right away because I wanted to keep playing around and testing. And the conclusion is, I have no conclusion. I'm still confused about the whole thing.

               

              So, I went back, double checked all my settings and permissions and everything checks out. Then I started testing it again.

               

              So, when I Right click and select New ECN, I get my Card which says my new filename will be ECN-3067. Which, If I check the serial number is the next number in line. I press Cancel, no file is created and I'm back to my Windows Explorer PDM window looking at my ECN folder contents.I check Serial number again and now it says the next number is 3068. HOWEVER, If I right click and select New ECN it opens my Card and shows the filename will be ECN-3067 still.

               

              So, I ran a series of tests to show what I'm seeing. It may look repetitive and like I'm just posting the same screenshot repeatedly but I assure you, each screen show is taken after each step I describe. And, it just doesn't make sense.

               

              So, here's the serial number

               

              ECN Card showing the filename with the serial number

               

              Press cancel and try again, same thing

               

              Press cancel and check serial number, but it shows it's advanced to 3068,

               

              Try it from another users login on a different computer,

               

              Try it from my computer again,

               

              And check serial number again,

               

              So, while it appears it's no longer advancing the serial number past the 1 step it shows it advance above. I'm curious why the serial number does not show 3067 as the next number even though on each computer and login I try it as it wants to create the file as 3067 even though the serial number shows 3068. Then I'm curious if at some point, if I leave the serial number showing as 3068, if someone eventually will get 3068 instead of 3067 at some point.

            • Re: ECN Serial Number
              Tim Webb
              Tim Webb Apr 7, 2017 2:50 PM (in response to Shaun Toms)

              Shaun,

              I've found that double increments happen when the template pulls a serial number AND the data card field for the new serial number default value is set to use a serial number.

               

              Here's the template variables:

              template serial number.png

              Here's my datacard field for "CO Number" NOTE: This setup WILL CAUSE duplicate numbers to be pulled. So, DO NOT set yours up this way LOL

              default value.png

              Dispatch can cause this as well.

              Hope this helps,

              Tim CEPA

              Believe in The Q!

              • Re: ECN Serial Number
                Tim Webb
                Tim Webb Apr 7, 2017 3:00 PM (in response to Shaun Toms)

                See this thread too Serial number does not increment by 1

                 

                This one had to do with assigning a serial number value as the default value on a folder card. That's another possibility.

                 

                Tim CEPA

                Believe in The Q!

                • Re: ECN Serial Number
                  Stavros Smith
                  Stavros Smith Apr 8, 2017 8:41 AM (in response to Shaun Toms)

                  Hello,

                   

                  I noticed this issue as well with our system.  In the beginning hitting cancel would actually not create the file, somewhere along the line this changed, and specific users would not be able to cancel, as the file would be created anyway.  This led us to having issues with our serial number, as EPDM registered that the command was 'Cancelled', so it would keep trying to use that same number (ECN-000275 [ECN cancelled by user]), but the admin tool would still indicate 'ECN-000276' as the next available number.  Until going into the serial number generator and overtyping the next available number, it would constantly create 'ECN-000275[0,1,2,3,4,...]'.

                   

                  I spoke to our VAR, its seems as though the Cancel button relies on the users rights, so this means the user needs to have delete and destroy rights for it to 'Cancel'.  I did not want to give everyone those rights, our VAR suggested setting the template settings to 'Read permissions from the following user:' and setting it to the admin account or some one with admin permissions.  This will allow the command to be cancelled without having to give the users delete/destroy rights.

                   

                  Kind regards,

                   

                  Stavros

                    • Re: ECN Serial Number
                      Tim Webb
                      Tim Webb Apr 10, 2017 10:59 AM (in response to Stavros Smith)

                      I learned something new today! So I'm going to investigate this and test it.

                      Tim CEPA

                      Believe in The Q!

                        • Re: ECN Serial Number
                          Stavros Smith
                          Stavros Smith Apr 20, 2017 2:08 PM (in response to Tim Webb)

                          Howdy Tim,

                           

                          Have you been able to recreate the problem?  If so, have you managed to find another solution?

                           

                          Stavros

                            • Re: ECN Serial Number
                              Tim Webb
                              Tim Webb Apr 20, 2017 3:29 PM (in response to Stavros Smith)

                              Yes Stavros, I have but I misunderstood when you typed

                              Until going into the serial number generator and overtyping the next available number, it would constantly create 'ECN-000275[0,1,2,3,4,...]'.

                              I thought you were saying your serial number counter would create files like ECN-0002750, ECN-0002751, ECN-0002752, ECN-0002753, ECN-0002754, ....etc. LOL Sorry, that's why I said I learned something new. I was thinking "Whoa! I didn't know PDM would add sub-serial numbers automatically if permissions were right!"

                               

                              When I run the template as Tom in engineering group without delete permissions, I get this error message when pressing cancel

                              1.png

                              And the file CR-00011.xml is created but can't be deleted by the template because the template is running under Tom's permissions.

                              2.png

                              But when I run the template as any user with delete permissions (such as the admin), pressing cancel doesn't increment the counter and does indeed delete the file that got created. I just ran my change request template and got CR-00011 for the document number and my admin tool counter shows CR-00012 as the next counter value. The file couldn't be deleted so now the numbers are wrong and we have an orphaned file that can't be used/checked in because they decided not to use it and it can't be deleted unless someone else with elevated permissions deletes it.

                              3.png

                               

                              So here's the deal.

                              1. You will need to set the admin to run the template or another user with elevated permissions for delete if you want to be able to cancel.
                              2. If you do this, make sure the permissions are set for that group so they can delete in the folder AND initial state where the template will drop that file.
                              3. You could also give user groups permissions in the state to delete and destroy since it's an initial state BUT make sure that state isn't one the files could transition through after they have been through a REV...don't want them deleting or destroying files with REVs.

                              I'm using SW PDM 2017 SP2.0

                               

                              Hope this helps,

                              Tim CEPA

                              Believe in The Q!