Product/components used and version/fix level:

Version: 10.15

Detailed explanation of the problem:

I am using XA_Transaction connection since I need to make calls to two different database adapter services (different servers). but I am getting the below error when I run the adapter service

Error messages / full error message screenshot / log file:

[SCC.126.109] Failed to enlist transaction resources from connection. Transaction will be aborted.

Hi Suma,

please provide an outline of your service as screenshot, with transaction handling services as well as your adapter services.

Are the connections to the databases configured properly?

Are the services only reading from the DB or do you plan to insert or update data in databases?
When you are only reading you can stick with NO_TRANSACTION connections, only for inserting and updating you will require transactional connections.

Regards,
Holger

image545×636 24.9 KB

I have attached the screenshot of the error that I get when I try to create a adapter service on the XA_Transaction connection.

Below is the screenshot of the XA_transaction connection.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/015b99c52bc73d854b8604fa3d88372a3d8f5a4f.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/015b99c52bc73d854b8604fa3d88372a3d8f5a4f.png 2x" data-dominant-color="F2F2F2">

image918×696 28.6 KB

Hi Suma,

please provide more details as the two screenshots refer to two different connections.

Can you check the error log of the IS for the details why resourceDomainLookupValues is failing?

Regards,
Holger

Hi Holger,

Thanks for your response. I’m very new to webMethods, my requirement is simple, where I need to call both READ & UPDATE to different DBs in a flow service. But when I use both READ & Update within a flow service I get the below error

“[ART.114.303] Adapter Runtime (Transaction): Unable to commit transaction.
[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections.
[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections.”

This is the screenshot of the flow service

I understand we can’t make both Read & Update in a LOCAL_Transaction, so I am trying to create XA_Transaction for UPDATE. But with XA_Transaction connection, I am not able to create the adapter service itself.

Below is the screenshot of the XA_Transaction connection that I have created.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/94da19ece8f39ed145d54ce1cda7cf346caff547.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/94da19ece8f39ed145d54ce1cda7cf346caff547.png 2x" data-dominant-color="F3F2F2">

image1004×655 26.4 KB

Appreciate your any help on this.

Thanks,
Suma

You don’t really need a transaction for read and update. Transaction is only necessary when making multiple changes on to multiple tables. I assume ExportFieldData_Vendors service doesn’t update anything (cause I don’t see a roll back service in error handler) so you can just remove transactions.

Btw your getLastError service is in wrong block (again assuming first inner sequence is try and second one is error handler block (it is usually a good idea to add comments in those blocks)). Your try catch blocks are properly configured right? It should be like this
outter => exit on success
first inner => exit on failure
second inner => exit on done

Hi, Thanks for your response.
I did remove the transactions as suggested, It works only for the first time then I get the below error message on subsequent Runs

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/6d59ac96a35c05a42a7d10a4722f72e1f6e0c32d_2_1035x519.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/6d59ac96a35c05a42a7d10a4722f72e1f6e0c32d_2_1380x692.png 2x" data-dominant-color="F4F4F4">

image1576×792 67.8 KB

Hi Suma,

please make sure that getLastError is ALWAYS the first step in second inner sequence.

Please note that services with explicit transactional handling cannot be debugged in Designer.

Please provide details, which of the three db services is connecting to which db and if it is read only or not?

Regards,
Holger

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/a703d7ba1cffaf17be94c464df8832ab19c21a33_2_1035x520.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/a703d7ba1cffaf17be94c464df8832ab19c21a33_2_1380x694.png 2x" data-dominant-color="F3F3F3">

image1574×792 69.7 KB

Please see the screenshot.

Issue is when I am having mixed DB connections, It errors out when I use multiple database connections pointing to different databases in a single flow service.
Flow service works fine when I do both Read & update on the same database.

Thanks,
Suma

Hi Suma,

in this scenarion you won´t need explicit tranasaction handling at all.
Use NO_TRANASACTION connections for reading from DB1 and DB2 and use a LOCAL_TRANSACTION connection for updating DB1 while using implicit transaction handling here.

Regards,
Holger

Thank you Holger! This worked!