OL Learn

Error "max_user_connections"


I have a Datamapper configuration with Database input (MySQL). That configuration is part of a Workflow process. Now I get an error in Workflow:

11:46:17.493 [0010] W3001 : Error while executing plugin: HTTP/1.1 500 LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: Aktion : Error running script (Wrapped com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User USERNAME already has more than ‘max_user_connections’ active connections (#4)) (DME000019) (DM1000031)

It seems, that the Datamapper opens a database connection, but does not close it after processing.
How can I close the connection in my Datamapper configuration after processing the data?

And how can I close current open connection? I tried to restart all Connect services without success.


Hi Thomas,
When the error comes from Datamapper engine that does not mean that Datamapper engine consumes all connections, it can be that the Datamapper is one of last consumers that that triggers the problem.
As a temporary solution, to release all mysql connection, you can restart OLConnect_MySQL service.
To fix the problem, you can have to look at Datamapper/Template configuration files. Probably there is a script that opens connection. Ensure that the connection is properly used in all Script steps of the configuration.

Hi andriy,

thank you for your reply. I used an action script within the datamapper to get another connection. That was my problem. :see_no_evil: