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--