Possibility of update query to fail in MII

[Former Member]

Hi all,

I am new to MII and this forum so I am sorry if i am posting in the wrong thread.

I have a doubt regarding the MDO. I have an update MDO query which i am calling in a transaction.

I want to know if there is any chance for that update to fail due to any reason.

If so how can i find the success/failure status of that MDO.

Thanks for your help!

Sowjanya

[Former Member · Accepted solution]

I imagine MDO query action blocks behave the same as all other query action blocks.

So there will be a Success field and lastErrorMessage field on the action.

After executing the update put a condition value that maps 'QueryActionBlock.success' to 'Condition.input1'.

On the false side of the condition put a terminate transaction or tracer and map 'QueryActionBlock.lastErrorMessage' to the message of the tracer or terminate transaction.

[Former Member · Accepted solution]

So in short the query can fail right??

What could be the possible reasons for the update to fail?

[Former Member · Accepted solution]

I'm sure the folks at SAP make it so it doesn't fail 99.9% of the time but there is that 0.01% chance that something will hiccup and break. Some possibilities that could cause the update statement to fail.

  - Network outage that causes loss of connectivity to the database.

  - A bug in the MDO system.

- Poorly constructed update statements.

  - Power failures.

  - Acts of God.

  - Etc . . .

Some you can test for, some you can't.

[Former Member · Accepted solution]

Thanks Jasper!