Tuesday 2 December 2014

IBM Business Process Manager - WAS to DB2 authentication - SQLSTATE=42815

I have blogged about this before: -


and saw the same issue again today, albeit in a different context.

Whilst bringing up a BPM Advanced 8.5.1.0 environment, I was using the Test Connection button to validate my WAS to DB2 connectivity, via a JDBC Data Source that's in the scope of the Support Cluster ( SupCluster ).

Now I had manually created this datasource last week, in the context of the connectivity between IBM BPM and IBM Business Monitor, and it was working perfectly.

However, this was probably the first time I had tried to test it via the WAS Integration Solutions Console.

This was what I saw in the GUI: -

The test connection operation failed for data source SharedDb on server nodeagent at node AppSrv01Node with the following exception: java.sql.SQLNonTransientException: [jcc][t4][10205][11234][4.11.69] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815 DSRA0010E: SQL State = 42815, Error Code = -4,461. View JVM logs for further details.

 with this in the Node Agent's SystemOut.log file: -

[02/12/14 11:11:44:114 GMT] 000000bb FfdcProvider  W com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on /opt/ibm/WebSphereProfiles/PSCell
1AppSrv02/logs/ffdc/nodeagent_a22f2f20_14.12.02_11.11.44.096984746826382867971.txt com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection 568
[02/12/14 11:11:44:124 GMT] 000000bb FfdcProvider  W com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on /opt/ibm/WebSphereProfiles/PSCell
1AppSrv02/logs/ffdc/nodeagent_a22f2f20_14.12.02_11.11.44.121154041395887602665.txt com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionToDataSource 1486
[02/12/14 11:11:44:124 GMT] 000000bb DSConfigurati W   DSRA8201W: DataSource Configuration: DSRA8040I: Failed to connect to the DataSource.  Encountered java.sql.SQLNon
TransientException: [jcc][t4][10205][11234][4.11.69] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815 DSRA0010E: SQL State = 42815, Error Code = -4,461.
java.sql.SQLNonTransientException: [jcc][t4][10205][11234][4.11.69] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815 DSRA0010E: SQL State = 42815, Error Co
de = -4,461
[02/12/14 11:11:44:148 GMT] 000000bb DataSourceCon E   DSRA8040I: Failed to connect to the DataSource.  Encountered "": java.sql.SQLNonTransientException: [jcc][t4][102
05][11234][4.11.69] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815 DSRA0010E: SQL State = 42815, Error Code = -4,461
        at com.ibm.db2.jcc.am.gd.a(gd.java:676)


 
The solution was, as ever, quite simple.

I needed to ensure that the Data Source contained a valid Component Managed Authentication Alias: -


whereas my Jython script had only set the Authentication Alias for XA Recovery.

Seemples.

No comments:

Visual Studio Code - Wow 🙀

Why did I not know that I can merely hit [cmd] [p]  to bring up a search box allowing me to search my project e.g. a repo cloned from GitHub...