Four Stars

[Error] Duplicate parameter e

Hi,

 

Sometimes I get this error on my jobs: "Duplicate parameter e".

 

Could someone explain to me how can I fix it ?

Which kind of error is it ?

Sometimes I just remake the job and it works. Is there something that I can do to fix it ?

 

Best Regards

  • Data Integration
13 REPLIES
Employee

Re: [Error] Duplicate parameter e

Can you post screenshots and location of the error when you go to code tab?
Moderator

Re: [Error] Duplicate parameter e

Hello,

You have a better chance if you describe your requirement and the error you are getting better.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: [Error] Duplicate parameter e

Hi,

 

I just got the error again.

Below, I show you the job (img0), the error (img1), a part of the code and the full error on console.

 

img0

img0.PNG

 

img1

img1.PNG

 

Code:

while (rs_tDBInput_1.next()) {
						nb_line_tDBInput_1++;

						if (colQtyInRs_tDBInput_1 < 1) {
							row1.COD_TIT_CALC = null;
						} else {

							try {
								tmpContent_tDBInput_1 = rs_tDBInput_1
										.getString(1);
							} catch (java.sql.SQLException e) {
								if ("No data found".equals(e.getMessage())) {
									tmpContent_tDBInput_1 = "";
								} else {
									throw e;
								}
							}
							if (tmpContent_tDBInput_1 != null) {
								row1.COD_TIT_CALC = tmpContent_tDBInput_1;
							} else {
								row1.COD_TIT_CALC = null;
							}
						}
						if (colQtyInRs_tDBInput_1 < 2) {
							row1.COD_TIT = null;
						} else {

							Object value_tDBInput_1 = rs_tDBInput_1
									.getObject(2);
							if (value_tDBInput_1 != null) {
								value_tDBInput_1 = new Integer(
										Integer.parseInt(value_tDBInput_1
												.toString()));
								row1.COD_TIT = (Integer) value_tDBInput_1;
							} else {
								row1.COD_TIT = null;
							}
						}
						if (colQtyInRs_tDBInput_1 < 3) {
							row1.TIP_CALC = null;
						} else {

							try {
								tmpContent_tDBInput_1 = rs_tDBInput_1
										.getString(3);
							} catch (java.sql.SQLException e) {
								if ("No data found".equals(e.getMessage())) {
									tmpContent_tDBInput_1 = "";
								} else {
									throw e;
								}
							}
							if (tmpContent_tDBInput_1 != null) {
								row1.TIP_CALC = tmpContent_tDBInput_1;
							} else {
								row1.TIP_CALC = null;
							}
						}

I tryed edit the code, changing "e" for "e1", "e2", .... but I couldn't edit it.

 

 

full error on console:

tarting job TITULOS_CALCULO at 15:43 05/07/2017.
[statistics] connecting to socket on port 3418
[statistics] connected
Exception in thread "main" java.lang.Error: Problemas de compilação não resolvidos: 
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e
	Duplicar parâmetro e

	at bi.titulos_calculo_0_1.TITULOS_CALCULO.tDBInput_1Process(TITULOS_CALCULO.java:32388)
	at bi.titulos_calculo_0_1.TITULOS_CALCULO.runJobInTOS(TITULOS_CALCULO.java:54442)
	at bi.titulos_calculo_0_1.TITULOS_CALCULO.main(TITULOS_CALCULO.java:53924)
Employee

Re: [Error] Duplicate parameter e

Hi,

 

I will recommend you raise a support ticket for this.  I have never come across this.  It may be a specific situation with the components causing this issue.  What do you have in your tJavaRow as code?  Also what are the expressions in you tMap?  Any chance the code you wrote is missing a () or a {} and throwing it up into some other error about duplicate parameter?

Five Stars

Re: [Error] Duplicate parameter e

We can't edit code in Talend !!

 

Check any primary key duplicate are inserted while merging all your data sources. 

Four Stars

Re: [Error] Duplicate parameter e

Hi,

 

How can I open a support ticket ?

 

In my tJavaRow, I have nothing

//Code generate according to input schema and output schema
output_row.COD_BASE = input_row.COD_BASE;
output_row.COD_TIT_CALC = input_row.COD_TIT_CALC;
output_row.COD_TIT = input_row.COD_TIT;
output_row.TIP_CALC = input_row.TIP_CALC;
output_row.COND_PARC = input_row.COND_PARC;
output_row.QTD_PARC = input_row.QTD_PARC;
output_row.VALOR_PARC = input_row.VALOR_PARC;
output_row.DATA_CAD = input_row.DATA_CAD;
output_row.USUARIO_CAD = input_row.USUARIO_CAD;
output_row.DATA_CALC = input_row.DATA_CALC;
output_row.PRIM_VCTO = input_row.PRIM_VCTO;
output_row.VR_ENTRADA = input_row.VR_ENTRADA;
output_row.COD_DEV = input_row.COD_DEV;
output_row.PER_DES = input_row.PER_DES;
output_row.TIP_DES = input_row.TIP_DES;
output_row.TOTAL_ORIGINAL = input_row.TOTAL_ORIGINAL;
output_row.TOTAL_MULTA = input_row.TOTAL_MULTA;
output_row.TOTAL_JUROS = input_row.TOTAL_JUROS;
output_row.TOTAL_DESCONTO = input_row.TOTAL_DESCONTO;
output_row.TOTAL_FINAL = input_row.TOTAL_FINAL;
output_row.QTDE_PARC_BONUS = input_row.QTDE_PARC_BONUS;
output_row.COD_BARRA = input_row.COD_BARRA;
output_row.TOTAL_TAXA = input_row.TOTAL_TAXA;
output_row.OBS_CALC = input_row.OBS_CALC;
output_row.COD_TIT_CALC_BLOCO = input_row.COD_TIT_CALC_BLOCO;
output_row.CANCELADO_CALC = input_row.CANCELADO_CALC;
output_row.CAMPANHA_CALC = input_row.CAMPANHA_CALC;
output_row.FATOR_PARC = input_row.FATOR_PARC;
output_row.DESP_CALC = input_row.DESP_CALC;
output_row.RECEITA_CALC = input_row.RECEITA_CALC;
output_row.PER_RECEITA_CALC = input_row.PER_RECEITA_CALC;
output_row.ENTRADA_LIVRE_CALC = input_row.ENTRADA_LIVRE_CALC;
output_row.VALOR1 = input_row.VALOR1;
output_row.VALOR2 = input_row.VALOR2;
output_row.VALOR3 = input_row.VALOR3;
output_row.VALOR4 = input_row.VALOR4;
output_row.VALOR5 = input_row.VALOR5;
output_row.VALOR6 = input_row.VALOR6;
output_row.PERIODIC_PARCELAMENTO = input_row.PERIODIC_PARCELAMENTO;
output_row.COD_AUTORIZ = input_row.COD_AUTORIZ;
output_row.LINHA_DIGITAVEL = input_row.LINHA_DIGITAVEL;
output_row.PERC_CET_ANUAL = input_row.PERC_CET_ANUAL;
output_row.PERC_CET_MENSAL = input_row.PERC_CET_MENSAL;
output_row.COD_STATUS = input_row.COD_STATUS;
output_row.DATA_APROV = input_row.DATA_APROV;
output_row.DATA_SOLIC = input_row.DATA_SOLIC;
output_row.CALC_PARCIAL = input_row.CALC_PARCIAL;
output_row.BLOQUEIA_ABERTURA = input_row.BLOQUEIA_ABERTURA;
output_row.USU_AUTORIZ = input_row.USU_AUTORIZ;
output_row.COD_FONE = input_row.COD_FONE;
output_row.COD_IMP = input_row.COD_IMP;
output_row.COD_TIT_CALC_ORIGEM = input_row.COD_TIT_CALC_ORIGEM;
output_row.AUTORIZANTE = input_row.AUTORIZANTE;
output_row.ACORDO_NOS_AUTOS = input_row.ACORDO_NOS_AUTOS;
output_row.DATA_APROV_AUTORIZ = input_row.DATA_APROV_AUTORIZ;
output_row.ID_PARAMETRO_ACORDO = input_row.ID_PARAMETRO_ACORDO;
output_row.VALOR7 = input_row.VALOR7;
output_row.VALOR8 = input_row.VALOR8;
output_row.COD_MEIO = input_row.COD_MEIO;
output_row.COD_FPARC_CRED = input_row.COD_FPARC_CRED;
output_row.VALOR9 = input_row.VALOR9;
output_row.VALOR10 = input_row.VALOR10;
output_row.VALOR11 = input_row.VALOR11;
output_row.VALOR12 = input_row.VALOR12;
output_row.VALOR13 = input_row.VALOR13;
output_row.VALOR14 = input_row.VALOR14;
output_row.VALOR15 = input_row.VALOR15;
output_row.DATA_LIMITE_CALC = input_row.DATA_LIMITE_CALC;
output_row.JUSTIFICATIVA_APRO_CALC = input_row.JUSTIFICATIVA_APRO_CALC;
output_row.DT_ULT_VCTO = input_row.DT_ULT_VCTO;
output_row.CHAVE_LIGACAO = input_row.CHAVE_LIGACAO;
output_row.JUSTIFICATIVA_STATUS_CALC = input_row.JUSTIFICATIVA_STATUS_CALC;
output_row.VALOR16 = input_row.VALOR16;
output_row.DATA_ACORDO = input_row.DATA_ACORDO;
output_row.VALOR17 = input_row.VALOR17;
output_row.VALOR18 = input_row.VALOR18;
output_row.VALOR19 = input_row.VALOR19;
output_row.VALOR20 = input_row.VALOR20;
output_row.FILIAL = input_row.FILIAL;

 

Anything on my tMap too...

img2.PNG

 

 

About missing code, I haven't wrotten anything yet. The issue on code was generated by Talend. Look it:

if (colQtyInRs_tDBInput_1 < 1) {
							row1.COD_TIT_CALC = null;
						} else {

							try {
								tmpContent_tDBInput_1 = rs_tDBInput_1
										.getString(1);
		//ERROR HERE					} catch (java.sql.SQLException e) {
								if ("No data found".equals(e.getMessage())) {
									tmpContent_tDBInput_1 = "";
								} else {
									throw e;
								}
							}
							if (tmpContent_tDBInput_1 != null) {
								row1.COD_TIT_CALC = tmpContent_tDBInput_1;
							} else {
								row1.COD_TIT_CALC = null;
							}
						}
						if (colQtyInRs_tDBInput_1 < 2) {
							row1.COD_TIT = null;
						} else {

							Object value_tDBInput_1 = rs_tDBInput_1
									.getObject(2);
							if (value_tDBInput_1 != null) {
								value_tDBInput_1 = new Integer(
										Integer.parseInt(value_tDBInput_1
												.toString()));
								row1.COD_TIT = (Integer) value_tDBInput_1;
							} else {
								row1.COD_TIT = null;
							}
						}
						if (colQtyInRs_tDBInput_1 < 3) {
							row1.TIP_CALC = null;
						} else {

							try {
								tmpContent_tDBInput_1 = rs_tDBInput_1
										.getString(3);
				//ERROR HERE			} catch (java.sql.SQLException e) {
								if ("No data found".equals(e.getMessage())) {
									tmpContent_tDBInput_1 = "";
								} else {
									throw e;
								}
							}
							if (tmpContent_tDBInput_1 != null) {
								row1.TIP_CALC = tmpContent_tDBInput_1;
							} else {
								row1.TIP_CALC = null;
							}
						}

As you can see, the code was created by Talend. It's a native code...

 

Five Stars

Re: [Error] Duplicate parameter e

can you try by removing primary key for the table schema and (select drop if exist and create the table) ?? And let me know that happened ??

Four Stars

Re: [Error] Duplicate parameter e

The same problem... Nothing changed
Four Stars

Re: [Error] Duplicate parameter e

I have Open Talend Data Integration 5.6.2

 

My configuration:

RAM: 4Gb

Intel 2 Core 2.93GHz

Windows Professional 7 x64

 

 

Moderator

Re: [Error] Duplicate parameter e

Hi,

Are you using talend subscription solution Talend Data Integration 5.6.2? If so, you can create a case on talend support portal.

https://login.talend.com/support-login.php

In this way, we can give you a remote assistance(webex) through support cycle with priority.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: [Error] Duplicate parameter e

Hi,

 

I don't have a subscription.

How can I get one ?

Four Stars

Re: [Error] Duplicate parameter e

Hi,

 

xdshi explain me one thing...

 

Can my processor (speed and model) be the reason of the error ?

And my RAM memory ?

 

I changed my job flux (as below) and it worked. Look, i didn't change almost anything, I just broken my flux in little jobs.

 

BEFORE - In the beginning I was trying to access the database, do a select on differents databases, join it on a union component and then insert in another database (mysql)

before.PNG

 

AFTER - Now, I continue connecting on 8 databases, but I'm exporting it to txt. After it, I read all of the 8 txt file and do a union, inseriting it on mysql database

after.PNG

 

As you can see, I didn't change the final result, only the way that I can reach it.

 

Where Can I read about Talend architecture ? When i click on "run", what Talend keep in memory (RAM) before start to run in fact ?

 

Best Regards

Moderator

Re: [Error] Duplicate parameter e

Hi,

With Talend Open Studio for Data Integration V 5.6.1, please refer to online documents about:TalendHelpCenter:Installation requirements and TalendHelpCenter:Compatible Platforms and Java environments.

 

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.