Skip to Content
avatar image
Former Member

Enhancement - CONTENT report - add queries for PlatofrmSearch Surrogate files

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'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 06, 2017 at 04:12 PM

    Thanks Rob. We will add this for the next version

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 22, 2017 at 11:23 PM

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

    Add comment
    10|10000 characters needed characters exceeded