Difference between revisions of "How To Reset Ticket Numbers"
From SDU
Rajkumarrt (Talk | contribs) (→Steps) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
| + | [[Category:Change Orders]] | ||
| + | [[Category:How To]] | ||
| + | [[Category:Incidents]] | ||
| + | [[Category:Issues]] | ||
| + | [[Category:Problems]] | ||
| + | [[Category:r11]] | ||
| + | [[Category:Requests]] | ||
| + | {{Global Header}} | ||
| + | {{Global Announcement}} | ||
| + | |||
== Overview == | == Overview == | ||
This article provides instructions to reset ticket numbers. | This article provides instructions to reset ticket numbers. | ||
| Line 4: | Line 15: | ||
== Steps == | == Steps == | ||
| − | 1. First do an extract of the | + | 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 == | == 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. | 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. | ||
Latest revision as of 07:20, 1 June 2009
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.
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.
