• 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 /
  • Network Application Monitoring /
  • NAM Open Q&A /
avatar image
Question by Andre V. · Jan 28, 2015 at 04:54 PM ·

DBDailyMaintenance execution failed

Hi

We keep on getting the message "DBDailyMaintenance execution failed at date/time" in CAS (12.2.1.75).

Any idea how to resolve this and ensure the daily maintenance task runs successfully again? What impact does it have when this task doesn't run?

Thanks

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.

4 Replies

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

Answer by Andre V. · Feb 04, 2015 at 05:40 PM

Thanks Adam, figured memory would cause hassles eventually.

 

Yip thanks Ulf, I'm aware of the required regedit change (wink)

SQL is set to consume a specified max amount, 10GB I think

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 Ulf T. · Feb 04, 2015 at 01:28 PM

Hey Andre - keep in mind that after you chucked in the DIMMs Adding Memory to the Report Server

You might want to check on the SQL how much it gobbles up.

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 Andre V. · Feb 03, 2015 at 11:20 PM

Adam,

I've reviewed the attached log file but I'm not sure it is simply timing out; would appreciate it if you have a few minutes to take a look.

Alternatively, I'll open a support ticket.

Thanks!

PS: the CAS doesn't have the correct amount of memory assigned (O/S total is 36GB currently, with 16GB for CAS if I recall correctly), we're waiting for a memory upgrade on the server.

server.log (zipped)

Comment

People who like this

0 Show 1 · 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 Adam P. ♦♦ · Feb 04, 2015 at 01:21 AM 0
Share

Andre,

No, it wasn't timeout that could be just extended but lack of memory:

T ADM    15-02-02 22:26:20.870    Memory alert level is about to be changed: 2 => 4; GC will be run before issuing the memory alert.
T ADM    15-02-02 22:26:20.871    Garbage collection started
T ADM    15-02-02 22:28:31.234    Garbage collection done in 02:10.363. Released 12MB
T ADM    15-02-02 22:28:31.236    Memory alert changed to level 4. Free memory: 2 %
E RTM    15-02-02 22:28:31.271    Not enough memory. Cache Clean
E RTM    15-02-02 22:28:31.276    Not enough memory. Cache Clean
T RTM    15-02-02 22:28:31.291    Not enough memory. Stop data processing
T RTM    15-02-02 22:28:31.293    Stop new sites processing. Limit set to: 53 sites
T RTM    15-02-02 22:28:31.294    Stop new clients processing. Limit set to: 1637 clients
T RTM    15-02-02 22:28:31.296    Memory Checker: New servers processing stopped already.
E RTM    15-02-02 22:28:31.297    Woodsman is dropping UEM data from the cache due to current memory alert level
E RTM    15-02-02 22:28:31.299    Woodsman is dropping Server level from the cache due to current memory alert level
T RTM    15-02-02 22:28:31.300    Memory Checker: System Restart

Yes, it would be great idea to add more memory for CAS process ...

avatar image

Answer by Adam P. · Jan 30, 2015 at 03:08 AM

Andre,

The default timeout is 20 minutes (\config\tasks-210-rtmbs-am.xml) that can be increased if you make sure in server.log that it was just a timeout.

Other way we may want to investigate it. Feel free to provide us with related server.log.

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.

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

2 People are following this question.

avatar image avatar image

Forum Tags

esm siebel Dynatrace Managed license nam probe wan citrix dna rest api configuration mq alerting NAM 2018 dashboard dcrumadvisory reports css nam universal decode database mobileapp RUM ads sap nam console scripting nam server sequence transactions nam 2019 upgrade
  • 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