When i execute a delivery (recurring delivery which creates a .csv file to be extracted later) i get the following error:
|xt_W0.sCOMMUNICATION,Ext_W0.sPROPOSITION,Ext_W0.sDATA_ENRICHMENT,Ext_W0.sAPPT_TYPE,Ext_W0.sDIALER_RULES,Ext_W0.sDISCOUNT,Src_W0.iTargetDataId FROM wkf152336354_3990 AS Ext_W0 INNER JOIN wkf152336354_4032_1_ALL AS Src_W0 ON ()' could not be executed.|
|,sCOMMUNICATION,sPROPOSITION,sDATA_ENRICHMENT,sAPPT_TYPE,sDIALER_RULES,sDISCOUNT,iTargetDataId ) SELECT Ext_W0.iLineNum,Ext_W0.sPROGRAM,Ext_W0.sPROGRAM_INTERNAL_NAME,Ext_W0.sMACRO_,Ext_W0.sMICRO,Ext_W0.sJOURNEY,Ext_W0.sDELIVERY_NAME,Ext_W0.sLIST_CODE,Ext|
|WDB-200001 SQL statement 'INSERT INTO wkf152336354_4032_2_ALL(iLineNum,sPROGRAM,sPROGRAM_INTERNAL_NAME,sMACRO_,sMICRO,sJOURNEY,sDELIVERY_NAME,sLIST_CODE,sON_OFF,iLAST_APPT_SHOW,iLAST_INTERACTION_,iFUTURE_APPT,iLAST_CRM_CONTACT,iLAST_CRM_UC_CONTACT,iLAST_|
|PGS-220000 PostgreSQL error: ERROR: syntax error at or near ")" LINE 1: ...AS Ext_W0 INNER JOIN wkf152336354_4069_1_ALL AS Src_W0 ON () ^ .|
All the field names that appear in the error message are attached with enrichment activity (create a link to a file uploaded and then attach useful columns).
If i execute the same delivery before the enrichment activity i don't get any error.
Anybody knows the cause?
The error message you pasted is showing a missing join key btwn 2 temp tables.
Is the join condition filled out in the enrichment (Edit data -> Simple join tab at the bottom)?
Thank you very much for your answer.
I solved the problem changing 'join conditions'.
When i got this error i used in the enrichment activity advanced join conditions (first picture), then i changed using simple join conditions (using the same logic) and all worked correctly (second picture).
Do you know which was the problem?
I would like to understand the cause in order to avoid this issue in future
Unclear from pic. One of the sides needs to be [joinTarget/...] for it to work.
I just tried same (join 2 temp tables with advanced join) in a sandbox env and it ran fine fwiw.