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][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".