We are having an issue when restarting servers whereby the AppServer broker for our web services is starting before our databases. When a reboot occurs, we get the following lines in our webservices server.log file:
P-004868 T-004872 1 AS -- Logging level set to = 2
P-004868 T-004872 1 AS -- Log entry types activated: ASPlumbing,DB.Connects
P-004788 T-004792 1 AS -- Logging level set to = 2
P-004788 T-004792 1 AS -- Log entry types activated: ASPlumbing,DB.Connects
P-004788 T-004792 2 AS AS Starting application server for webervices. (5560)
P-004868 T-004872 2 AS AS Application Server Startup. (5473)
P-004788 T-004792 1 AS -- ** There is no server active for database (dbname) on -H (server) -S (service). (704)
P-004788 T-004792 1 AS -- Error initializing the application server. (5479)
P-004868 T-004872 2 AS AS Application Server Shutdown. (5476)
P-004788 T-004792 2 AS AS Application Server Shutdown. (5476)
The thing is, it never retries creating a connection again, which means the client's web services are down until we logon to their server and manually start the broker under the AppServer folder in Progress Explorer Tool.
Any ideas on how we can fix this issue?
I think you have two options:
1. do not let the AdminServer autostart the databases and AppServers but script it in a batch script that waits for each startup task to finish
2. connect to the databases in the AppServer startup procedure and repeat delayed connection attempts if database connection fails - possibly bailing out after x failures.
Reply posted twice due to something going down.
I initially thought i had everything configured for what you mention in the second option, with the database parameters set in the appserver startup. I already have the Service Connection Retries set to 10, with the Service Retry Interval set to 60. However it doesn't say anywhere whether this delay should be entered in seconds or milliseconds. Could you clarify this?
I'm not sure on the service connection retries etc - I do not think these are related to database connection attempts. I meant to connect and retry to connect to your databases in the appserver startup procedure (.p) as opposed to directly connecting on the command line.