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

ODS Activation fails with memory error

Help!!!

Guru's, I have extracted payroll transaction data (0HR_PY_1) from R3 (117million records), loaded this data to the PSA, and loaded from the PSA to the ODS. When I attempt to activate data in ODS I get the following error message:

TSV_TNEW_PAGE_ALLOC_FAILED.

Anybody have any hints/tips to get this data activated?

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 17, 2007 at 09:23 PM

    Check if you have start routine coded...and using lot of internal table memory space..

    You can check with your BASIS on increasing memory...and tablespace..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 17, 2007 at 09:33 PM

    Hi...talk to your baisis guys about increase memory in the server...

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 17, 2007 at 09:24 PM

    Rather than trying to load everything at once, can you "divide" the data by periods or organizations... Let's say, try to load in "packages" of two months, or by company code...

    117 million records is a LOT to activate at once in an ODS... For sure... How long did it take to load to the PSA?

    Regards,

    Luis

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 17, 2007 at 09:26 PM

    Schedule a background job by keeping the activation in a process chain.

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 17, 2007 at 09:28 PM

    R3 extraction took 109 hours. Expected activation for ODS to take 17.5 hours.

    This is an initiliation for the payroll delta process, and is in a process chain.

    I have contacted by Basis team and they have opened an OSS with SAP for this issue.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 03:33 PM

    Thanks for all the help folks.

    Our Basis team opened an OSS with SAP. SAP has recommended that we run this process with 'Emergency' parameters. This is what we will be doing this evening. Wish me luck.

    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.