Skip to Content

reg : Records getting merged up after activation ods activation.

Hello Gurus,

I need a help regarding an issue with the DSO activation, when I see the 3 rows of records in the new table in dso

before activation for a particular document number and item number

after the activation I see only one row the data is getting merged up. I am unable to know where the problem exactly is

Could you please throw some light on this issue.

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 Nov 28, 2011 at 07:10 AM

    Hi

    Check the key fields of your DSO.

    Upon activation, data will store in active table based on key fields of DSO.

    If your DSO key fields have doc number and item number, then this should not happen.

    are you facing this daily or only first tine?

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2011 at 07:20 AM

    Hi Harsha,

    Records are merging because of Keyfields selection.

    If you are making your DSO based on any Standard table then whatever field is in primary key this should be in keyfield of dso then you will not get this merging issue. Check your Keyfields again and add other fields if any.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2011 at 06:02 AM

    Hi Harsha,

    Looks unusual but you can check few things,

    1) After activation check that new data table is empty. Sometime due to failed activation it may hold old data and then if you do one more load you might see multiple records.

    2) Check the value of primary key for all the records in New table, after activation they might be getting aggregated or overwritten.

    3) And finally is this happening for first time or does it happens regularly?

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 11, 2011 at 05:55 AM

    Thank you all

    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.