topic Re: Help... Error on my first job... in Talend Studio

Help... Error on my first job...

Anonymous — Mon, 13 Jul 2015 17:20:31 GMT

Hi, I'm probably the most junior of the forum and I need your help.
I made my first job to read a positional file with multiple record types,
I'm using tFileInputMSPositional, I created 3 records in the components tab and add 3 tLogRow and associate with each of the records.
When you run me the following error message and can not happen:
Starting job lsadeumen at 13:20 13/07/2015.
connecting to socket on port 3541
connected
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Syntax error on token ",", invalid Expression
Syntax error on token ",", invalid Expression
Syntax error on token ",", invalid Expression
Type mismatch: cannot convert from int to String
at test1.lsadeumen_0_1.lsadeumen.tFileInputMSPositional_1Process(lsadeumen.java:1536)
at test1.lsadeumen_0_1.lsadeumen.runJobInTOS(lsadeumen.java:2749)
at test1.lsadeumen_0_1.lsadeumen.main(lsadeumen.java:2606)
Job lsadeumen ended at 13:20 13/07/2015.

Re: Help... Error on my first job...

Anonymous — Tue, 14 Jul 2015 03:33:59 GMT

Hi,
Have you already checked component reference about: TalendHelpCenter:tFileInputMSPositional?
Did you set "Record"and in tFileInputMSPositional component? What's your component schema setting? Screenshot will be helpful for us to address your issue.
Best regards
Sabrina

Re: Help... Error on my first job...

Anonymous — Tue, 14 Jul 2015 13:58:22 GMT

Hi,
Have you already checked component reference about:TalendHelpCenter:tFileInputMSPositional?
Did you set "Record"and in tFileInputMSPositional component? What's your component schema setting? Screenshot will be helpful for us to address your issue.
Best regards
Sabrina

Sabrina Hi, thanks for your help, here some screenshots, also I attached the file that I need to validate:

lsa.deu.zip.zip

Re: Help... Error on my first job...

Anonymous — Tue, 14 Jul 2015 14:31:43 GMT

Hi,
Have you already checked component reference about:TalendHelpCenter:tFileInputMSPositional?
Did you set "Record"and in tFileInputMSPositional component? What's your component schema setting? Screenshot will be helpful for us to address your issue.
Best regards
Sabrina

Sabrina Hi, thanks for your help, here some screenshots, also I attached the file that I need to validate:

lsa.deu.zip.zip

And this is the error:
Starting job lsadeumen at 10:30 14/07/2015.
connecting to socket on port 3821
connected
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The constructor AdvancedPositionalParser_tFileInputMSPositional_1(String, int, int, int, int, int, int, boolean, boolean) is undefined
The constructor AdvancedPositionalParser_tFileInputMSPositional_1(String, int, int, int, int, int, int, int, int, int, int, int, int, int, int, int, int, int, boolean, boolean) is undefined
The constructor AdvancedPositionalParser_tFileInputMSPositional_1(String, int, int, int, int, int, int, boolean, boolean) is undefined
Type mismatch: cannot convert from int to String
at test1.lsadeumen_0_1.lsadeumen.tFileInputMSPositional_1Process(lsadeumen.java:2037)
at test1.lsadeumen_0_1.lsadeumen.runJobInTOS(lsadeumen.java:2852)
at test1.lsadeumen_0_1.lsadeumen.main(lsadeumen.java:2709)
Job lsadeumen ended at 10:30 14/07/2015.

Re: Help... Error on my first job...

Jcs19 — Tue, 14 Jul 2015 15:02:57 GMT

Your schema is wrong. You can use metadata to create your schema

Re: Help... Error on my first job...

Anonymous — Tue, 14 Jul 2015 15:29:14 GMT

Your schema is wrong. You can use metadata to create your schema

Are you sure ?...
The files that I need to read are not "delimited by character" type, either fields have a fixed structure. These are files with multiple types of positional records.

Re: Help... Error on my first job...

Jcs19 — Tue, 14 Jul 2015 15:41:33 GMT

Your schema is wrong. You can use metadata to create your schema

Are you sure ?...
The files that I need to read are not "delimited by character" type, either fields have a fixed structure. These are files with multiple types of positional records.
https://www.talendforge.org/forum/img/members/307262/mini_blob_20150714-1629.png
Yes, there are probably some errors in your schema, check it carefully
this error : " Type mismatch: cannot convert from int to String " means that you tried to must a string into an integer column

Re: Help... Error on my first job...

Anonymous — Tue, 14 Jul 2015 16:08:02 GMT

Your schema is wrong. You can use metadata to create your schema

Are you sure ?...
The files that I need to read are not "delimited by character" type, either fields have a fixed structure. These are files with multiple types of positional records.

Yes, there are probably some errors in your schema, check it carefully
this error : " Type mismatch: cannot convert from int to String " means that you tried to must a string into an integer column
That's the strange thing, as you can see in the picture, all the fields are defined as character type, which should accept all characters in the file are not doing any conversion.

Re: Help... Error on my first job...

Jcs19 — Tue, 14 Jul 2015 16:33:56 GMT

Are you sure ?...
The files that I need to read are not "delimited by character" type, either fields have a fixed structure. These are files with multiple types of positional records.

Yes, there are probably some errors in your schema, check it carefully
this error : " Type mismatch: cannot convert from int to String " means that you tried to must a string into an integer column
That's the strange thing, as you can see in the picture, all the fields are defined as character type, which should accept all characters in the file are not doing any conversion.
O wait, i'm wrong, its when you try to put an integer into a string
Can you give me a sample of your file ? You can censore all private data if you want to

Re: Help... Error on my first job...

Anonymous — Tue, 14 Jul 2015 20:19:44 GMT

Yes, there are probably some errors in your schema, check it carefully
this error : " Type mismatch: cannot convert from int to String " means that you tried to must a string into an integer column

That's the strange thing, as you can see in the picture, all the fields are defined as character type, which should accept all characters in the file are not doing any conversion.
O wait, i'm wrong, its when you try to put an integer into a string
Can you give me a sample of your file ? You can censore all private data if you want to
lsa.deu.rar.rar
http://www.sqa.cl/transferencia/lsa.deu.rar