Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anselmopeixoto
Partner - Creator III
Partner - Creator III

tFileInputJSON: no Getter for field scale in class BigDecimal

Hello,
I'm reading some JSON files using tFileInputJSON component configured as the attached screenshot.
0683p000009MDr5.png
The problem is: whenever a file has numeric values with large decimal scale like 0.39268000000000003 and not enclosed by double quotes, I get the following exception:
java.lang.RuntimeException: no Getter for field scale in class java.math.BigDecimal
This happens no matter the data type configured in the component schema, even if everything is configured as String data type.
Here is a sample of the file:

{
    "cemaden":
}
The cause of this exception is highlighted in bold. If this field is enclosed by double quotes, the file is read without errors.
Is there a way to overwhelm this exception without editing the file?
Thanks in advance.
Anselmo
Labels (4)
11 Replies
Anonymous
Not applicable

Hello guys,
I'm having the exact same issue with the tExtractJSONFields component, and followed these steps:

upgrading Talend to 6.3.0
updating 3 components ( accessors-smart-1.1, asm-5.0.3 and json-smart-2.2.1)

But no luck so far.. I can not even use Xpath instead of JsonPath because it throws the "Cannot determine next state" error reported above.
Has any of you found a workaround until the 6.3.1 release is available ?
Thanks for your tips, 
Maxime.
Anonymous
Not applicable

I solved it by having a tJavaRow and rounding the values.