Forum Stats

  • 3,854,173 Users
  • 2,264,332 Discussions
  • 7,905,588 Comments

Discussions

Is it possible to know which soa server is processing the Instance

2»

Answers

  • AnatoliAtanasov
    AnatoliAtanasov Member Posts: 883 Silver Trophy
    edited Oct 21, 2016 5:39AM

    Hi there,

    I think you should be able to run that query with ECID as where clause parameter. You would need to examine the COMPOSITE_* and CUBE_* tables thoroughly. It is actually quite easy to establish the logical connections/relations between the tables, though explicit foreign keys are missing. AFAIR ECID is used across the most important tables or at least you are able to such joins to reach the desired data based on the parameters you are interested in.

    Actually, just checked  - in the CUBE_INSTANCE you have ECID column.

    HTH,

    A.

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,777 Bronze Crown
    edited Oct 21, 2016 8:00AM

    Hi Anatoli,

    Yes, you're right, I agree. Especially when you need this more often. I think this use case is not a school-example for using a spring component.

    However, I haven't created an xpath function for SOA yet. I did for OSB. Should not be that hard, but this was simpeler, easier to deploy.

    And actually I'm still curious why you want to know which server executed (a certain piece of) the flow. I can only think of finding logs in the server.logs. But could do that via EM log search.

    Regards,
    Martien

This discussion has been closed.