Skip to Content

SAP Data Services Job running slow


Recently our SAP bods batch job have been running slowly, from 1-2 hours to 12 hours. No change in table configuration,No disk space outage, No OOM, No errors, no reboots. Data source is OLFM and target is HANA.

After 11 hours the job failed and restarted.

(14.2) 12-06-17 13:41:55 (E) (11989:537925376) DBS-070401: Dataflow DF_Init_OLFM_XLA_XLA_AE_LINES|XLA_AE_LINES ODBC data source error message for operation : <[SAP AG][LIBODBCHDB SO][HDBODBC] General error;129 transaction rolled back by an internal error: Allocation failed ; $size$=40000; $name$=; $type$=pool; $inuse_count$=1726511; $allocated_size$=1226819927>. (14.2) 12-06-17 13:59:40 (E) (11941:2113906464) RUN-050316: |Session Job_Init_XLA_XLA_AE_LINES Job failed (14.2) 12-06-17 13:59:40 (E) (11941:2113906464) RUN-050304: |Session Job_Init_XLA_XLA_AE_LINES Function call failed, due to error <50316>: . (14.2) 12-06-17 13:59:40 (E) (11941:2113906464) RUN-050316: |Session Job_Init_XLA_XLA_AE_LINES Job failed.

Kindly let us know your thoughts. Dirk Venken Werner Daehn

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2017 at 02:35 PM

    Hi Ravi,

    we had faced similar issue, when back tracked issue was with the target system ( HANA ) where in there was an dead lock applied on the table which our job was dumping the data, so lock was released. This resolved our issue.

    Track down all the source\Target as well as BODS bottle neck's to over come this long running issue.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sashi,

      Thanks for the response. But we didn't find any deadlock on the target table. When we tried to do the same thing using snowflake instead of HANA the jobs are still running the same way. The source is OLFM. Any advice or suggestions will be really appreciated.


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.