There are a number of reasons why a historical chart will not get populated, mainly because there are a number of stages to the retrieval of the data, all of which have potential failure cases. When you get a historical chart the following occurs:
Drivers and client libaries
The Console connects to all supported databases using JDBC, with the exception of MySQL this means the console does not need any additional librares or drivers other than those shipped with the console by default. In the case of MYSQL the user needs to download the MYSQL driver from here
The jar then needs to be added to the console install under here
You will need to restart the console after doing this
|Different language database from the console JVM
The console assumes that numbers will be returned using the decimal delimiter, where they are comma separated (which can be the case in a database set for German or French for example), then the conversion of the returned rows can fail.
Check the exception log, e.g.
To resolve this issue:
This should make the query from the database return dot delimited decimal values.
|Problems connecting to an Oracle database
Some of you may have seen this, where trying to draw a historical chart you get a failed connection to Oracle. Well, the solution is:
Defining the server name and port for the "Client connection" in the Database setting section may also help.