Error Occurred During Transaction Or Heuristic Processing
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up TransactionScope won't work with DB2 provider up vote 2 down vote favorite 1 I've been trying to use TransactionScope with a DB2 database (using DB2 .Net provider v 9.0.0.2 and c# 2.0) which SHOULD be supported according to IBM. I have tried all the advice i could find on the IBM forums (such as here) to no avail. I have enabled XA transactions on my XP Sp2 machine, tried also from a Win 2003 Server machine but i consistently get the infamous error: ERROR [58005] [IBM][DB2/NT] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "16". Subcode = "2-80004005". SQLSTATE=58005 The windows event log says: The XA Transaction Manager attempted to load the XA resource manager DLL. The call to LOADLIBRARY for the XA resource manager DLL failed: DLL=C:\APPS\IBM\DB2v95fp2\SQLLIB\BIN\DB2APP.DLL File=d:\comxp_sp2\com\com1x\dtc\dtc\xatm\src\xarmconn.cpp Line=2467. Also, granted the NETWORK SERVICE user full rights to the folder and dll. Here's the MSDTC startup message MS DTC started with the following settings: Security Configuration (OFF = 0 and ON = 1): Network Administration of Transactions = 0, Network Clients = 0, Inbound Distributed Transactions using Native MSDTC Protocol = 0, Outbound Distributed Transactions using Native MSDTC Protocol = 0, Transaction Internet Protocol (TIP) = 0, XA Transactions = 1 Any help would be much appreciated! Thanks, Florin db2 transactionscope drivers share|improve this question asked Sep 10 '09 at 8:00 user171282 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote I managed to get the creaky old IBM DB2 v7 ODBC driver working in a TransactionScope. It required: XA transactions enabled in MSDTC properties A value entered under the registry key HKLM\SOFTWARE\Microsoft\MSDTC\XADLL with name 'DB2CLI.DLL' and value 'C:\PROGRA~1\IBM\SQLLIB\BIN\DB2CLI.DLL' (path to dll in 8.3 format - v9 uses DB
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Problem with TransactionScope with Linked server to DB2 SQL Server > SQL Server Data Access Question 0 Sign in to vote Hi I have an windows application built on ADO.net for executing procedure present in SQl server 2008 DB. This procedure in turn executes query in DB2 via linked server. Everything works fine untill I use Transactionscope inside my dotnet code. I get below exception when I put the execute inside a transactionscope in dotnet code. http://stackoverflow.com/questions/1403946/transactionscope-wont-work-with-db2-provider The operation could not be performed because OLE DB provider "IBMDADB2.DB2COPY1" for linked server "
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. https://social.msdn.microsoft.com/Forums/en-US/8223c74f-7896-4969-aa84-932017a89f53/msdtc-issues-with-db2-in-win-xp-sp2?forum=windowstransactionsprogramming The content you requested has been removed. You’ll be auto redirected in 1 second. http://www.mqseries.net/phpBB2/viewtopic.php?t=40883 Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: MS-DTC issues with DB2 in Win XP SP2 Archived Forums T-U > Transactions Programming Question 0 Sign in to vote I am having some issues with MS-DTC on my machine (Win XP SP2) trying to use error occurred XA transactions for DB2 on Z/OS and a SQL Server distributed transaction processing environment. I checked the event log in my machine and I see the followwing error : "The XA Transaction Manager is in an inconsistent state and cannot proceed. XA Transactions will not take place. Please contact Microsoft Product Support. DB2APP.DLL" I am not having this in win xp sp1. However, I did notice that I need to error occurred during do some changes to MS-DTC to enable XA transaction support for XP SP2. I did follow the steps to verify all the required options are checked in the security configuration tab of MS-DTC. I have Network DTC transactions enabled, Enable XA Transactions is checked, and the DTC Logon account is NT AUTHORITY\NetworkService. Also, I did create a registry key for the DB2 XA manager (DB2APP.dll). I didnt find any key XADLL under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC. But I created one and did follow the steps (also listed in the following link). http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=windows+2003+XA+transaction+MSDTC&uid=swg21188896&loc=en_US&cs=utf-8〈=en I still keep getting the same ERROR [58005] [IBM][DB2] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "16". Subcode = "2-80004005". SQLSTATE=58005 which as per the IBM manual is pointing me to microsoft for examining the subcode. I am not sure how to grant permission to NT AUTHORITY\NetworkService to the folder containing DB2APP.dll as I am not able to find this user in the list of users. Any suggestions? Please help! Monday, April 03, 2006 11:58 PM Answers 0 Sign in to vote In the Explorer UI/Security tab, the name shows up as "NETWORK SERVICE". Can you find this one? Or you can simply type in "NETWORK SERVICE". Wednesday, April 05, 2006 6:46 AM All r
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support
MQSeries.net Forum IndexMultiphase CommitMQ as a transaction coordinator for UDB MQ as a transaction coordinator for UDB View previous topic :: View next topic Author Message TheAndroid Posted: Tue Dec 04, 2007 12:26 pm Post subject: MQ as a transaction coordinator for UDB NoviceJoined: 04 Dec 2007Posts: 23 Hi all, I am getting a message from UDB: FATAL SQL ERROR SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "9". Subcode = "". SQLSTATE=58005 SQLSTATE 58005: A system error (that prevents the successful execution of subsequent SQL statements) occurred. I was wondering if anyone had seen this before. I am using MQ v6 as a transaction coordinator for a 32bit COBOL program. When I was running V5.3, this worked fine. Now, I'm getting these errors. I rebuilt the switch files as directed and made sure it was in the correct directory. I know MQ is trying to use the 32 bit version as I can rename the one in /var/mqm/exits and it will complain when I do MQBEGIN. However, the documentation at boulder says it should be using the 64 bit one. If I delete the 32 bit db2swit file, I get 2212 errors (RESOURCE_MANAGER_NOT_FOUND) errors so it is demanding the 32 version. I'm at a loss on this as when I do db2 ? sql0998 the response shows two subcodes. Neither of which I'm getting. db2diag on the server doesn't show anything either. Either way, the error message itself is NO help! I realize this sounds more like a UDB post, but I have no idea what to look at next. The only thing which has changed is MQ, so I have to suspect it. Help! Back to top JuulV Posted: Tue Dec 04, 2007 1:08 pm Post subject: ApprenticeJoined: 05 Sep 2007Posts: 28Location: Belgium Just a wild guess... do you have both 32- and 64-bit versions of the switch files? And are these in the correct locations? With correct permissions? And are they correctly defined in the qm.ini file? I've noticed that since WMQ 6.0, even though I only use 32-bit applications, I need to compile exits in both 32 and 64-bit mode, AND place them in the directories named in the ExitPath section of the qm.ini file. I never got around researching this any further, but I ran into problems trying to s