on 05-24-2013 11:25 AM
Hi Experts
We are currently seeing issues when running jobs during the night. Sometimes the jobs receives an error (in different job passes and different jobs):
<mx:ERROR seq="1">
<mx:TEXT>JDBCHandler constructor failed connecting to DB jdbc:sqlserver://pfosap233c:1433;databasename=mxmc_db;user=mxmc_rt;password=************</mx:TEXT>
<mx:TEXT>com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.BindException: Address already in use: connect</mx:TEXT>
<mx:ENTRY/>
I suspect this has something to do with too many concurrent connections to the SQL db. Has anyone else seen this issue? And how did you overcome it?
One job might fail one night, and run without errors the following night. Somehow it must be related to connections not being closed or a maximum of allowed connections to the db.
Hope someone can guide me in the right direction
We are running IdM 7.1 SP6
Kind regards,
Heidi Kronvold
Heidi,
Did you find a solution for this ? What's the JDBC driver version ?
Cheers
Murali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The problem could be anywhere. I am guessing it could be because of the driver version. JDBC 4 is the latest version which you could use with SQL 2005. Could you please check with SAP if they have this as this as a known issue.
Cheers,
Murali
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.