199 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
WebSphere Application Server - Scripting Security
Wed, Jul 26th 2017 16
WebSphere Liberty Profile - Variables
Wed, Jul 26th 2017 11
Moving an IBM BPM 8.5.7 environment, dealing with the Service Integration Bus (SIBus ) tables
Wed, Jul 26th 2017 11
Hmm, Box Sync not playing nice - "Unable to Connect to Box"
Wed, Jul 26th 2017 9
IBM BPM and the Process Federation Server - A Voyage of Discovery #3
Tue, Jul 25th 2017 11
IBM BPM and the Process Federation Server - A Voyage of Discovery #2
Tue, Jul 25th 2017 10
IBM BPM and the Process Federation Server - A Voyage of Discovery #1
Tue, Jul 25th 2017 10
Top 10
java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002
Mon, Jul 24th 2017 74
Further adventures with Oracle database - ORA-01078 and LRM-00109
Mon, Jul 24th 2017 59
Transport Layer Security (TLS) 1.2 and SoapUI
Fri, Jun 12th 2015 47
Hmmm, macOS Sierra and XQuartz and X11
Thu, Oct 27th 2016 37
IBM HTTP Server / IBM WebSphere Plugin - Using Transport Layer (TLS) 1.2
Tue, Nov 10th 2015 36
Executing external Python/Jython scripts from within WebSphere Application Server's wsadmin tool
Thu, Feb 27th 2014 33
java.lang.UnsupportedClassVersionError: JVMCFRE003 bad major version; class=com/davehay/EmployeeServlet, offset=6
Sat, Nov 8th 2014 31
WebSphere Application Server - Transaction Logs - getting it wrong
Sun, Jul 16th 2017 26
WAS - How to clear the WebSphere class caches
Mon, Feb 10th 2014 25
"SECJ0371W: Validation of the LTPA token failed because the token expired with the following info..." - much more useful with WAS 8.5
Wed, Feb 12th 2014 25


XAException occurred. Error code is: XAER_RMERR (-3). Exception is:
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

I'm tinkering with WebSphere Application Server, underlying IBM BPM Advanced, in the context of transaction/compensation/partner log recovery.

In this scenario, I'm placing these logs into a database, Oracle 12c.

It's been a useful - and interesting - learning curve, and I've pretty much proved/tested the concept.

I did, however, see one issue today; specifically, these messages: -

[16/07/17 13:34:06:748 BST] 00000074 XARecoveryDat A   WTRN0151I: Preparing to call xa recover on XAResource: dave
[16/07/17 13:34:06:866 BST] 00000074 WSRdbXaResour E   DSRA0304E:  XAException occurred. XAException contents and details are: "".
[16/07/17 13:34:06:866 BST] 00000074 WSRdbXaResour E   DSRA0302E:  XAException occurred.  Error code is: XAER_RMERR (-3).  Exception is: <null>
[16/07/17 13:34:06:866 BST] 00000074 XARminst      E   WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@35d8b386. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:727)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:1111)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:723)
at com.ibm.tx.jta.impl.PartnerLogTable.recover(PartnerLogTable.java:432)
at com.ibm.tx.jta.impl.RecoveryManager.resync(RecoveryManager.java:1544)
at com.ibm.tx.jta.impl.RecoveryManager.performResync(RecoveryManager.java:2286)
at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:119)
at com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:2239)
at java.lang.Thread.run(Thread.java:809)


appearing in the SystemOut.log for one of my cluster members - AppCluster.

This IBM Knowledge Center article: -


<snip>
Problem

When WebSphere Application Server attempts to recover Oracle database transactions, the transaction service issues the following exception:

WTRN0037W: The transaction service encountered an error on an xa_recover operation. 
The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@1114a62. 
The error code was XAER_RMERR. The exception stack trace follows: 
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:726)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:954)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:137)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:609)
at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:511)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1784)
at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2241)

Cause

Oracle requires services such as the WebSphere Application Server transaction service to have special permissions for performing transaction recoveries.

Solution

As user SYS, run the following commands on your Oracle server:

grant select on pending_trans$ to public;
grant select on dba_2pc_pending to public;
grant select on dba_pending_transactions to public;
grant execute on dbms_system to <user>;

User is a user ID in the application server that is authorized to perform transaction recovery for the XA data source. If you have not authorized any user IDs to perform transaction recovery, the application server uses the login alias for the data source as the user ID.
This problem is mentioned under Oracle bug: 3979190. Running the preceding commands solves the problem.
</snip>

Following the KC article, I updated the Oracle DB permissions: -

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 16 13:20:39 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production


grant select on pending_trans$ to public;

Grant succeeded.

grant select on dba_2pc_pending to public;

Grant succeeded.

grant select on dba_pending_transactions to public;

Grant succeeded.

grant execute on dbms_system to cmnuser;

Grant succeeded.

and then restarted the AppCluster.

Let's see how it goes, but it's looking good so far.



---------------------
http://portal2portal.blogspot.com/2017/07/xaexception-occurred-error-code-is.html
Jul 16, 2017
23 hits



Recent Blog Posts
16
WebSphere Application Server - Scripting Security
Wed, Jul 26th 2017 1:45p   Dave Hay
I'm creating a set of scripts to automate a number of common tasks, including setting up Web SSO: - /mnt/Scripts/enableSSO.jy AdminTask.configureSingleSignon(['-enable', 'true', '-requiresSSL', 'true', '-domainName', 'uk.ibm.com']) # Save and Sync AdminConfig.save() AdminNodeManagement.syncActiveNodes() /mnt/Scripts/exportLTPAkeys.jyAdminTask.exportLTPAKeys('[-ltpaKeyFile file:/mnt/Misc/bpm855.uk.ibm.com.ltpa -password passw0rd ]') /mnt/Scripts/importLTPAkeys.jy AdminTask.config
11
WebSphere Liberty Profile - Variables
Wed, Jul 26th 2017 12:58p   Dave Hay
As per my previous posts, I'm setting up an IBM BPM Process Federation Server (PFS), which runs on WebSphere Liberty Profile (WLP).I'm now going back through the setup from scratch, to see (a) what I learned and (b) whether I can repeat my success :-)Looking at the WLP configuration file - server.xml - I'd noticed reference to a pair of variables: -… …and was trying to work out what, if anything, the difference is, given that they actually point to a the same darn file.This helped:
11
Moving an IBM BPM 8.5.7 environment, dealing with the Service Integration Bus (SIBus ) tables
Wed, Jul 26th 2017 10:32a   Dave Hay
I'm working through this process: -Migrating IBM BPM to the same version on new hardwarespecifically testing the process of "lifting and shifting" an IBM BPM Deployment Environment from one VM to another.This is, in part, to help a client move a running environment from Red Hat Enterprise Linux v5 to v7.So I've got a working environment on a VM, and I've exported the BPM Deployment Environment thus: -/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -export -de De1 -profile Dmgr01 -outputDir /t
9
Hmm, Box Sync not playing nice - "Unable to Connect to Box"
Wed, Jul 26th 2017 6:34a   Dave Hay
So I started seeing this: -Unable to Connect to BoxBox Sync is unable to connect to Box.Verify that you are connected to the Internet and restart Box Sync.If you continue to see this message, contact your administrator to verify if it is a network issue.If it is not a network issue, visit the Box Support website to submit a ticket.yesterday, on my Mac.No matter how many times I tried stopping/starting the Box Sync app, it flatly refused to connect.This whilst I was working away on Box via my bro
11
IBM BPM and the Process Federation Server - A Voyage of Discovery #3
Tue, Jul 25th 2017 4:07p   Dave Hay
So, following these two posts: -IBM BPM and the Process Federation Server - A Voyage of Discovery #1IBM BPM and the Process Federation Server - A Voyage of Discovery #2once I'd got PFS set up and (mostly) working, I did some testing.However, I kept seeing errors such as this: -when I logged into the BPM 8.5.7 Process Portal ( if you remember, this is the new go-to Portal for everything, including the 8.5.5 instances ) via this URL: -https://bpm857.uk.ibm.com:8443/ProcessPortalTalking to some of
10
IBM BPM and the Process Federation Server - A Voyage of Discovery #2
Tue, Jul 25th 2017 3:55p   Dave Hay
So, following on from my earlier post: -IBM BPM and the Process Federation Server - A Voyage of Discovery #1it took me a while to realise that PFS is NOT a UI in its own right; it merely aggregates processes from other BPMs into one single Process Portal.However, YOU need to provide that Process Portal :-)So, in my limited test rig here, I have four VMs: -BPM 8.5.5 This is my source environment, from which I am migrating, which has running instances which I need to drain down over timeBPM 8.5.7
10
IBM BPM and the Process Federation Server - A Voyage of Discovery #1
Tue, Jul 25th 2017 3:40p   Dave Hay
So I've spent the past week getting to grips with Process Federation Server (PFS), and I think I'm pretty close now. In essence, PFS is a capability that's been around for a few years, and allows a business to provide an aggregation layer across multiple different Process Server environments.Whilst this is often pertinent in the context of a migration or upgrade, perhaps where an older version of BPM is being maintained, to allow existing process instances to drain down, whilst new work is be
11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
Tue, Jul 25th 2017 2:39p   Dave Hay
I missed this on Friday: -8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12Fix list for IBM WebSphere Application Server V8.5Time to get downloading ….
74
java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002
Mon, Jul 24th 2017 3:56p   Dave Hay
I saw this: -The test connection operation failed for data source BPM Business Process Choreographer data source on server nodeagent at node Node1 with the following exception: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002. View JVM logs for further details.whilst testing JDBC data sources configured to connect to a newly-minted Oracle 12c database.I checked the Oracle box to ensure that the listener was
59
Further adventures with Oracle database - ORA-01078 and LRM-00109
Mon, Jul 24th 2017 2:58p   Dave Hay
Having installed Oracle 12c ( 12.2.0.1.0 ) today, I was somewhat concerned when I tried to start my database: -sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 24 14:04:56 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to an idle instance.SQL> startup ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/initorcl.ora'SQL> quitDisconnectedI checked the offen




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition