Skip to Content

SAP BODS /SAP data services deadlock. Can it occour ?

Hey guys,

We are connecting to different source system through sap BODS (SAP dataservices) with ODBC connector.

Can deadlock occur in the source system, or does BODS have somekind of built in solution to evade it ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 28, 2019 at 03:47 PM

    With database tools and while reading a deadlock can never occur. By definition. A deadlock is when two processes modify the same rows but in reverse order. Then one is waiting for the other. No modification, no deadlock.

    Hence we would need more input about the problem you are seeing.

    Add a comment
    10|10000 characters needed characters exceeded

    • In that case we need to be a bit careful with the terminologies. A deadlock really means two processes wait for the others to commit so they can modify a row.

      A select, in an ideal world, does neither impact other selects nor other processes writing. A select should never read the data as it is in the database now, it should return the consistent data at the time the select statement got issued. Otherwise it is not a database by the strong definition of the term but just a thing on top of files.

      Having said that, there are situations. In Oracle you might get an error "Snapshot too old, rollback segment too small". Records changed while the select executes are preserved in the rollback segment for the select to find the original past values there. Oracle obviously does not store the data there forever.

      Your database I have heart of but I am not familiar with these details. Hence I good question to ask.

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.