SQL Queries - Common SQL Queries - How to check the consistency on the next value to be allocated on local database for an Id

This page provides the Queries to check the consistency on the next value to be allocated on local database for an Id.

On the CENTRAL database execute the following query (maximum value of the ids on the central corresponding to the local):

SELECT   SITE_NAME      ,
         SITE_SERVER    ,
         SITE_USER      ,
         LOCAL_DSS_NAME ,
         MAX(SITE_OBJECT_ID) lastidfromLocal
FROM     DSS_TRANSLATION_TABLE tt
         JOIN DSS_SITES s
         ON       s.SITE_ID = tt.SITE_ID
GROUP BY SITE_NAME  ,
         SITE_SERVER,
         SITE_USER  ,
         LOCAL_DSS_NAME

Next, on the LOCAL database execute the following query (maximum values of the ids used on the local):

SELECT MAX(IdKey)
FROM   Keys

Finally make sure that the above two numbers are LESS than the value produced below on the LOCAL database:

SELECT nextval('IDKEY_GENERATOR')

 The following have not been validated, but may work for checking sequences on Oracle and SQL Server similar to above:

• On SqlServer :
  Select IntVal from Parms where Lib='Id'
• On Oracle
  select IDKEY_GENERATOR.nextval from dual