Follow

Grid Disappears when ProductionDocID added

Created by: Tod Ewasko
Created date:
Last Updated date:

Symptom:

The grid will show up blank if there are errors in the results returned.

Cause:

This can occur because two document group creations were running at the same time and have some objects in both document groups which is illegal in Summation Pro.

Resolution:

Run the following SQL Query, this will run over all your cases and look for overlapping document groups. This may take a long time to run.

This can only be used on 5.2.1 or 5.2.2. The query does not make any changes. Notify support of the results of this query and mention this article.

--Copy below this line--

use master 

declare @dbname nvarchar(max), @CaseSchema nvarchar(max), @PROC nvarchar(max), @ParmDefinition NVARCHAR(500);

DECLARE LookForBadDocGroups CURSOR FOR

select name, SUBSTRING(name, 6, 16-6) as CaseSchema From adg.ADG56.cmn_DatabaseList where Name <> 'ADG'

OPEN LookForBadDocGroups

FETCH NEXT FROM LookForBadDocGroups

INTO @dbname, @CaseSchema

WHILE @@FETCH_STATUS = 0

BEGIN

SET @ParmDefinition = N'@dbname nvarchar(50), @CaseSchema nvarchar(50)';

SET @PROC = 'IF Exists (select DocCollectionID FROM
'+@dbname+'.'+@CaseSchema+'.[cvg_ObjectsToDocCollections] where objectid
in (SELECT [ObjectID] FROM
'+@dbname+'.'+@CaseSchema+'.[cvg_ObjectsToDocCollections] group by
objectid having count(objectid) >1)) BEGIN Print @dbname + '' has
Objects in two or more Document Groups''; Select @dbname as
DatabaseName, DocCollectionName, DocCollectionID from
'+@dbname+'.'+@CaseSchema+'.cvg_DocCollections

where DocCollectionID in (select DocCollectionID FROM
'+@dbname+'.'+@CaseSchema+'.[cvg_ObjectsToDocCollections] where objectid
in (SELECT [ObjectID] FROM
'+@dbname+'.'+@CaseSchema+'.[cvg_ObjectsToDocCollections] group by
objectid having count(objectid) >1)); END ELSE Print @dbname + ''
Looks Good'';'

Exec sp_executesql @proc, @ParmDefinition, @dbname, @CaseSchema

Fetch Next from LookForBadDocGroups

INTO @dbname, @CaseSchema

END

close LookForBadDocGroups

deallocate LookForBadDocGroups

--End SQL--

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk