Skip to Content
avatar image
Former Member

Data load

Hi all;

what could be the reasons that data load gets timeout. One of my cube 0BWTC_C03, when I am loading data it's getting timeout. It's statistics cube. Pls let me know..what are reasons that would cause the problems.

thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    Jun 10, 2005 at 01:56 AM

    Hi Gandaki,

    Check if you have got any dumps in ST22..

    I also had a problem once when i had a never ending loop in my update rules..

    Let us know ..

    Ashish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Error Says "Warning: EM-Memory exhausted: Workprocess gets PRIV " - Because I think it might be, that process becomes somewhat big and allocates whole extended Memory for it leaving nothing for the rest of the workprocesses which then turn into priv mode.

      Please check the ST02 - maximum of the extended memory has been used, It will be 100% at the time the program is executed.

      and the Program seems to be ended with " COMMIT_IN_PERFORM_ON_COMMIT" as it has no memory to Roll in or Roll out, and other processes are also canceled with " TSV_TNEW_PAGE_ALLOC_FAILED" Run time error as No more storage space available with same error message as ""Warning: EM-Memory exhausted: Workprocess gets PRIV "

      Please go throw these 2 notes pasted below

      Note 750456 - ABAP dump MEMORY_GET_BLOCK_ADDRESS

      Note 958541 - Error in internal storage administration (PAGING)

      Increasing the SAP ztta/roll_extension Profile parameter value will help.

  • avatar image
    Former Member
    Jun 10, 2005 at 01:46 PM

    Seems like problems with tablespace..,,I don't know where to find it and solve this problems. any thoughts would highly appreciated with points.

    thanks/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 10, 2005 at 02:06 PM

    Hi Gandaki,

    You will get some information throuhg Tcodes: DB02 and DB20.

    And also search the topics(table space) in this forum u will get some more information.

    Srini

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      How do I find what is the tablespace name for that cube? It seems like that t-code will give me some data. thank you for the all the good information.

      Gandaki

  • avatar image
    Former Member
    Jun 10, 2005 at 02:10 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 10, 2005 at 02:56 PM

    I have one confusion though;;how come it was loading fine in developing and this happened in productions? This is the origina problems..this cube has never been used becuse of this problems..and now they want to make a use of it. I don't know what else could be the problems.

    Gandaki

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Error Says "Warning: EM-Memory exhausted: Workprocess gets PRIV " - Because I think it might be, that process becomes somewhat big and allocates whole extended Memory for it leaving nothing for the rest of the workprocesses which then turn into priv mode.

      Please check the ST02 - maximum of the extended memory has been used, It will be 100% at the time the program is executed.

      and the Program seems to be ended with " COMMIT_IN_PERFORM_ON_COMMIT" as it has no memory to Roll in or Roll out, and other processes are also canceled with " TSV_TNEW_PAGE_ALLOC_FAILED" Run time error as No more storage space available with same error message as ""Warning: EM-Memory exhausted: Workprocess gets PRIV "

      Please go throw these 2 notes pasted below

      Note 750456 - ABAP dump MEMORY_GET_BLOCK_ADDRESS

      Note 958541 - Error in internal storage administration (PAGING)

      Increasing the SAP ztta/roll_extension Profile parameter value will help.

  • avatar image
    Former Member
    Nov 22, 2005 at 11:08 AM

    Hans,

    Try the below options.

    1. Load the data in background/OR

    2. Writing an ABAP code in sources system and start the job for data load

    3. Check some settings - time out...bw side.

    regs,

    mahantesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 23, 2005 at 09:16 AM

    Hi Hans,

    I have come across this problem in production system.

    1.Reason for this error occurring in production and not in development systems: The main reason might be due to the volume of data. In development server you will have very low data volume and the testing would be done for this low volume. So there are chances that the load will fail or end up in short dump in production system where there are usually millions of records.

    2. Error analysis: Looking at the error message it is very clear that some internal table in the abap code is exceeding the memory limits . But this may be due to some endless loop within which the internal table is being populated in the ABAP code. So I suggest you go to the ABAP code and look for the code where this particular internal table is being populated.

    One more suggestion: If the load is through PSA, the best way to debug the update rules/ tranfer rules is to right click on one of the datapackage and select the "Simulate Update " option. Then use the option Debug Update Rules/ Debug Transfer Rules. This will take you to debug mode and you can execute step by step and watch the internal table.

    Hope this helps....

    Shilpa

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2011 at 07:28 PM

    hi

    incase you have not been able to solve this issue ... I hope the below input helps

    i faced the same problem , the data was loading correctly in the development system but in quality system it was giving error because the table space allocated is less than the data that is getting loaded .

    It is also clear from the explaination in ST22 mentioned earlier.

    The solution that i had implemented was changing the design itself, so that the table space allocated increases.

    Please check the abap code that you have written-

    1. It might be going into an endless loop.

    2. The code is multiplying the source data to an extent whicch is more than the table space alloccatedd tothe target.

    3. Check the logic once again.

    Add comment
    10|10000 characters needed characters exceeded