Skip to Content
author's profile photo Former Member
Former Member

Update to 5.1SP3: Column 'IndexDefrag' does not belong to table Application

Hi guys,

I just upgraded a SAP BPC server (single server instalaltion) from 5.0 SP2 to 5.1 SP3. Everything is working okay except for optimizing an application. When I optimize an application (full/incremental.light -with and without compress) I get the following error message:

Error message:Column 'IndexDefrag' does not belong to table Application.

This happens at the step Processing OLAP DB. The same happens with the AppShell and other application sets.

A process on the cubes itself (by using Analysis Services) is no problem.

Could somebody help me out?

Thanks!

Paul van Erk

CPMView Consulting BV

Your Corporate Performance Management partner

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 12:43 PM

    Paul,

    You didn't upgrade your admin client after upgrading. in the new admin console there is a new checkbox for index defragging. This error indicates that you have an old clientI. I've had the same issue in the past, after upgrading the client everything works well.

    Regards,

    -Joost

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      shame

      I did the upgrade of the client to 5.1 (after installing 5.1 on the server). After testing I upgraded the server to SP3, however I was so eager to test SP3 I forget to upgrade the admin client!

      Thanks Joost!

      Paul van Erk

      CPMView Consulting BV

      Your Corporate Performance Management partner

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 12:09 PM

    Paul,

    did you save all applications after the upgrade?

    If no; please save all applications with all selectionboxes switched "ON"

    if yes; I hope someone else can help you.

    Alwin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.