topic Re: [Error] Duplicate parameter e in Talend Studio

[Error] Duplicate parameter e

Anonymous — Sat, 16 Nov 2024 09:33:53 GMT

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

Re: [Error] Duplicate parameter e

Anonymous — Tue, 04 Jul 2017 20:54:40 GMT

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

Re: [Error] Duplicate parameter e

Anonymous — Wed, 05 Jul 2017 03:55:24 GMT

Hello,

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

Best regards

Sabrina

Re: [Error] Duplicate parameter e

Anonymous — Wed, 05 Jul 2017 20:02:00 GMT

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

img1

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)

Re: [Error] Duplicate parameter e

Anonymous — Wed, 05 Jul 2017 20:09:28 GMT

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?

Re: [Error] Duplicate parameter e

Bluemoon — Wed, 05 Jul 2017 20:15:22 GMT

We can't edit code in Talend !!

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

Re: [Error] Duplicate parameter e

Anonymous — Wed, 05 Jul 2017 20:26:07 GMT

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...

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...

Re: [Error] Duplicate parameter e

Bluemoon — Wed, 05 Jul 2017 20:37:18 GMT

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 ??

Re: [Error] Duplicate parameter e

Anonymous — Wed, 05 Jul 2017 20:41:48 GMT

The same problem... Nothing changed

Re: [Error] Duplicate parameter e

Anonymous — Wed, 05 Jul 2017 21:52:17 GMT

I have Open Talend Data Integration 5.6.2

My configuration:

RAM: 4Gb

Intel 2 Core 2.93GHz

Windows Professional 7 x64

Re: [Error] Duplicate parameter e

Anonymous — Thu, 06 Jul 2017 04:13:07 GMT

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

Re: [Error] Duplicate parameter e

Anonymous — Thu, 06 Jul 2017 13:27:59 GMT

Hi,

I don't have a subscription.

How can I get one ?

Re: [Error] Duplicate parameter e

Anonymous — Mon, 10 Jul 2017 13:33:34 GMT

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)

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

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

Re: [Error] Duplicate parameter e

Anonymous — Tue, 11 Jul 2017 07:41:28 GMT

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