Question Re: Data loading hanging for infinite time in Technology Q&A https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049334#M2872467 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>We had tried these steps. We can't even load one day's data beyond a certain period (032008). </P><P></P><P></P><P>Regards,</P><P></P><P>Suneer</P></BODY></HTML> Thu, 07 Jul 2011 16:16:49 GMT Former Member 2011-07-07T16:16:49Z Data loading hanging for infinite time https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaq-p/8049330 <HTML><HEAD></HEAD><BODY><P>We have a sales cube (which sources all three data sources - orders, billing and delivery). We created a copy of the sales cube, without mapping the calweek into the copy cube.</P><P></P><P>The reason we removed the Calweek from the copy cube is that, it was showing inconsistency in RSRV check, since the calweek was not having proper data from the source, as per the calday.</P><P></P><P>Whether due to this or not, when we try to load data from the actual cube to copy cube, it hangs forcing us to kill the job in SM37. Experts, please advise.</P><P></P><P>Thank you and regards,</P><P></P><P>Suneer</P></BODY></HTML> Thu, 07 Jul 2011 10:49:23 GMT https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaq-p/8049330 Former Member 2011-07-07T10:49:23Z Re: Data loading hanging for infinite time https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049331#M2872464 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>That should not be the issue. Is it happening again and again?</P></BODY></HTML> Thu, 07 Jul 2011 11:12:51 GMT https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049331#M2872464 Former Member 2011-07-07T11:12:51Z Re: Data loading hanging for infinite time https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049332#M2872465 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>go through this thread and identify how relevant it is for you ... </P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="385091"></A></P></BODY></HTML> Thu, 07 Jul 2011 11:16:42 GMT https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049332#M2872465 Former Member 2011-07-07T11:16:42Z Re: Data loading hanging for infinite time https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049333#M2872466 <HTML><HEAD></HEAD><BODY><P>Hi Suneer,</P><P></P><P>I think this is due to huge number of records.......</P><P>How many years of data are there in the actual cube ?</P><P>Try to split the selection..........like Year wise...........first go with this........</P><P>If then also it is getting stuck........trhen split month wise........like load data for 6 months.......</P><P>You can do the loading in parallel..........but first try 2 loads in parallel.........then 3............do some trial and error.......</P><P></P><P>Regards,</P><P>Debjani......</P></BODY></HTML> Thu, 07 Jul 2011 13:31:46 GMT https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049333#M2872466 Former Member 2011-07-07T13:31:46Z Re: Data loading hanging for infinite time https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049334#M2872467 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>We had tried these steps. We can't even load one day's data beyond a certain period (032008). </P><P></P><P></P><P>Regards,</P><P></P><P>Suneer</P></BODY></HTML> Thu, 07 Jul 2011 16:16:49 GMT https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049334#M2872467 Former Member 2011-07-07T16:16:49Z Re: Data loading hanging for infinite time https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049335#M2872468 <HTML><HEAD></HEAD><BODY><P>When you say that the data load is hanging - is the job still active ..?</P><P></P><P>If the job is still active - you can find out the SQL it is trying to execute and see where it is getting stck - for this it is best to defer to your BASIS DBA who can find out the SQL query it i executing and then see what the issue could be.</P><P></P><P>Also if you have specific selections on the data load - try creating indices on these fields...</P></BODY></HTML> Thu, 07 Jul 2011 16:30:05 GMT https://community.sap.com/t5/technology-q-a/data-loading-hanging-for-infinite-time/qaa-p/8049335#M2872468 Former Member 2011-07-07T16:30:05Z