cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Slow PWH Query

derek_darling
Dynatrace Contributor
Dynatrace Contributor

Hello,

This morning our PWH through an error. The issue only existed for 5 mins, but we are not sure why the error came up. After looking into the logs I checked the community to find answers:

https://answers.dynatrace.com/questions/154011/performance-warehouse-data-write-has-stopped.html

The issue seen in this post was similar to the one we saw, however, when we checked the DB tablespace and server connections, everything checked out. The only thing I saw that was different from usual was when I went to the server settings and opened the PWH tab, I got this message that popped up:

pwhoraclelisc.png


Would this cause the issue?


Here are some of the logs:

2018-03-20 06:42:50 WARNING [DefaultRepositoryExceptionHandler] The query timeout was reached or the query was cancelled. If the query is expected to be long running please set a higher timeout.: com.dynatrace.diagnostics.repository.exceptiontranslators.DefaultRepositoryExceptionHandler a:60
com.dynatrace.diagnostics.server.shared.exceptions.repository.QueryTimeOutException: The query timeout was reached or the query was cancelled. If the query is expected to be long running please set a higher timeout.
at com.dynatrace.diagnostics.repository.exceptiontranslators.OracleExceptionTranslator.doTranslateException(SourceFile:38)
at

2018-03-20 06:42:50 WARNING [Server] data cannot be written - The query timeout was reached or the query was cancelled. If the query is expected to be long running please set a higher timeout.
2018-03-20 06:42:50 INFO [LicenseChecker] running uem volume check - cur. transactions '26085581' available, used percentage '3.39' (give or take the free volume)
com.dynatrace.diagnostics.server.shared.sdk.analytics.EndUserPathMetaInfoFilterCriterion does not support filter string translations [log message will be suppressed for 5 minutes]

3 REPLIES 3

derek_darling
Dynatrace Contributor
Dynatrace Contributor

https://community.dynatrace.com/community/pages/viewpage.action?title=Dynatrace+Redistribution+License+Agreement&spaceKey=DOCDT65

Hi Derek,

the license pop-up can't be the reason for the slow pwh, it's not related.

Judging from the short log excerpt I'd say that the database itself had a short period of slowness; you could ask your dba to confirm / refute this hypothesis.

If you can't determine the root cause, please open a support ticket with a support archive and ideally an awr report from that time. Thanks,

best regards,

Peter

Peter,

Thank you for your response. I took your advice and opened a ticket. I figured I would check here first.

https://support.dynatrace.com/supportportal/browse/SUPDT-43397