Solved

Application Server

  • 7 January 2022
  • 2 replies
  • 168 views

Userlevel 2
Badge +5

Application server is creating huge logs. The admin server is recording the following error -”PINGDATABASE" set up for pool "fndbas_admin" failed with exception: "pingDatabase returns not OK” becuase of which mainserver logs are increasing at a very high rate. It generated 9G log file today. Does anyone know what could be the problem and how it can be fixed?

icon

Best answer by Charith Epasinghe 7 January 2022, 15:08

View original

2 replies

Userlevel 6
Badge +13

Hi @envkavita,

In IFS middleware,there is a ping test from middleware to the database to make sure that sessions are alive before being utilized by data sources in middleware.

-”PINGDATABASE" set up for pool "fndbas_admin" failed with exception: "pingDatabase returns not OK” 

looks like you had a  TNS issue where admin server could not connect to database.The above error is a strong indications to show that an interruption has happened to the connection between the middleware server and the database server. 

An interruption between middleware and database can trigger an issue where deployments in middleware will fail, depending on the degree of this interruption IFS can recover itself. However, any extended interruption can affect the middleware where you must restart the IFS service(sometimes database) to resolve the problem.

Most of the time this might have resolved after restarting all servers and make sure no distrubances to the connection between middleware to the database.
 

Userlevel 6
Badge +18

In addition to what @Charith Epasinghe said above, just in case the restart doesn’t fix the issue, I would also check to see if anyone just recently reconfigured your application server - it is possible that something was incorrectly entered in the reconfig process re the database or the account entered.

Nick

Reply