Talend community forum / [resolved] URGENT - ERROR ON tFileInputPositional building job

ienax_ridens · 2012-04-18 17:36:23

Tags: [build, building, database, error, job, mssql, positional file, tFileInputPositional]

Hi all,

I have a very simple job as in the picture attached (you can see also the error), tFileInputPositional is defined as connection i nTalend and exported as context.

This file works well in another job, but now I have the error building the job.

I already tried this steps:
1. removed tMap between tFileInputPositional and tHashOutput_1
2. put in all the fields of the input file (but I need only some fields)

but the errore is the same every time...I am desperate!!!

PLEASE HELP ME!

Uploaded Images

pedro · 2012-04-19 03:57:52

Hi

This may be due to wrong job design or code generation corruption.

Please click on 'code' tag and show us the error lines.
Or just send an email to me and attach this export job. I will fix it for you.

Regards,
Pedro

ienax_ridens · 2012-04-19 10:26:01

pedro wrote:
Hi

This may be due to wrong job design or code generation corruption.

Please click on 'code' tag and show us the error lines.
Or just send an email to me and attach this export job. I will fix it for you.

Regards,
Pedro

The code gives me the error is underlined in the attached image "Code_error.png"

Thanks a lot Pedro for help!

Uploaded Images

pedro · 2012-04-19 10:54:25

Hi

Got it.
The method RowParser() contains three kinds of parameters:BufferedReader, String, Boolean.
The data type of context variable 'ASPIAG_Personale_RowSeparator' is Integer.
You'd better change it into String.

Regards,
Pedro

ienax_ridens · 2012-04-19 11:14:39

Ok, the error is disappeared, but now, leaving row separator empty (in the context variable), job is build, but it doesn't start: it remains on "Starting" screen, nothing happens after

"Inizio job Out_CambioPuntoVendita: 11:09 19/04/2012.
[statistics] connecting to socket on port 3854
[statistics] connected

"
Run window message.

Having a positional input file, that defines row lenght by fields lenght, is it right leave empty row terminator?
Or I shoul put /n/r chars?

pedro · 2012-04-19 11:19:08

Hi

If it's a normal delimited file, just type in the default row separator "\n" and run the job again.
Do not leave row separator empty.

Regards,
Pedro

ienax_ridens · 2012-04-19 12:49:35

pedro wrote:
Hi

If it's a normal delimited file, just type in the default row separator "\n" and run the job again.
Do not leave row separator empty.

Regards,
Pedro

I've wrote a wrong thing, not Delimited, but POSITIONAL input file

ienax_ridens · 2012-04-19 12:52:58

SOLVED: I put "\n" enen in the case of Positional file

Thanks Pedro

Announcement

Unanswered posts

#1 2012-04-18 17:36:23

[resolved] URGENT - ERROR ON tFileInputPositional building job

#2 2012-04-19 03:57:52

Re: [resolved] URGENT - ERROR ON tFileInputPositional building job

#3 2012-04-19 10:26:01

Re: [resolved] URGENT - ERROR ON tFileInputPositional building job

pedro wrote:

#4 2012-04-19 10:54:25

Re: [resolved] URGENT - ERROR ON tFileInputPositional building job

#5 2012-04-19 11:14:39

Re: [resolved] URGENT - ERROR ON tFileInputPositional building job

#6 2012-04-19 11:19:08

Re: [resolved] URGENT - ERROR ON tFileInputPositional building job

#7 2012-04-19 12:49:35

Re: [resolved] URGENT - ERROR ON tFileInputPositional building job

pedro wrote:

#8 2012-04-19 12:52:58

Re: [resolved] URGENT - ERROR ON tFileInputPositional building job

Board footer