Corrupt support bundles (2kb or 0kb) created by Foglight Agent Manager (FglAM) (4290328)

A Foglight Agent Manager (FglAM) bundle cannot be generated because the process times out.

The Statistics logs collected by the database agents take up a lot of space on the FglAM (Foglight Agent Manager) and cause FglAM support bundles to be larger. Aside from deleting old Statistics files for previous database cartridge releases, is there anything else that can be done to reduce space?

Old database cartridge agent log files are being stored on server preventing FglAM support bundles from being created.

WORKAROUND

Delete old Statistics log files for SQL PI from the following locations on the Foglight Agent Manager servers

1. At the FglAM OS level, navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\{Cartridge type, such as DB_SQL_Server}\
2. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
3. Navigate into the current cartridge version folder.
4. Delete all of the compressed statistics files ending in .gz, .1, .2, .3, .4, etc.
5. Navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\Cartridge type, such as DB_SQL_Server}\
6. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
7. Navigate into the current cartridge version folder.
8. Delete all of the compressed statistics files ending in .gz

Delete the old database agent log files from the Foglight Agent Manager servers

1. At the FglAM OS level, navigate to {FglAM}\state\default\logs\fb8be857-fbcf-4747-973d-295a8570e581\DB_Oracle\
2. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
3. Repeat steps 1 and 2 for the other cartridges installed in {FglAM}\state\default\logs\fb8be857-fbcf-4747-973d-295a8570e581\

Remove any old memorywarning files

1. Delete any files located in {fglam}\state\default\memorywarning

Adjust the rollover properties for log files

1. Review and adjust the retention settings for log files in KB article 4226553 . Reducing the set count and retention count may help to reduce space used by old log files on the servers.

Attempt to regenerate the FglAM support bundle.

STATUS

Please run the following scripts to disable SQL PI statistics from being generated for existing SQL Server and Oracle agents.

Please, go to Tooling | Script Console | click on the Add button, paste a groovy script from the list below, and then run the groovy script.

NOTE: Users must be logged into Supportlink to access and download these scripts

For Oracle database agents (non-RAC)

Run the attached script called "List_all_of_the_Oracle_PI_Debug_Statistics_settings.groovy" to list the current status the PI statistics for all Oracle (non-RAC) database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

Run the attached script called "Update_all_Oracle_PI_Statistics_debug_to_off.groovy" to turn off the PI statistics for all Oracle (non-RAC) database agents.

For Oracle RAC database agents

Run the attached script called "List_all_of_the_Oracle_RAC_PI_Debug_Statistics_settings.groovy" to list the current status the PI statistics for all Oracle (non-RAC) database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

Run the attached script called "Update_all_Oracle_RAC_PI_Statistics_debug_to_off.groovy" to turn off the PI statistics for all Oracle (non-RAC) database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

For SQL Server agents

Run the attached script called "List_all_of_the_SQL_PI_Debug_Statistics_settings.groovy"  to list the current status the PI statistics for all SQL Server database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

Run the attached script called "Update_all_SQL_PI_Statistics_debug_to_off.groovy" to turn off the PI statistics for all SQL Server database agents.

Delete old Statistics log files for SQL PI from the following locations on the Foglight Agent Manager servers

1. At the FglAM OS level, navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\DB_Oracle\
2. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
3. Navigate into the current cartridge version folder.
4. Delete all of the compressed statistics files ending in .gz, .1, .2, .3, .4, etc.
5. Navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\DB_SQL_Server\
6. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
7. Navigate into the current cartridge version folder.
8. Delete all of the compressed statistics files ending in .gz