topic Insert Data in Talend Studio

Insert Data

Kaliana — Mon, 04 Nov 2019 13:38:11 GMT

Hello, Can you help me please? I get the following error when trying to insert calculated data into a field. Thank you for your help

Re: Insert Data

Sujay1 — Mon, 04 Nov 2019 16:45:58 GMT

@Kaliana the ternary operator worked fine I used the same one maybe it has something todo with the output step. Did you checked the datatype of the field in DB. Can you post full error message and job pic.

Re: Insert Data

Kaliana — Tue, 05 Nov 2019 05:05:59 GMT

Hello,

The data type of the field in DB : Number(20,2)

And it is in the tmap5 that the error occurs.

Re: Insert Data

Sujay1 — Tue, 05 Nov 2019 14:00:19 GMT

@Kalianafrom ur screenshot it clearly shows error is at "STR_CONSO_TRANSPORT"(ORACLE OUTPUT as ) as any component which has error is shown at top of the component in talendOS . Can you change the datatype to double in Database as your using double in the tmap and try it out once. If you still think it's DB error to clarify redirect the output to tlogrow to see. My gut feeling says it will log the data properly.

Re: Insert Data

Kaliana — Wed, 06 Nov 2019 05:29:17 GMT

Hello, Thank you for your return.

In fact, I already modified the fields in tmap. And I changed the type of NUMBER fields (20,2) to (38,2). The problem came from the fact that there were data to compute in forms 0/0 or 0 / null which caused errors of the NaN or Infinity type (in the tlogRow).

So to solve the problem:

1- I created another job that was updating the null values:

"UPDATE STR_CONSO_TRANSPORT SET CONSO_COST_BASE = 0 WHERE CONSO_COST_BASE IS NULL"

2- I added the following conditions in the tmap :

row22.CONSO_TONNAGE == 0 || row22.CONSO_COST_BASE == 0?:

row22.CONSO_TYPE.equals ( "x")?(row22.CONSO_COST_BASE / row22.CONSO_TONNAGE): 0

Re: Insert Data

Sujay1 — Wed, 06 Nov 2019 14:27:00 GMT

@Kaliana cool as long as its solved. cheers