Dynamic SQL Error SQL error code = -204Table unknown
SISPROCXML
At line 1, column 40
Execute a seguinte procedure no CTRL+ F12:
/******************************************************************************/
/* Generated by IBExpert 14/01/2014 14:38:09 */
/******************************************************************************/
/******************************************************************************/
/* Following SET SQL DIALECT is just for the Database Comparer */
/******************************************************************************/
/******************************************************************************/
/* Tables */
/******************************************************************************/
CREATE TABLE SISPROCXML (
PXEMP EMPRESA NOT NULL /* EMPRESA = INTEGER check (value is null or (value between 1 and 30000)) */,
PXECFSEQ INTEGER NOT NULL,
PXTERMINAL VARCHAR(32),
PXDATAHORA DATAHORA /* DATAHORA = DATE */
);
/******************************************************************************/
/* Primary Keys */
/******************************************************************************/
ALTER TABLE SISPROCXML ADD CONSTRAINT PK_SISPROCXML PRIMARY KEY (PXEMP, PXECFSEQ);
/******************************************************************************/
/* Triggers */
/******************************************************************************/
SET TERM ^ ;
/******************************************************************************/
/* Triggers for tables */
/******************************************************************************/
/* Trigger: SISPROCXML_ADR */
CREATE OR ALTER TRIGGER SISPROCXML_ADR FOR SISPROCXML
ACTIVE AFTER DELETE POSITION 5
AS
begin
/* Geração automatica. Não edite este trigger */
EXECUTE PROCEDURE sis_integra_logtbl( 'SISPROCXML', old.PXEMP, old.PXEMP, old.PXECFSEQ, null, null, null, null, 'D' );
end
^
/* Trigger: SISPROCXML_AIR */
CREATE OR ALTER TRIGGER SISPROCXML_AIR FOR SISPROCXML
ACTIVE AFTER INSERT POSITION 5
AS
begin
/* Geração automatica. Não edite este trigger */
EXECUTE PROCEDURE sis_integra_logtbl( 'SISPROCXML', new.PXEMP, new.PXEMP, new.PXECFSEQ, null, null, null, null, 'I' );
end
^
/* Trigger: SISPROCXML_AUR */
CREATE OR ALTER TRIGGER SISPROCXML_AUR FOR SISPROCXML
ACTIVE AFTER UPDATE POSITION 5
AS
begin
/* Geração automatica. Não edite este trigger */
EXECUTE PROCEDURE sis_integra_logtbl( 'SISPROCXML', new.PXEMP, new.PXEMP, new.PXECFSEQ, null, null, null, null, 'U' );
end
^
SET TERM ; ^
/******************************************************************************/
/* Privileges */
/******************************************************************************/
/* Privileges of users */
GRANT ALL ON SISPROCXML TO ADMGER;
GRANT ALL ON SISPROCXML TO AFERICAO;
GRANT ALL ON SISPROCXML TO CHEFE;
GRANT ALL ON SISPROCXML TO EMIXZ;
GRANT ALL ON SISPROCXML TO GET_ENC_INICIAL;
GRANT ALL ON SISPROCXML TO LEODEN;
GRANT ALL ON SISPROCXML TO LOJA;
GRANT ALL ON SISPROCXML TO MATEUS;
GRANT ALL ON SISPROCXML TO NILVA;
GRANT ALL ON SISPROCXML TO NILVA1;
GRANT ALL ON SISPROCXML TO PISTA;
GRANT ALL ON SISPROCXML TO POSTOFT;
GRANT ALL ON SISPROCXML TO PUBLIC;
GRANT ALL ON SISPROCXML TO REJANE;
GRANT ALL ON SISPROCXML TO REPLICATOR;
GRANT ALL ON SISPROCXML TO TESTE;
/* Privileges of procedures */
GRANT ALL ON SISPROCXML TO ANALISA_ABAST;
GRANT ALL ON SISPROCXML TO CXA_CRIA_AJUSTE;
GRANT ALL ON SISPROCXML TO CXA_DETALHE;
GRANT ALL ON SISPROCXML TO CXA_ENC_INICIAL;
GRANT ALL ON SISPROCXML TO CXA_GET_ENCERRANTE;
GRANT ALL ON SISPROCXML TO CXA_GRAVACXF;
GRANT ALL ON SISPROCXML TO CXA_LERVENDCOMB;
GRANT ALL ON SISPROCXML TO CXA_LERVENDPROD;
GRANT ALL ON SISPROCXML TO GET_A02ACRE_CONFIG;
GRANT ALL ON SISPROCXML TO INTEGRA_CAIXA;
GRANT ALL ON SISPROCXML TO INV_GERA;
GRANT ALL ON SISPROCXML TO LMC_VENDAS;
GRANT ALL ON SISPROCXML TO LMC_VENDAS_C;
GRANT ALL ON SISPROCXML TO LMC_VENDAS_R;
GRANT ALL ON SISPROCXML TO LMC_VENDAS_R2;
GRANT ALL ON SISPROCXML TO LMC_VENDAS_R3;
GRANT ALL ON SISPROCXML TO PONTUACLIENTES;
GRANT ALL ON SISPROCXML TO REL_EXTRATO_CONTA;
GRANT ALL ON SISPROCXML TO REL_FICHA_ESTOQUE;
GRANT ALL ON SISPROCXML TO REL_MOV_EST_DIA;
GRANT ALL ON SISPROCXML TO REL_NFCL_NFSV;
GRANT ALL ON SISPROCXML TO REL_NOTAS_COMPRAS;
GRANT ALL ON SISPROCXML TO SINTEGRA_R50;
GRANT ALL ON SISPROCXML TO SINTEGRA_R50_BASE;
GRANT ALL ON SISPROCXML TO SINTEGRA_R53;
GRANT ALL ON SISPROCXML TO SINTEGRA_R54;
GRANT ALL ON SISPROCXML TO SIS_EVERYDAY;
GRANT ALL ON SISPROCXML TO SPED_EPC_ITEM;
GRANT ALL ON SISPROCXML TO SPED_EPC_ITEM_BY_ECF;
GRANT ALL ON SISPROCXML TO SPED_MAPA_ECF;
GRANT ALL ON SISPROCXML TO SPED_REG_C100;
GRANT ALL ON SISPROCXML TO SPED_REG_C420;
GRANT ALL ON SISPROCXML TO SPED_REG_C460;
GRANT ALL ON SISPROCXML TO SPED_REG_C495;
GRANT ALL ON SISPROCXML TO VERIFICA_ABA;
Se o erro persistir, contate um facilitador.

Sped C490 - Bahia
Abastecimento Corrompido
Sintegra Reg54
Erros na versão 197
Erros na versão 198
XML em erros
Erro ao importar notas v197
List index out of bounds (3)
0 comentários:
Postar um comentário