topic tAccessInput mixing fields in Talend Studio

tAccessInput mixing fields

Anonymous — Sun, 28 Jan 2018 11:43:14 GMT

In the project I use tAccessInput for rows input from .accdb, and tXMLMap to build output XML document:

In development environment everything works fine, also if I export the job and run it outside of TOS on the same machine.

If I export the job and run it under 32-bit java, the numeric fields from Access table are mixed up in resulting XML.

Development computer is Win10 64 bit with TOS DI v6.4.1 and

Java(TM) SE Runtime Environment (build 1.8.0_152-b16)
Java HotSpot(TM) 64-Bit Server VM (build 25.152-b16, mixed mode)

The other computer is Win7 32-bit:

Java(TM) SE Runtime Environment (build 1.8.0_161-b12)
Java HotSpot(TM) Client VM (build 25.161-b12, mixed mode, sharing)

I'd appreciate any help ...

Re: tAccessInput mixing fields

Anonymous — Mon, 29 Jan 2018 14:34:18 GMT

We resolved the problem, the computer with 32-bit java had some 'remainings' from an older java version. After java uninstall and reinstall, it works as it should.

Re: tAccessInput mixing fields

Anonymous — Tue, 30 Jan 2018 07:32:25 GMT

Hello,

Thanks for your feedback and sharing your solution on forum.

Best regards

Sabrina