Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Who Me Too'd this topic

gabrielf1
Level 2
Level 2

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

Who Me Too'd this topic