How to reset sequence number start value to 0?

追蹤

vd

• 2020年10月19日 18:18

Hi, I have a sequence number field that gets auto incremented by 1 each time a new form is submitted.  Prior to implementing the agile point application into a production environment, I would like to reset the field the number to 0 (it is currently at 315!).  Is there a way to do this other than recreating a new sequence number field?  I am trying to avoid creating another field since this field is referenced in about 15 other forms.  

Thank you!

0

• 

  AgilePoint NX Support

  • 2020年10月20日 04:26

  Hi Valerie,

  Currently, is the AgilePoint application is in Development Environment?

  If yes, moving the application to the production environment will auto-reset it to "1" without doing any changes in the eForm, Believing that both Dev & Prd Databases are different.

  Thanks

  0

  評論操作 永久連結
• 

  Aravind Rajanna

  • 2020年10月22日 05:12

  Hi Valerie,

  We understand that you have a sequence number control implemented inside your eForm and while in development phase there are around 315 sequence number has got generated and you want it to be reset before moving it to production environment. Assuming that your production and development environment are different , whenever you migrate your app from development to production there is no need to reset the sequence number going since you are deploying the app newly in a fresh environment any new sequence number which gets generated in production environment it would start from 0. So there is no explicit reset required.

  If you still have a requirement to reset the sequence number you can do it directly at the database level using below query:
  https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-sequence-transact-sql?view=sql-server-ver15

  SELECT * FROM sys. Sequences ALTER SEQUENCE [Sequence Number Column Name] RESTART WITH 000

  Sequence Number Column Name – Format of this would be [Process Model Name_Field Internal Name]

  Note : Resetting of sequence number is not at all recommended action once you go live. If even by mistake if you reset the sequence number all your new request start to fail because of reset sequence number start from beginning and form submit primary key violation might fail. So take decision wisely on resetting sequence number and try this first on your development or staging environment.

  Thanks

  0

  評論操作 永久連結
• 

  vd

  • 2020年10月30日 14:03

  Hi, thank you for the response!  The number did reset once we moved into the new environment.  I have just posted another question though regarding how to only increment the number when the form is submitted.

  0

  評論操作 永久連結

請登入寫評論。