Reset Linkend Sequence script

Th Reset Linkend Sequence script is needed for SDL Contenta customers who use Link Manager, and for all SDL Contenta S1000D customers - whether or not they use Link Manager.

A fix was made to the Portal to resolve an issue with linkends during checkin. There is also a potential need to reset the linkend sequence (which generates the unique ID to identify the uniqueness of the links). Over a period of time, the many, various operations performed on a database generate gaps between the link IDs that result in a very high sequence number that can eventually run over the 32-bit long value limit (2147483647). A new script, ResetLinkendSequence.pl, was created to check the sequence number and fix it if necessary.

SDL recommends that the Reset Linkend Sequence script be run quarterly in verify mode to check the current sequence value and determine if the sequence number should be reset. The -verify switch is specified to display the current sequence value and warning level and does not make any change to the database. The details on how to execute the script are provided below.

The following script should be executed on a quarterly basis to determine if the linkends sequence number needs to be reset. If the sequence number does need to be reset, you should back up your database, then execute the script again without the -verify switch.

Contenta_home/bin/ResetLinkendSequence.pl -dbase db_name
-pdmpwd passwd -verify

where:

  • Contenta_home is the path where the SDL Contenta software is installed.
  • db_name is the name of the SDL Contenta database including either the SID or ODBC DSN if not specified under Registry on Windows or as an environment variable on Windows/Linux.
  • passwd is the SDL Contenta Oracle database password. The -pdmpwd switch is optional if you use the default password, pdmuser. The -pdmpwd switch is required if you do not use the default password or if you use LDAP. See Lightweight Directory Access Protocol (LDAP).