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:

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...