Error during Merge

[Anonymous]

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

[Anonymous]

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

[Anonymous]

I Initialise my connexion with a PREJOB