AD (728x60)

Tecnologia do Blogger.

Followers

Total de visualizações

Archives

terça-feira, 14 de janeiro de 2014

Table unknown SISPROCXML

Dynamic SQL Error SQL error code = -204
Table 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.
Tags: , , , , ,

Postado por

Um novo sistema que auxilia técnicos da SoftPlus a executarem um trabalho mais rápido e fácil. Desenvolvido e alimentado pelos próprios técnicos.

0 comentários:

Postar um comentário

 

Mais Vistos

Adicionados Recentes

Copyright © SoftFácil | Desenvolvido por Rahel William