•O módulo DocSearch NFCe pode ser instalado separadamente dos outros módulos do sistema NFCe, porém deve possuir acesso ao Banco de Dados do Connector. •No Servidor das Instâncias do Eletronic e do Connector Settings devem possuir o registro "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services" com a chave "NDDigitalNFCeDocSearchService" e a cadeia de caracteres "ImagePath" com o caminho onde se encontra o arquivo de configuração. Ex: "C:\Program Files\NDDigital\eForms_NFCe\Doc Search" (automáticamente criado pelo instalador do DocSearch). •Segue link para montar o arquivo de configuração: Configuração DocSearch NFCe |
Para versão 4.8.6.0 Patch 85559 e a versão 4.8.9.0 Patch 85681 deve ser executado manualmente os Scripts abaixo: |
•SQL |
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TBDOCSEARCHNFCE]') AND type in (N'U')) BEGIN CREATE TABLE [TBDOCSEARCHNFCE]( [PROTOCOLID] [bigint] IDENTITY(1,1) NOT NULL, [GROUPID] [int] NOT NULL, [IDENTIFY] [varchar](50) NOT NULL, [HEADERIN] [varchar](max) NULL, [MESSAGEIN] [varchar](max) NULL, [MESSAGEOUT] [varchar](max) NULL, [STATUS] [tinyint] NULL, [CREATED] [datetime] NOT NULL, CONSTRAINT [PK_TBDOCSEARCHNFCE] PRIMARY KEY CLUSTERED ( [PROTOCOLID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [eFormsVolatileData] ) ON [eFormsVolatileData] TEXTIMAGE_ON [eFormsVolatileData] END
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TBDOCSEARCHNFE]') AND type in (N'U')) BEGIN DROP TABLE TBDOCSEARCHNFE END
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TBDOCSEARCHCTE]') AND type in (N'U')) BEGIN DROP TABLE TBDOCSEARCHCTE END
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TBDOCSEARCHMDFE]') AND type in (N'U')) BEGIN DROP TABLE TBDOCSEARCHMDFE END
|
•ORACLE |
BEGIN EXECUTE immediate 'drop trigger ""TBDOCSEARCHNFE_BI""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop trigger ""TBDOCSEARCHCTE_BI""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop trigger ""TBDOCSEARCHMDFE_BI""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop table ""TBDOCSEARCHNFE""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop table ""TBDOCSEARCHCTE""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop table ""TBDOCSEARCHMDFE""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop sequence ""TBDOCSEARCHNFE_SEQ""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop sequence ""TBDOCSEARCHCTE_SEQ""';EXCEPTION WHEN OTHERS THEN NULL;END; BEGIN EXECUTE immediate 'drop sequence ""TBDOCSEARCHMDFE_SEQ""';EXCEPTION WHEN OTHERS THEN NULL;END;
declare v_table_exists number := 0; begin select count(*) into v_table_exists from all_objects where object_type in ('TABLE','VIEW') and object_name = 'TBDOCSEARCHNFCE'; if (v_table_exists = 0) then execute immediate 'CREATE TABLE TBDOCSEARCHNFCE( PROTOCOLID number(20,0) NOT NULL ENABLE, GROUPID number(4,0) NOT NULL ENABLE, IDENTIFY varchar2(50) NOT NULL ENABLE, HEADERIN CLOB NOT NULL, MESSAGEIN CLOB NOT NULL, MESSAGEOUT CLOB, STATUS NUMBER(10,0) NULL, CREATED TIMESTAMP (6) NOT NULL ENABLE, CONSTRAINT PK_TBDOCSEARCHNFCE PRIMARY KEY (PROTOCOLID) ENABLE)'; END IF; end; declare v_sequence_exists number := 0; begin SELECT COUNT(*) into v_sequence_exists FROM all_sequences WHERE sequence_name = 'TBDOCSEARCHNFCE_SEQ'; if (v_sequence_exists = 0) then execute immediate 'CREATE SEQUENCE TBDOCSEARCHNFCE_SEQ MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1'; END IF; end;
CREATE OR REPLACE TRIGGER TBDOCSEARCHNFCE_BI BEFORE INSERT ON TBDOCSEARCHNFCE FOR EACH ROW WHEN (new.ID IS NULL) BEGIN SELECT TBDOCSEARCHNFCE_SEQ.NEXTVAL INTO :new.PROTOCOLID FROM dual; END;
ALTER TRIGGER TBDOCSEARCHNFCE_BI ENABLE;
|