TeiidSQLException - "unable to transform the column value" when using Grafana with APMSQL

Document ID : KB000122741
Last Modified Date : 07/12/2018
Show Technical Document Details
Issue:
We are using Grafana with APMSQL and have found that when querying metrics with lareg values we et teh following error

 "[{ "error":"org.teiid.jdbc.TeiidSQLException: Unable to transform the column value 4294967296 to a Integer."}][ { "target":"GC Heap:Bytes In Use",

When querying the same metric using Squirrel no such problem occurs and the data is retrieved.
Cause:
The interface as currenlty implemented can only handle values up 2,147,483,647
Resolution:
The cause of this problem has been identified and will be addressed in 10.7 SP3