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

DSO partitioning - using SE14 - SAP note 742243

Hi Folks,

on an "old" DSO object (ODS object) partitioning was done using SE14 SAP note 742243. Now data activation fails with ORA-14400: inserted partition key does not map to any partition.

I checked SE14 and inserted new partition values in "new creation" and also did an activate and adjust of the table.

However, the activation still fails and I also do not see the "new" partions when viewing current status storage parameter.

So I assume the new partitions are not active.

How do I get them active? How do I trigger/force a table conversion?

Thanks for all help in advance,

Axel

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2013 at 07:32 AM

    For all that struggle with the same the solution is quite simple:

    If you look in se14 a bit around you will find an option forced conversion in the top menu under extras.

    Make sure you have the save data and background process set before executing a forced conversion.

    The conversion will run for a while depending how much data is in the table. At the time of the conversion no activations should happen as the active table will not be accessible in system (also not for reports).

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 28, 2013 at 08:25 PM

    Hi

    Did you check the DSO in RSRV? What you mean by "old" dso? Could you create a new one and transfer the data?

    hope it helps

    Martin

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      RSRV does not check data base table for DSO as far as I have seen it.

      "old" simply means it exists already and the partitioning is not completely new.

      As stated I added via SE14 new partitions but I do not see them "active" and I am looking for a way to get them active.

  • Posted on Aug 29, 2013 at 05:54 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2013 at 10:35 AM

    Anyone with an idea on that?

    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.