Skip to Content
0

Enhancement - CONTENT report - add queries for PlatofrmSearch Surrogate files

Aug 30, 2017 at 01:09 PM

40

avatar image
Former Member

Sometimes we see PlatformSearch backlogs.

Sometimes in certain older versions, we can see the CMS DB grow due to a bug with NOT deleting the Surrogate files.

something similar to:

SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE

SI_KIND = 'PlatformSearchContentSurrogate'

(I can't seem to find them using SI_KIND - might be a bug)

or this works:

select * from ci_systemobjects where si_name like '%Surrogate%'

(but, soemhow filter out the results for Deployment files/DFOs)

or use this:

select COUNT (SI_ID) from ci_systemobjects where SI_NAME = 'CrystalEnterprise.PlatformSearchContentSurrogate'

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Toby Johnston
Sep 06, 2017 at 04:12 PM
0

Thanks Rob. We will add this for the next version

Share
10 |10000 characters needed characters left characters exceeded
James Zhang
Sep 22, 2017 at 11:23 PM
0

Hey Rob, there will be an alert added for the upcoming 2.1 release in hopes to make customers aware of this bug. Getting the actual count could be tricky as that could timeout (as per Leslie).

Share
10 |10000 characters needed characters left characters exceeded