Is it possible to (re)connect the Performance Warehouse using some kind of scripting instead of using the GUI? From time to time the Performance Warehouse does not connect when the dT server (5.5) is restarted. Reconnecting the PWH through a script will prevent dataloss; the script can execute when the alert is triggered.
Wim.
Answer by Stefan G. ·
Hi,
I am currently not aware of a possible rest call to trigger a connect to the pwh. However I'll try to summarize what the PWH component is able to do:
So I assume during restart of dtServer it is possible that a connection attempt is failing and therefore nor automatic reconnect is done. It would be interesting to have server log during such a situation if possible. Additionally I'll forward this question about rest interfaces to a colleague of mine (getting state of PWH, trigger a connect of PWH).
-stefan
In this case the reason for failure is:
2014-02-11 04:28:48 SEVERE [DefaultRepositoryExceptionHandler] Could not handle exception. See attached exception: Cannot open database "dynatrace_prod" requested by the login. The login failed.: com.dynatrace.diagnostics.repository.exceptiontranslators.DefaultRepositoryExceptionHandler handleException:71
Which is strange as it was a "standard" server restart.
Wim.
Is the dynatrace server on the same machine as the database server?
If yes, the startup of the dynatrace server is before the sql server there so the sql server is not ready at this moment. The first connection attempt is failing so we do not perform any reconnect.
quick fixes:
-stefan
JANUARY 15, 3:00 PM GMT / 10:00 AM ET