Skip to Content
avatar image
Former Member

Data does not save on MDR job

Hello,

When I run MDR job and if there is any error in one of the record, the other record values are not getting saved. Can you please help me how can I overcome this issue? I'm using query.Execute() method and updating the record values in the loop. Should I need to use ExecuteFromDB()?

Thanks.

Regards,

Mohan Babu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 02, 2016 at 02:50 AM

    Hi Mohan,

    MDRO executes the action and then save, which means if there is any error in the action execution, none of them would be saved.
    To solve your issue, either fix the errorneous record or enhance your query parameter to filter out such errorneous record.

    Thanks, Pradeep.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 08:32 AM

    Hello Mohan Babu,

    Why do you call a query manually in a MDRO? This makes the complete process nonsense. :-( :-( :-(

    A MDRO is defined UPON a query and for every query result the resp. action is called.
    There is no need for calling a query or an action manually. If you do so, you will lose all advatanges of the MDRO framework, like parallelism,...

    Bye,
    Horst

    PS: I need to write a blog on that. ;-)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Horst Schaude

      Hello Horst,

      I'm actually having a custom BO for all the tickets and then querying the data in action and updating the tickets.

      Regards,

      Mohan Babu

  • Nov 08, 2016 at 02:35 AM

    Hi Mohan Babu,

    In the loop when you modify, the changes are not yet saved, all the changes are saved at once, hence if there is any error everything gets rolled back.

    If you want to save for earch iteration in the loop, then you could execute webservice in the loop.

    Thanks, Pradeep.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Pradeep,

      Do I need to create custom web service or is there any standard web service that I can use?

      Thanks.

      Regards,

      Mohan Babu

  • Nov 12, 2016 at 09:49 AM

    Hi Mohan,

    You could search in the Repository explorer under Inbound service interfaces, if not found you could create one.

    Thanks, Pradeep.

    Add comment
    10|10000 characters needed characters exceeded