• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by wim d. · Feb 11, 2014 at 01:38 PM ·

Performance Warehouse connect using script

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.

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

2 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by wim d. · Feb 11, 2014 at 03:44 PM

OK, thx.

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Stefan G. · Feb 11, 2014 at 02:26 PM

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:

 

  • connection loss during normal operation -> constantly trying to reconnect especially we will never give up !
  • not being able to during initial connect (first connect, server start, server restart) -> there no reconnect will be done as we do require at least one successful connect to the pwh backend to start up the reconnect mechanism (e.g. prevent reconnect loop in case of bad credentials etc...)

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

Comment

People who like this

0 Show 3 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image wim d. · Feb 11, 2014 at 02:43 PM 0
Share

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.

avatar image Stefan G. wim d. · Feb 11, 2014 at 02:46 PM 0
Share

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:

  • although we do not recommend it running the dynatrace server on the same machine as the database server try to change the startup procedure that the sql server is started before the dynatrace server

 

 

-stefan

avatar image Stefan G. Stefan G. · Feb 11, 2014 at 03:06 PM 0
Share

next update there is no rest functionality for that

 

-stefan

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

1 Person is following this question.

avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A