MikeatBDB
Member
Registered:1162479340 Posts: 11
Posted 1528281997
Reply with quote
#1
Hi all I'm starting the migration of our process from 7.6 to 9.5. I'm getting the above error in two places. I get it when I try to fill a drop down list with data from another database the SQL connection is configured to Use DTC. The actual error i:Failed to execute deployed method 'ListOptions', using entity 'users'. Exception 'This transaction manager failed to establish a connection with another TIP transaction manager. (Exception from HRESULT: 0x8004D01F)' occurred when attempting to 'BusinessObjectStore'. And also when I try and connect to another database in my own dll that works perfectly in 7.6. We have checked Microsoft and found the issue where it is setting to IPv6 and we have updated the links between the servers so IPv6 works. Anybody know of anywhere to check to see if we have missed anything. Thanks Mike
BMellert
Guru
Registered:1225130168 Posts: 688
Posted 1528289653
Reply with quote
#2
Is DTC configured for both databases? We had that once. (Though with it working in 7.6, I suspect it is.) Also, are you connecting to the remote database via a direct connection, or using a data link server? If direct I wouldn't think this would be an issue. (By direct I mean defining a using a connection in the SelectSql(<conn>,SQL) setting.)
MikeatBDB
Member
Registered:1162479340 Posts: 11
Posted 1528290769
Reply with quote
#3
We've checked that the DTC is configured for both servers and I am using a direct connection. But the connection is set up to use DTC as I want to be able to use it in my dlls and this generates the same error. Testing the connection within the designer works with the DTC on. If I untick the use DTC on the connection it works to fill the dropdown so it does look as if there is an issue with the DTC setup. Everything looks fine and we have also checked it using DTCping. Any further ideas to look into this would be great. Thanks
BMellert
Guru
Registered:1225130168 Posts: 688
Posted 1528377807
Reply with quote
#4
Within my solutions, well library for the DB connections, my remote databases do not have the "Use DTC" checkbox checked. We do inserts / updates / deletes / selects with these without issue via a direct. We also sometimes join / select via database links -- only when we must join to transfer directly between databases -- without issue, but that is DB to DB configuration since its via data link servers. As I recall some issues in the past led us to this configuration. We don't make/use DLLs from the solutions, so I cannot assist in that arena. I'm not sure I can shed much light, but perhaps others can. You may also want to consider posting on the OpenText forums as well or raising a ticket.