This topic explains how to locate and unlock page previews.

In the Query Analyzer on the GN4 SQL server, on the GN4 database, run the following query.

If there are locked page previews, it will build the string to unlock them, e.g. srv4 unlock ids1,ids2 etc. You can then copy the string and execute it in an Administrator Command Prompt window on a GN4 IIS server, in the C:\TERA\GN4\BIN folder.

If there are no locked page previews, it will display the string There are no pagePreviews to unlock.

DECLARE @str VARCHAR(8000) SET @str = ''

DECLARE @lockCount integer

select @lockCount = count(*) from gn_CheckOutTable where gn_objectid in (select s_id from s_pagepreviewtable)

 

IF @lockCount>0

BEGIN

  SELECT @str = @str + cast(gn_objectid as varchar) + ',' FROM gn_CheckOutTable where gn_objectid in (select s_id from s_PagepreviewTable)

  SELECT 'srv4 unlock ' + LEFT(@str , LEN(@str ) - 1)

END

ELSE

SELECT 'There are no pagePreviews to unlock'

 

The above query can easily be adapted to unlock any other locked object.