Aligning your namespace in the Content Data Store

The Content Delivery Content Data Store for SDL Tridion Docs must define a namespace with an ID of 2. If, for whatever reason, your Content Data Store has a different ID, run a SQL script to correct hits problem.

Procedure

  1. Run the following SQL script command on your Content Data Store to find out the current ID, as defined in your NAMESPACE table:
    SELECT * FROM NAMESPACE WHERE PREFIX='ish'
  2. If the value returned by the SQL script is not 2, access your SDL Tridion Docs installation media and navigate to the folder Database\scripts\DBTYPE\upgrade\1011_1100\, where DBTYPE is either oracle or mssql, depending on the type of database you are using.
  3. From this folder, run the SQL script called TCD_ALIGN_NAMESPACE.sql to set the ID to 2.