Process_inv Error File
 : /storage/emulated/0/My3BC/0/errorlog 09-10-25 12:06.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', 5463, 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(), '107101', 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(16.00, '2720041', 'PÃO COM CHOURIÇO', (select art_med from art where art_ref='2720041'), 0, 0, (select art_med * 16.00 from art where art_ref='2720041'),'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, '', '2720041', 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(1.00, '2720094', 'PANIKE FOLHADO SALSICHA E FIAMBRE', (select art_med from art where art_ref='2720094'), 0, 0, (select art_med * 1.00 from art where art_ref='2720094'),'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, '', '2720094', 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());
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(69.00, '2720003', 'MINI CACETINHO', (select art_med from art where art_ref='2720003'), 0, 0, (select art_med * 69.00 from art where art_ref='2720003'),'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, 3, 0, 0.000, '', '2720003', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('3',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(74.00, '2720026', 'PÃO DE CENTEIO (BOLA) PANIKE', (select art_med from art where art_ref='2720026'), 0, 0, (select art_med * 74.00 from art where art_ref='2720026'),'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, 4, 0, 0.000, '', '2720026', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('4',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(7.00, '2720406', 'PAO DA AVO 360GR GL', (select art_med from art where art_ref='2720406'), 0, 0, (select art_med * 7.00 from art where art_ref='2720406'),'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, 5, 0, 0.000, '', '2720406', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('5',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(40.00, '2720109', 'PÃO DE ABÓBORA E NOZ  350 GR', (select art_med from art where art_ref='2720109'), 0, 0, (select art_med * 40.00 from art where art_ref='2720109'),'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, 6, 0, 0.000, '', '2720109', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('6',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(20.00, '2720117', 'BICA DE LENHA 75GR', (select art_med from art where art_ref='2720117'), 0, 0, (select art_med * 20.00 from art where art_ref='2720117'),'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, 7, 0, 0.000, '', '2720117', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('7',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(35.00, '2720277', 'BROA DE MILHO AMARELA UNID.', (select art_med from art where art_ref='2720277'), 0, 0, (select art_med * 35.00 from art where art_ref='2720277'),'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, 8, 0, 0.000, '', '2720277', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('8',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(45.00, '2720036', 'PASTEL DE NATA', (select art_med from art where art_ref='2720036'), 0, 0, (select art_med * 45.00 from art where art_ref='2720036'),'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, 9, 0, 0.000, '', '2720036', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('9',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(1.00, '2720409', 'LANCHE PANIKE', (select art_med from art where art_ref='2720409'), 0, 0, (select art_med * 1.00 from art where art_ref='2720409'),'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, 10, 0, 0.000, '', '2720409', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('10',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(50.00, '2720189', 'PÃO BOLA RUSTICA 90 GR NO.', (select art_med from art where art_ref='2720189'), 0, 0, (select art_med * 50.00 from art where art_ref='2720189'),'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, 11, 0, 0.000, '', '2720189', 0, '1900-01-01', (select cast(getdate()as date)), (select 'null'+str((select ser_num from ser where ser_chv='null'),10)+str('11',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=11, 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.