Writer step problem

gabrielf1

22-04-2020

Hello,

 

I'm trying to insert data in a custom resource with a workflow in Adobe Campaign, but I always have this problem:

 

WDB-200001 SQL statement 'INSERT INTO CusConsorcio(biConsorcioId,sCodBancoDebito,iCodCota,sCodFilial,sCodGrupo,sCodPlanoVenda,sCodSituacaoCobranca,iCodVersao,iBContatoDesignado,sDesSituacaoGrupo,tsDthAgrupamento,tsDthAssembleiaAtualGrupo,tsDthContemplacao,tsDthSituacaoCobranca,tsDthVenda,tsDthAgendamentoPagamento,tsDthContemplacaoProvavel,sHoraAssembleia,sIdeCota,sIdCliente,sIdOrgUnit,sKeyConsorcio,sNomBancoDebito,sNomBem,sNomFilialVenda,sNomPlanoVenda,sNomProduto,sNomSituacaoCobranca,sCPF_CNPJ_Consorciado,iQtdeParcelaPagar,iQtdeParcelaPaga,dVlrCreditoPendente,dVlrCreditoAtualizado,dVlrCreditoAtual,iBTitular,sTpContemplacaoProvavel,dVlrPagtosRealizados,iIsTest,iOrgUnitId,iCreatedById,tsCreated,iModifiedById,tsLastModified,iGeoUnitId,AcsId) SELECT biAutoPKey_1,COALESCE( sFld885588752, NULL),COALESCE( iFld886833937, 0),COALESCE( sFld887882514, NULL),COALESCE( sFld888668947, NULL),COALESCE( sFld889324308, NULL),COALESCE( sFld889979669, NULL),COALESCE( iFld890700566, 0),COALESCE( iFld891618071, 0),COALESCE( sFld892273432, NULL),COALESCE( tsFld893125401, NULL),COALESCE( tsFld894108442, NULL),COALESCE( tsFld894894875, NULL),COALESCE( tsFld895877916, NULL),COALESCE( tsFld896598813, NULL),COALESCE( tsFld897385246, NULL),COALESCE( tsFld898237215, NULL),COALESCE( sFld899285792, NULL),COALESCE( sFld900006704, NULL),COALESCE( sFld900662065, NULL),COALESCE( sFld901514034, NULL),COALESCE( sFld902169395, NULL),COALESCE( sFld902890292, NULL),COALESCE( sFld903742269, NULL),COALESCE( sFld913965886, NULL),COALESCE( sFld915014463, NULL),COALESCE( sFld916194112, NULL),COALESCE( sFld917046081, NULL),COALESCE( sFld917963586, NULL),COALESCE( iFld919012163, 0),COALESCE( iFld919929668, 0),COALESCE( dFld925958986,dFld929956684, 0),COALESCE( dFld925107017, 0),COALESCE( dFld924189512, 0),COALESCE( iFld922092358, 0),COALESCE( sFld922944327, NULL),COALESCE( dFld932578125, 0),COALESCE( iFld936313679, 0),COALESCE( iFld939328336, 0),10274140,GetDate(),10274140,GetDate(),1,gen_random_uuid() FROM wkf13805926_492_1 WHERE iRecProcState>:#(1)# AND iRecProcState<=:#(2)# AND COALESCE(biPKey_1,0)=0' could not be executed. Param(0)=2324 Param(1)=2325 

 

The custom resource has primary key (ID_CLIENTE + ID_ORG_UNIT + IDE_COTA, and the file not contains repeated key.

 

After error, I have many duplicated rows at the table. Could you help me, please?

 

Att.,

Gabriel

insert workflow

Accepted Solutions (0)

Answers (0)