Error in joblog of submitted job for exporter

[bdietz400]

-- Interface name: IBM Toolbox for Java
-- Interface version: V7R5M0 PTF 3

SELECT REPLACE(UPPER(Heading), ' ', '') AS Heading
,BIGINT( TRIM( TRANSLATE( Value, ' ',
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz(+-*/%=&"''()<>,.:;?) ')))
AS Val
FROM Qtemp.Qdbop00003

The above is what I could find from visual explain
in the joblog I get these msgid's repeated: CPD5036 CPF5029 CPF5029 SQL0420

Message ID . . . . . . : CPD5036
Message . . . . : Data mapping error on member QDBOP00003.
Cause . . . . . : A data mapping error occurred on field
Cast(Translate(Strip(Translate(QDBOP00003_1.VALUE, *UNNAMED Table), Both,'
'), *UNNAMED Table) AS BigInt) in record number 1, record format *FIRST,
member number 1, in member QDBOP00003 file QDBOP00003 in library QTEMP,
because of error code 26. The error codes and their meanings follow:
26 -- For the CAST operation, a source character was found that is not valid.

IBM i is on V7.5 and really current on PTF's

assuming a change in one of the SQL services, not sure which one.

[bdietz400]

for now I have changed to "enabled": false

[krka01]

@bdietz400 I have also experienced this.

I notice that Scott Forstie have created a PR for the readme section with another SQL that seems to work better, at least no data mapping error when i try it in ACS RSS. Seems like you have to edit it to remove one of the columns named value if you going to use it in Prometheus: c3c3cdf