Wednesday, 14 August 2013

WAS to DB2 - Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815

If you get: -

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

when testing JDBC data sources on a newly minted IBM BPM environment ( or, to be fair, IBM Business Monitor ), having just imported/generated the Deployment Environment, make sure that you've restarted your Deployment Manager and Node Agent(s), having first synchronised the node(s).

I keep hitting this problem, and keep on forgetting how darn simple the solution is.

At this stage, having imported the DE and sync'd the nodes, the WAS configuration still requires a restart to properly "take".

Easy :-)

No comments: