search

ThePrez / prometheus-exporter-jdbc

Prometheus Client for IBM i
GNU General Public License v3.0
23 stars 7 forks source link

Error in joblog of submitted job for exporter #35

Open bdietz400 opened 7 months ago

bdietz400 commented 7 months ago

-- 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 commented 6 months ago

for now I have changed to "enabled": false

krka01 commented 3 months ago

@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: https://github.com/ThePrez/prometheus-exporter-jdbc/pull/33/commits/c3c3cdf574408b203349a41db556246d2c3faef8