Skip to Content
avatar image
Former Member

SAP BOE BI 4.2 SP4, Data Base CMS Table CMS_InfoObjects7 is TOO BIG

Hi,

I am having an issue after installing SAP BOE BI 4.2 SP4, the problem is that the InfoObjects7 table is too big (having more than 15 000 000 rows) and 20Gb for the CMS DB.

Anyone have the same problem ?

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 18, 2017 at 12:50 PM

    That is highly in-usual.
    How many objects is in your repository ?
    If this is brand new install and no pre-existing content present - try to re-initialize the CMS DB.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2017 at 07:07 PM

    The number of rows in cms_infoobjects7 will be approximately close to the sum total of rows in the CMS. Try the following query in AdminTools:

    select count(si_id) from ci_infoobjects,ci_appobjects,ci_systemobjects

    If the result of this query is significantly less than the size of cms_infoobjects7, then I think there is some corruption in the repository. A reposcan might fix it.

    If the results are close, then you've got a boatload of objects somewhere. Unfortunately the CMS Query syntax does not support GROUP BY, which makes debugging a little harder. I would first try a "select count(si_id)" from ci_infoobjects, ci_appobjects, and ci_systemobjects separately. That should reveal at least which virtual table is the problem. Once you have that, try 'select top 100000 si_id,si_kind from ... order by si_kind". Eyeballing the result should reveal the si_kind of the unwanted objects.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2017 at 01:53 PM

    Support SAP answered by this SAP Note: https://launchpad.support.sap.com/#/notes/0002500438

    but this does not minimise the size of DB CMS.

    If I do understand well, we need to wait for the next patch that will fix this issue. for new we should disable APS_search.

    Regards

    Add comment
    10|10000 characters needed characters exceeded