This documentation applies to the 8.1 version of Remedy IT Service Management Suite, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

Synchronizing form IDs to the destination server

An escalation that runs every day cleans up the records in the ID generator forms. Consequently, the ticket number generator form IDs may not get synced properly to the destination server if not all of the following parent forms had data in the final production run of the delta data migration.

Use one of the following methods for synchronizing form IDs to the destination server:

To synchronize form IDs to the destination server using dynamic select commands

You need to run the dynamic select command on the source DDM ( current production) server which gives you an automated SQL as output. You must then copy this automated SQL output and execute it on the DDM destination (new production) server.

In case you want to roll back, you dont need to do anything because source DDM ( current production) server is not changed. You can directly roll back and start using the current system.

  1.  Execute the following command on the source DDM ( current production) server. The result would be an automated SQL output.
    •  On Oracle server

      select 'update arschema  set nextid = ' || nextid || ' where name = "' || name || '"; '   from arschema where name IN ('CFG:BusTimeTagGenerator',
      'CFG:CFG PBB TicketNumGenerator','CFG:CFG ScriptTagNumGenerator',
      'CHG:CFG Ticket Num Generator','CTM:CFG PTTicket Num Generator',
      'CTM:CFG PeopleTagNumGenerator','HPD:CFG Ticket Num Generator',
      'PBM:CFG KDBTagNumGenerator','PBM:CFG KE TicketNumGenerator',
      'PBM:CFG PI TicketNumGenerator','SRD:CFG DefinitionNumGenerator',
      'SRD:Cart TicketNumGenerator','SRD:Package TicketNumGenerator',
      'SRM:CFG TicketNumGenerator','WOI:CFG TicketNumGenerator')
    • On SQL server

      select 'update arschema  set nextid = ' + convert(varchar(10),nextid) + ' where name = "' + name + '"; '   from arschema where name IN ('CFG:BusTimeTagGenerator',
      'CFG:CFG PBB TicketNumGenerator','CFG:CFG ScriptTagNumGenerator',
      'CHG:CFG Ticket Num Generator','CTM:CFG PTTicket Num Generator',
      'CTM:CFG PeopleTagNumGenerator','HPD:CFG Ticket Num Generator',
      'PBM:CFG KDBTagNumGenerator','PBM:CFG KE TicketNumGenerator',
      'PBM:CFG PI TicketNumGenerator','SRD:CFG DefinitionNumGenerator',
      'SRD:Cart TicketNumGenerator','SRD:Package TicketNumGenerator',
      'SRM:CFG TicketNumGenerator','WOI:CFG TicketNumGenerator')

       

  2. Copy the output to a text file.
  3. Find and replace double quotes to single quote.
  4. Execute the output on DDM destination (new production) server.

To synchronize form IDs to the destination server manually

  1. Using SQL, check the Next ID value for the following forms within the arschema database table on the source and destination databases. (The form name is stored within the Name column, and the Next IDis stored within the Nextid column.)
    • CFG:BusTimeTagGenerator
    • CFG:CFG PBB TicketNumGenerator
    • CFG:CFG ScriptTagNumGenerator
    • CHG:CFG Ticket Num Generator
    • CTM:CFG PTTicket Num Generator
    • CTM:CFG PeopleTagNumGenerator
    • HPD:CFG Ticket Num Generator
    • PBM:CFG KDBTagNumGenerator
    • PBM:CFG KE TicketNumGenerator
    • PBM:CFG PI TicketNumGenerator
    • SRD:CFG DefinitionNumGenerator
    • SRD:Cart TicketNumGenerator
    • SRD:Package TicketNumGenerator
    • SRM:CFG TicketNumGenerator
    • WOI:CFG TicketNumGenerator

      If you have the entire BMC Remedy IT Service Management Suite, use the following SQL query to display all appropriate Next IDs within a single query:

      select name, nextid from arschema where name IN ('CFG:BusTimeTagGenerator',
      'CFG:CFG PBB TicketNumGenerator','CFG:CFG ScriptTagNumGenerator',
      'CHG:CFG Ticket Num Generator','CTM:CFG PTTicket Num Generator',
      'CTM:CFG PeopleTagNumGenerator','HPD:CFG Ticket Num Generator',
      'PBM:CFG KDBTagNumGenerator','PBM:CFG KE TicketNumGenerator',
      'PBM:CFG PI TicketNumGenerator','SRD:CFG DefinitionNumGenerator',
      'SRD:Cart TicketNumGenerator','SRD:Package TicketNumGenerator',
      'SRM:CFG TicketNumGenerator','WOI:CFG TicketNumGenerator')
  2. Ensure that the nextid value in the destination is equal to or greater than the source after the final Delta Data Migration run has completed. If the nextid value is not equal to or greater than the source, use an SQL UPDATE statement on the arschema table on the destinationserver. For example:

    UPDATE arschema SET nextid = ‘100000’ WHERE name = ‘CFG:BusTimeTagGenerator’;

    Note

    If you are using an Oracle database platform, you must execute a commit; command after you complete the SQL updates.

The following table lists the ticket number generator forms that are installed.

Form name

Parent form name

AAS:ConfigurationTicketNumGenerator  

AAS:Activity

AST:LC Ticket Num Generator

AST:LicenseCertificates

CFG:BusTimeTagGenerator

CTM:Support Group On-Call

CFG:CFG PBB TicketNumGenerator 

CFG:Broadcast

CFG:CFG ScriptTagNumGenerator

CFG:Scripts

CHG:CFG Ticket Num Generator

CHG:Infrastructure Change

CTM:CFG PTTicket Num Generator

CTM:People Template

CTM:CFG PeopleTagNumGenerator

CTM:People

HPD:CFG Ticket Num Generator

HPD:Help Desk

PBM:CFG KDBTagNumGenerator

PBM:Solution Database

PBM:CFG KE TicketNumGenerator

PBM:Known Error

PBM:CFG PI TicketNumGenerator

PBM:Problem Investigation

RMS:CFG Ticket Num Generator

RMS:Release

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments

  1. Michael Jakab

    Hi,

    for me the nextid changes were reflected only after a server restart. Can this be mentioned in the documentation as well?

    Thanks

    Michael

    Mar 20, 2014 04:58
  2. Hemant Baliwala

    Hi Michael, 

    Thanks for the comment. I working with SME to update the docs. 

    Hemant

    Mar 21, 2014 01:42