If you are unable to create a new account, please email support@bspsoftware.com

 

How do I stop hourly created record of documentContent class.

Started by richard.johnson5, 15 Jun 2021 05:21:11 PM

Previous topic - Next topic

richard.johnson5

We are running Cognos 10.2.2.  We keep running out of space in our content store.  Our content store records and db size consumption are continuously increasing from scheduled report jobs (or something).  We have cleanup jobs that remove stored reports older than 14 days and we don't allow the user to save more that two historical records (we have a cleanup job that takes care of that.).  In our analysis, we noticed that a report object is created in the  CMOBJECTS table that is a documentContent every hour at a size of 49.XX MB.  This continues to accumulate and these records are never deleted.  This takes up a lot of space.  Additionally, these records did not start occurring until Sep 2020.  In previous years, these records were not produced.  These records are not produced in our Test environment.  So, here are my questions:

What purpose do these records serve? This seems to be (from my research) properties of the report. I don't know how (or if) this is used in the portal by the user.
How do I stop (or can I) this from being saved to the db?
How do I safely delete these records from the table (or can I)?

dougp

I don't know what you mean by documentContent -- the CMCLASSES value or the SDK object -- but I would hope they mean the same thing.

I found https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=classes-documentcontent (but none for 10.2.2).  It looks like it's bunch of data (recipients, first page of the report, images needed by the report, etc.) related to a burst.  So I'd guess it's being produced by a schedule somewhere in your system.

I don't see anything with CMCLASSES.NAME = 'documentContent' in my Content Store, so I can't be sure.  Plus I don't do much bursting.

richard.johnson5

Yes it does seem to be something that is somehow scheduled, but I don't know how to figure out where this is scheduled so that I can modify it.  And, I don't know what a burst is.  This just started showing up last September 2020.  Between 2013 and September 2020, this 50.xx record was not created.  It would be great if someone could tell me where to look, so that I can stop this thing from being generated.

dougp

This query will locate schedules.  You could modify this to look for documentContent objects.  I don't have any documentContent objects, so I can't test.  Looking from a top-down perspective, you may need to go through one of the CMREF* tables to make the final connection to the documentContent.

(except that I can't paste SQL or upload attachments)

Try this:  https://raw.githubusercontent.com/dougpulse/Cognos/master/ContentStore/LocateSchedules.sql