Problema na atualização da View Materializada
Prezados,
Tenho uma View Materializada com o código abaixo, a principio ela compila perfeitamente, porem após algum período ela aparece com um X vermelho e não atualiza os dados.
Isso já ocorreu com alguém? Alguém consegue visualizar algo de errado?
CREATE MATERIALIZED VIEW "SAPIENS"."USU_MVINVCOM"
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SENIOR_DAD"
BUILD IMMEDIATE
USING INDEX
REFRESH COMPLETE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE
/******************Contas a Pagar**********************************************/
AS SELECT e501rat.codemp,
e501rat.datbas mescom,
e501rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr tipctr,
usu_t003tco.usu_intext intext,
e501rat.numtit NUMORI,
'Fornecedor' codcft,
e501rat.codfor
|| ' - '
|| e095for.nomfor descft,
e501rat.codfpj,
e501rat.ctafin,
e091plf.descta,
e091plf.natfin,
e501rat.codccu,
e044ccu.desccu,
e044ccu.tipccu,
SUM(CASE e501rat.somsub
WHEN 1 THEN e501rat.vlrrat
WHEN 4 THEN e501rat.vlrrat * -1
END) *- 1 valor
FROM e501rat,
e095for,
e615prj,
e044ccu,
e091plf,
usu_t003tco
WHERE e501rat.codfor = e095for.codfor
AND e501rat.codemp = e615prj.codemp
AND e501rat.numprj = e615prj.numprj
AND e501rat.codemp = e044ccu.codemp
AND e501rat.codccu = e044ccu.codccu
AND e501rat.codemp = e091plf.codemp
AND e501rat.ctafin = e091plf.ctafin
AND e615prj.codemp = usu_t003tco.usu_codemp
AND e615prj.usu_tipctr = usu_t003tco.usu_tipctr
AND e501rat.somsub IN ( 1, 4 )
GROUP BY e501rat.codemp,
e501rat.datbas,
e501rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr,
usu_t003tco.usu_intext,
e501rat.numtit,
e501rat.codfor
|| ' - '
|| e095for.nomfor,
e501rat.codfpj,
e501rat.ctafin,
e091plf.descta,
e091plf.natfin,
e501rat.codccu,
e044ccu.desccu,
e044ccu.tipccu
UNION
/******************Contas a Receitas*******************************************/
SELECT e301rat.codemp,
e301tcr.datent mescom,
e301rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr tipctr,
usu_t003tco.usu_intext intext,
e301rat.numtit NUMORI,
'Cliente' codcft,
e301tcr.codcli
|| ' - '
|| e085cli.nomcli descft,
e301rat.codfpj,
e301rat.ctafin,
e091plf.descta,
e091plf.natfin,
e301rat.codccu,
e044ccu.desccu,
e044ccu.tipccu,
SUM(CASE e301rat.somsub
WHEN 1 THEN e301rat.vlrrat
WHEN 4 THEN e301rat.vlrrat * -1
END) valor
FROM e301tcr,
e301rat,
e085cli,
e615prj,
e044ccu,
e091plf,
usu_t003tco
WHERE e301rat.codemp = e301tcr.codemp
AND e301rat.codfil = e301tcr.codfil
AND e301rat.numtit = e301tcr.numtit
AND e301rat.codtpt = e301tcr.codtpt
AND e301tcr.codcli = e085cli.codcli
AND e301rat.codemp = e615prj.codemp
AND e301rat.numprj = e615prj.numprj
AND e301rat.codemp = e044ccu.codemp
AND e301rat.codccu = e044ccu.codccu
AND e301rat.codemp = e091plf.codemp
AND e301rat.ctafin = e091plf.ctafin
AND e615prj.codemp = usu_t003tco.usu_codemp
AND e615prj.usu_tipctr = usu_t003tco.usu_tipctr
AND e301rat.somsub IN ( 1, 4 )
GROUP BY e301rat.codemp,
e301tcr.datent,
e301rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr,
usu_t003tco.usu_intext,
e301rat.numtit,
e301tcr.codcli,
e085cli.nomcli,
e301rat.codfpj,
e301rat.ctafin,
e091plf.descta,
e091plf.natfin,
e301rat.codccu,
e044ccu.desccu,
e044ccu.tipccu;
COMMENT ON MATERIALIZED VIEW "SAPIENS"."USU_MVINVCOM" IS 'snapshot table for snapshot SAPIENS.USU_MVINVCOM';
Tenho uma View Materializada com o código abaixo, a principio ela compila perfeitamente, porem após algum período ela aparece com um X vermelho e não atualiza os dados.
Isso já ocorreu com alguém? Alguém consegue visualizar algo de errado?
CREATE MATERIALIZED VIEW "SAPIENS"."USU_MVINVCOM"
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "SENIOR_DAD"
BUILD IMMEDIATE
USING INDEX
REFRESH COMPLETE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE
/******************Contas a Pagar**********************************************/
AS SELECT e501rat.codemp,
e501rat.datbas mescom,
e501rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr tipctr,
usu_t003tco.usu_intext intext,
e501rat.numtit NUMORI,
'Fornecedor' codcft,
e501rat.codfor
|| ' - '
|| e095for.nomfor descft,
e501rat.codfpj,
e501rat.ctafin,
e091plf.descta,
e091plf.natfin,
e501rat.codccu,
e044ccu.desccu,
e044ccu.tipccu,
SUM(CASE e501rat.somsub
WHEN 1 THEN e501rat.vlrrat
WHEN 4 THEN e501rat.vlrrat * -1
END) *- 1 valor
FROM e501rat,
e095for,
e615prj,
e044ccu,
e091plf,
usu_t003tco
WHERE e501rat.codfor = e095for.codfor
AND e501rat.codemp = e615prj.codemp
AND e501rat.numprj = e615prj.numprj
AND e501rat.codemp = e044ccu.codemp
AND e501rat.codccu = e044ccu.codccu
AND e501rat.codemp = e091plf.codemp
AND e501rat.ctafin = e091plf.ctafin
AND e615prj.codemp = usu_t003tco.usu_codemp
AND e615prj.usu_tipctr = usu_t003tco.usu_tipctr
AND e501rat.somsub IN ( 1, 4 )
GROUP BY e501rat.codemp,
e501rat.datbas,
e501rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr,
usu_t003tco.usu_intext,
e501rat.numtit,
e501rat.codfor
|| ' - '
|| e095for.nomfor,
e501rat.codfpj,
e501rat.ctafin,
e091plf.descta,
e091plf.natfin,
e501rat.codccu,
e044ccu.desccu,
e044ccu.tipccu
UNION
/******************Contas a Receitas*******************************************/
SELECT e301rat.codemp,
e301tcr.datent mescom,
e301rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr tipctr,
usu_t003tco.usu_intext intext,
e301rat.numtit NUMORI,
'Cliente' codcft,
e301tcr.codcli
|| ' - '
|| e085cli.nomcli descft,
e301rat.codfpj,
e301rat.ctafin,
e091plf.descta,
e091plf.natfin,
e301rat.codccu,
e044ccu.desccu,
e044ccu.tipccu,
SUM(CASE e301rat.somsub
WHEN 1 THEN e301rat.vlrrat
WHEN 4 THEN e301rat.vlrrat * -1
END) valor
FROM e301tcr,
e301rat,
e085cli,
e615prj,
e044ccu,
e091plf,
usu_t003tco
WHERE e301rat.codemp = e301tcr.codemp
AND e301rat.codfil = e301tcr.codfil
AND e301rat.numtit = e301tcr.numtit
AND e301rat.codtpt = e301tcr.codtpt
AND e301tcr.codcli = e085cli.codcli
AND e301rat.codemp = e615prj.codemp
AND e301rat.numprj = e615prj.numprj
AND e301rat.codemp = e044ccu.codemp
AND e301rat.codccu = e044ccu.codccu
AND e301rat.codemp = e091plf.codemp
AND e301rat.ctafin = e091plf.ctafin
AND e615prj.codemp = usu_t003tco.usu_codemp
AND e615prj.usu_tipctr = usu_t003tco.usu_tipctr
AND e301rat.somsub IN ( 1, 4 )
GROUP BY e301rat.codemp,
e301tcr.datent,
e301rat.numprj,
e615prj.nomprj,
e615prj.usu_tipctr,
usu_t003tco.usu_intext,
e301rat.numtit,
e301tcr.codcli,
e085cli.nomcli,
e301rat.codfpj,
e301rat.ctafin,
e091plf.descta,
e091plf.natfin,
e301rat.codccu,
e044ccu.desccu,
e044ccu.tipccu;
COMMENT ON MATERIALIZED VIEW "SAPIENS"."USU_MVINVCOM" IS 'snapshot table for snapshot SAPIENS.USU_MVINVCOM';
Ramon Camargos
Curtidas 0