Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-07-04 01:26 PM

[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

Labels (2)
Labels
1,027 Views
0 Likes
13 Replies
Anonymous
Not applicable
‎2017-07-04 04:54 PM
Author

Can you post screenshots and location of the error when you go to code tab?
798 Views
0 Likes
Anonymous
Not applicable
‎2017-07-04 11:55 PM
Author

Hello,

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

Best regards

Sabrina

798 Views
0 Likes
Anonymous
Not applicable
‎2017-07-05 04:02 PM
Author

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

0683p000009LvLu.png

 

img1

0683p000009LvDm.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)
798 Views
0 Likes
Anonymous
Not applicable
‎2017-07-05 04:09 PM
Author

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?

798 Views
0 Likes
Bluemoon
Creator
Creator
‎2017-07-05 04:15 PM

We can't edit code in Talend !!

 

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

798 Views
0 Likes
Anonymous
Not applicable
‎2017-07-05 04:26 PM
Author

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

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

 

798 Views
0 Likes
Bluemoon
Creator
Creator
‎2017-07-05 04:37 PM

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

798 Views
0 Likes
Anonymous
Not applicable
‎2017-07-05 04:41 PM
Author

The same problem... Nothing changed
798 Views
0 Likes
Anonymous
Not applicable
‎2017-07-05 05:52 PM
Author

I have Open Talend Data Integration 5.6.2

 

My configuration:

RAM: 4Gb

Intel 2 Core 2.93GHz

Windows Professional 7 x64

 

 

798 Views
0 Likes