Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
MikeatBDB

Member
Registered:
Posts: 11
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
0
BMellert

Guru
Registered:
Posts: 688
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.)
0
MikeatBDB

Member
Registered:
Posts: 11
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



0
BMellert

Guru
Registered:
Posts: 688
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.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!