Ola pessoal, Poderiam me ajudar no erro abaixo, sabem em que local posso encontrar o erro nas minhas tabelas? Eu já fiz as chaves que constam no programa mas eu não encontro duplicidade de informação. Obrigada pela ajuda. NOTE: Mapping columns ... MPRINT(ETLS_LOADER): proc sql; MPRINT(ETLS_LOADER): create view work.W37MYOB as select DATA_REPORTE as REPORTING_DT format = DATE9. informat = DATE9., TIPO_ENTIDADE as ENTITY_ID, GRUPO_IFRS17 as INSURANCE_CONTRACT_GROUP_ID, TAG as CASHFLOW_LEG_NM, (CASE WHEN (RESSEGURO_FLG) ="Sim" THEN "Y" ELSE "N" END) as CEDED_FLG length = 1, TIPO_FLUXO as CASHFLOW_TYPE_CD length = 10, TIPO_MOEDA as CURRENCY_CD, (case when (DATA_OCORRENCIA) ne . then DATA_OCORRENCIA else 0 end) as INCURRED_CLAIM_DT length = 8 format = DATE9. informat = DATE9., DATA_VENCIMENTO_X_PAGAMENTO as CASHFLOW_DT format = DATE9. informat = DATE9., VALOR as CASHFLOW_AMT format = NLNUM18.5 informat = NLNUM18.5 from WORK.WRK_PAA_TIPO_EXECUCAO_PROD ; NOTE: SQL view WORK.W37MYOB has been defined. MPRINT(ETLS_LOADER): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 508.40k OS Memory 29856.00k Timestamp 10/27/2023 08:27:27 PM Step Count 11232 Switch Count 2 Page Faults 0 Page Reclaims 70 Page Swaps 0 Voluntary Context Switches 11 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 24 NOTE: Appending data ... MPRINT(ETLS_LOADER): proc append base = IFRSSDM.INSURANCE_CASHFLOW data = WORK.W37MYOB () force ; MPRINT(ETLS_LOADER): run; NOTE: Appending WORK.W37MYOB to IFRSSDM.INSURANCE_CASHFLOW. WARNING: Add/Update failed for data set IFRSSDM.INSURANCE_CASHFLOW because data value(s) do not comply with integrity constraint PRIM_KEY. (Occurred 6 times.)
... View more