3) Connections are not enough for current load. 2) Configuration to DB/EIS is wrong or DB/EIS is temporary Note 719778 in order to check and resolve connection leaks. Possible reasons: 1)Maximum allowed connections to DB or EIS is reached. We already maintained additional settings in IDM_DataSource -> Connection Pooling, Initial Connections = 1 (default:0), Max Connections = 100 (default:25), but this does not solve the problem.Ī restart of the AS Java did not help, neither did a re-creation of the JDBC-Driver / datasource.įor lack of other things to try, I exchanged sqljdbc4.jar with sqljdbc.jar but this throws the expected error because of JVM 1.6, of course.ĭefaultTrace contains the following entries:Ĭom. caught: Connection reset.ĬonnectionID:51 Prelogin error: host port 1433 Error reading prelogin response: Connection resetĬom.exceptions.BaseSQLException: ResourceException occurred in methodĬonnectionFactoryImpl.getConnection(): : (Failed in component: dbpool, BC-JAS-TRH)Ĭannot create connection.
Network (ping) is stable without losses & firewalls are switched off on both ends.
How to reset idm settings install#
To run this command is mandatory to install nodemon which will restart. We are on NetWeaver 7.3 SP5 / MaxDB 7.8 / SLES11 / SAPJVM6.1, so we used sqljdbc4.jar as JDBC driver, prefix_prov as connection user. Host configuration is to indicate the domain name of Keyrock in prodoction. We use Win 2008R2 with SQL 2008 R2 64 bit as database server. During a fresh setup of IdM 7.2 the connection between UI and database is unstable.Īfter a manual (re-) start of the IDM_DataSource the Idm- & Admin-UIs just work fine (so the DB-Connection-String / User / Datasource Name are OK), but after about 2 minutes we first get an error "Could not get MSKEY for logged in user" and upon refresh it says "Service is down", "Access denied".Īfter a wait-time of about 2-5 minutes the IdM UI works fine again, until it crashes again after 2-3 minutes.