Error during Merge

Anonymous — Mon, 30 Dec 2019 11:32:52 GMT

Hello,

I would like to merge two tables.

I am using tTemplateMerge component

I just kept key and one column to update or insert.

I have this error on clearbatch :

Exception in component tSQLTemplateMerge_1 (DMT_DIM_CLIENT)
java.lang.NullPointerException

Have you an idea what's wrong with this module ?

How can i fix it ?

I create this MERGE in SQL which is ok:

MERGE INTO DMT_CLIENT PRINC
USING (
	 SELECT id_client, 
		code_type_personne
	FROM DWH_CLIENT
	WHERE scd_active = 1 ) DELTA
ON (DELTA.ID_CLIENT = PRINC.ID_CLIENT)
WHEN MATCHED THEN UPDATE SET 
		PRINC.code_type_personne = DELTA.code_type_personne
WHEN NOT MATCHED THEN INSERT (id_client, 
			code_type_personne)
                     VALUES (
			DELTA.ID_CLIENT,
			DELTA.CODE_TYPE_PERSONNE)
    ;

Thanks

Re: Error during Merge

Anonymous — Tue, 31 Dec 2019 07:20:35 GMT

Can you post a screenshot of your job? Make sure the tDB connection is created before it is used on tSQLTemplateMerge.

Re: Error during Merge

Anonymous — Thu, 02 Jan 2020 22:06:08 GMT

I Initialise my connexion with a PREJOB

topic Re: Error during Merge in Talend Studio

Error during Merge

Re: Error during Merge

Re: Error during Merge