Why is my History Chart not working?

The Active Console connects separately to the database. It gets its database connection details from:

1. The Gateway's Database logging section. Specific to Oracle, the Client Connection Server Name (databaseLogging > connection > database > oracle > clientConnection > serverName) and Port (databaseLogging > connection > database > oracle > clientConnection > port) must be filled up.

2. The Active Console's Database settings as seen below:

Check if the database definitions are correct and if the Active Console's machine (desktop PC or laptop) has sufficient network access to the database and database server.

1. Identify the cell where the history chart is executed. The cell will tell us what varname to look for.
2. Query the Geneos database for duplicate varnames:
   • SELECT * FROM var_ref_table; - This will output all the varnames. Check if the varname in question has a duplicate.
   • SELECT * FROM version_table; - This will output the Geneos database schema version.
3. After that, follow the steps in https://support.itrsgroup.com/hc/en-us/articles/115004023145 (How do I fix varname duplicates in Database Logging?) to fix the issue. 

Attached is a sample table definition that shows a value column with a REAL or FLOAT datatype: https://itrs.zendesk.com/hc/article_attachments/115003569153/query_output.txt

The value column's datatype needs to be of type REAL or FLOAT.

1. Access the Gateway's Database Logging section.
2. Go to the Database Item (databaseLogging > items) in question.
3. Get the Table where the Database Item is being logged.
4. Go to the Table (databaseLogging > tables)
5. Check if the Type (databaseLogging > tables > table > type) is set to Double. If not, set it to Double. Once done, re-execute the History Chart.