Process_inv Error File
 : /storage/emulated/0/My3BC/0/errorlog 10-01-26 15:47.txt: open failed: EPERM (Operation not permitted)
M,DAD_ENT,DAD_DAT,DAD_TP1,DAD_TP2,DAD_VL1,DAD_VL2,DAD_DSC,DAD_TOT,DAD_DEB,DAD_CRE,DAD_TDD,DAD_IVA,DAD_TTI,DAD_CRG,DAD_DES,DAD_EXP,DAD_HRC,DAD_DTC,DAD_PDO,DAD_PGO,DAD_VNC,DAD_MOV,DAD_ACM,DAD_UTL,DAD_TER,DAD_LOJ,DAD_RET,DAD_VEN,DAD_COM,DAD_MCA,DAD_REQ,DAD_ENC,ESTADO,DAD_ORI,DAD_BAL,DAD_MEM,DAD_OBS,DAD_CUA,DAD_FTC,DAD_TEM,DAD_ULT,DAD_DOC,DAD_FIL,DAD_SES,DAD_UT2,DAD_MXL,DAD_TP3,DAD_TP4,DAD_VL3,DAD_VL4,DAD_CON,DAD_DMO,DAD_PNT,DAD_CAR,DAD_CHV,DAD_CNV,DAD_DCA,DAD_VER,DAD_RSA,DAD_DER,DAD_MOT,DAD_VGT,DAD_TOT2,DAD_NOM,DAD_MOR,DAD_CDP,dad_tdcacm,DAD_loc,dad_pai,dad_APL)
VALUES('null', (select ser_num from ser where ser_chv='null'), 0,
(select cast(getdate()as date)), 0, 0, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, (select tdc_dcr from tdc where tdc_cod= substring('null',1,2)), 0.000, 0.000,
'', '', '', (SELECT CAST(DATEPART(HOUR,   GETDATE())AS VARCHAR(2)) + ':' +
CAST(DATEPART(MINUTE, GETDATE())AS VARCHAR(2))), (select cast(getdate()as date)), 1, 0.000, (select cast(getdate()as date)), '0',
 'S', 5438, 99, 0, 0.000, 0, 0, 0.00, '', '', 9, '',  0, '', '', 0.00, 0,(SELECT CAST(DATEPART(HOUR,   GETDATE())AS VARCHAR(2)) + ':' + CAST(DATEPART(MINUTE, GETDATE())AS VARCHAR(2)) + ':' + CAST(DATEPART(SECOND, GETDATE())AS VARCHAR(2))),
 getdate(), '6100126', 0, 0, 0, 0, 0, 0, 0.00, 0.00, '',
 '1900-01-01', 0, 0.00, 'null' + str((select ser_num from ser where ser_chv='null'),10),
 0, 0.00, 0, '', getdate(), '', '',0, '', '', '', 0, '', 'PT', '');

DELETE FROM LIN WHERE LIN_DAD= (select 'null'+(select str((select ser_num from ser where ser_chv='null'),10)));
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(5.00, '8000920577905', 'CORNETTO CHOC. OLA 6 UNI', (select art_med from art where art_ref='8000920577905'), 0, 0, (select art_med * 5.00 from art where art_ref='8000920577905'),'null', (select ser_num from ser where ser_chv='null'), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 1, 0, 0.000, '', '8000920577905', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('1',6)), (select 'null'+(select str((select ser_num from ser where ser_chv='null'),10))), 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '8714100572634', 'GELADO MAGNUM:BOMBONIERA 140ML', (select art_med from art where art_ref='8714100572634'), 0, 0, (select art_med * 4.00 from art where art_ref='8714100572634'),'null', (select ser_num from ser where ser_chv='null'), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 2, 0, 0.000, '', '8714100572634', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('2',6)), (select 'null'+(select str((select ser_num from ser where ser_chv='null'),10))), 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());

UPDATE DAD SET DAD_MXL=2, DAD_ULT=getdate(), ESTADO=9 WHERE DAD_CHV='null' + str((select ser_num from ser where ser_chv='null'),10);
 commit transaction : Cannot insert the value NULL into column 'DAD_CHV', table 'emp01_dados.dbo.dad'; column does not allow nulls. INSERT fails.