Getting the following error in the agent log files:
DB_Oracle/5.5.8.601/DB_Oracle/DBO-<DBServer-SID>-agent ERROR [DBO-<DBServer-SID>;-lowPriorityPool-194-[DBO_OS_File_System_IO][YYYY-MM-DD HH:MM:SS.SSS]] com.quest.qsi.fason.oracle.collection.processor.DBOInstanceProcessor - Failed to run DBOFileSystemIOProcessor processor of DBO_OS_File_System_IO collection of DBO-<DBServer-SID> instance.
java.lang.RuntimeException: Failed to execute collection [DBO_OS_File_System_IO], reason=java.lang.NumberFormatException: For input string: "0,87"
Locale property not set correctly
Run the script below in the script editor/console.
Make sure that the variable agentId is set correctly and that the new locale value matches the values from the database server.
To get the agentId, open the script editor/console, list all agents and select the problematic agent. In the properties listing below you will find the property agentID.
To get the correct locale on the database server, just run the command locale from the command line.
==================================================
// Get primary ASP object
namespace = "DB_Oracle";
agentType = "DB_Oracle";
agentId = "<set your agent id>" //can be taken from the script editor
primaryAsp = server["ConfigService"].getAgentInstancePrimaryAsp(namespace, agentType, agentId);
parameterName = "osLocaleUnixString";
// Get field value from the primary ASP
oldValue = primaryAsp.getString(parameterName);
// Set field value - make sure the value matches the locale values on the server
newValue = "en_US.UTF-8";
primaryAsp.setValueByString(parameterName, newValue);
// Save the changed ASP
server["ConfigService"].saveConfig(primaryAsp);
return parameterName + " was changed from [" + oldValue + "] to [" + newValue + "]";
==================================================
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center