How To Reset Ticket Numbers

To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.

Overview

This article provides instructions to reset ticket numbers.

Steps

1. First do an extract of the Key_Contol (kc) table to a file.

                    'c:\> pdm_extract Key_Control > key_control_tbl.txt'

2. Open the newly created file and change the key_value field to a value we want and save.

3. Run the command

                   pdm_cache_refresh -t Key_Control

4. Recycle USD

5. Load the updated data.

                     c:\>pdm_userload -u –f key_control_tbl.txt -v

6. Check it by creating a new ticket

Warning

If you reset the value to a very low number, you might get duplicates when searching for tickets. Idearly you would want to first archive the old tickets before re-using the numbers all over.