Error while calling Custom activity Hook

[Former Member]

Hello ME and MII Experts,

We are tying to call custom MII transaction via Activity hook at operation level. While doing that, we received the error "The resource "SAPMEWIP" does not support two-phase commit and cannot be enlisted in the current transaction". This issue is fixed by changing the data source to XA and changing the SQL query in MII transaction to "Query" instead of "Fixed Query" .

Issue:- When we set SQL query to "Query" it is not allowing to make a call to DB package.

Any inputs on how we can solve this?

-Adarsha.K.S

[Former Member · Accepted solution]

Hi Adarsha KS,

did you solved your problem because I have the same?!

Regards,

Matthias

[Former Member · Accepted solution]

Yes. My problem is solved. Basically you cannot use the standard data servers SAPMEWIP/SAPMEINT for your SQL queries in the MII transaction.You need to create new MII data server pointing to WIPPOOL (This should be defined as XA type under JDBC custom data sources in NWA) and then use this as a source for all your SQL queries inside MII transaction.

Hope this helps!

-Adarsha.K.S

[Former Member · Accepted solution]

Forgot to mention, the SQL query in MII transaction should be used as "QUERY" rather than "FIXED QUERY"

-Adarsha.K.S

[Former Member]

Hi Adarsha.K.S

your solution works fine for me.

Thanks,

Matthias