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
BedrockMission!

Learn More

View all

Sign in to view all badges

Writer step problem

Avatar

Avatar
Validate 1
Level 1
gabrielf1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Applaud 5
View profile

Avatar
Validate 1
Level 1
gabrielf1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Give Back
Applaud 5
View profile
gabrielf1
Level 1

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)