08/05/2021 19:44:34  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->activo MÉTODO->uf_saf_insert_activo ERROR->Invalid query: ERROR:  column "esptec" of relation "saf_activo" does not exist
LINE 2:                codforadq, esptec, otrasesp, codestuso, 
                                  ^
Whole query: INSERT INTO saf_activo (codemp,codact,denact,maract,modact,fecregact,feccmpact,codconbie,spg_cuenta_act,esttipinm,                        catalogo,costo,estdepact,obsact,fotact,codpai,codest,codmun,cod_pro,nompro,numordcom,monordcom,codfuefin,                        numsolpag,fecemisol,codsitcon,codconcom,codgru,codsubgru,codsec,codite, tipinm,codcat,
				  						   codforadq, esptec, otrasesp, codestuso, 
										   codcolor, codusoedi, codaseg, codtipcob, codtiplug, codcatuni, 
										   comp, tienecomp, esvehiculo, tiempogaran, codunimedgar, codtipveh, 
										   codmarca, codmodelo, serialcar, serialmot, sigplaca, nrotitprop, 
										   capacidad, codunimedcap, sisrastreo, espsisrast, anofabveh, codtipani, 
										   codprosem, codraza, codgenero, peso, codunimedpeso, nrohierro, 
										   fecnacsem, senas, urbaniza, calleave, casaedif, oficregistro, 
										   refregistro, tomo, folio, protocoloreg, nroregistro, fecregistro, 
										   propanterior, areaconst, codunimedarea, codori
				  
				  )VALUES( '0001','000000000000001','ACTIVO DE PRUEBA','HP','PAVILION','2021-05-08',        '2019-05-08','01','404090200','1','20020-0007',30000000.00,        '1','  ','','','','','',        '','',0.00,'','','1900-01-01',        '','01','---','---','---','---','','-----',
				  		   '----','','','',
						   '','','','','','',
						   '0','0','0','0.00','','',
						   '','','','','','',
						   '0.00','','0','','','',
						   '','','','0.00','','',
						   '1900-01-01','','','','','',
						   '','','','','','1900-01-01',
						   '','0.00','','------------'						   
				  
				  )

08/05/2021 19:47:59  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_36_2015 ERROR->Invalid query: ERROR:  column "codestuso" of relation "saf_activo" already exists
Whole query: 			   				
							ALTER TABLE saf_activo ADD COLUMN codforadq character varying(4);
							ALTER TABLE saf_activo ADD COLUMN esptec text;
							ALTER TABLE saf_activo ADD COLUMN otrasesp text;
							ALTER TABLE saf_activo ADD COLUMN codestuso character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codcolor character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codusoedi character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codaseg character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtipcob character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtiplug character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codcatuni character varying(4);
							ALTER TABLE saf_activo ADD COLUMN comp character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN tienecomp character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN esvehiculo character varying(1) DEFAULT '0';														
							ALTER TABLE saf_activo ADD COLUMN tiempogaran double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedgar character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtipveh character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codmarca character varying(10);
							ALTER TABLE saf_activo ADD COLUMN codmodelo character varying(10);
							ALTER TABLE saf_activo ADD COLUMN serialcar character varying(128);
							ALTER TABLE saf_activo ADD COLUMN serialmot character varying(128);
							ALTER TABLE saf_activo ADD COLUMN sigplaca character varying(128);
							ALTER TABLE saf_activo ADD COLUMN nrotitprop character varying(128);
							ALTER TABLE saf_activo ADD COLUMN capacidad double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedcap character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN sisrastreo character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN espsisrast text;
							ALTER TABLE saf_activo ADD COLUMN anofabveh character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN codtipani character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codprosem character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codraza character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codgenero character varying(4);
							ALTER TABLE saf_activo ADD COLUMN peso character varying(10);
							ALTER TABLE saf_activo ADD COLUMN codunimedpeso character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN nrohierro character varying(50);
							ALTER TABLE saf_activo ADD COLUMN fecnacsem date DEFAULT NULL;
							ALTER TABLE saf_activo ADD COLUMN senas text;
							ALTER TABLE saf_activo ADD COLUMN urbaniza text;
							ALTER TABLE saf_activo ADD COLUMN calleave text;
							ALTER TABLE saf_activo ADD COLUMN casaedif text;
							ALTER TABLE saf_activo ADD COLUMN oficregistro text;
							ALTER TABLE saf_activo ADD COLUMN refregistro text;
							ALTER TABLE saf_activo ADD COLUMN tomo character varying(50);
							ALTER TABLE saf_activo ADD COLUMN folio character varying(50);
							ALTER TABLE saf_activo ADD COLUMN protocoloreg character varying(50);
							ALTER TABLE saf_activo ADD COLUMN nroregistro character varying(50);
							ALTER TABLE saf_activo ADD COLUMN fecregistro date DEFAULT NULL;
							ALTER TABLE saf_activo ADD COLUMN propanterior text;
							ALTER TABLE saf_activo ADD COLUMN areaconst double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedarea character varying(4); 
							
						

08/05/2021 19:49:09  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_36_2015 ERROR->Invalid query: ERROR:  column "codtipcob" of relation "saf_activo" already exists
Whole query: 			   				
							ALTER TABLE saf_activo ADD COLUMN codforadq character varying(4);
							ALTER TABLE saf_activo ADD COLUMN esptec text;
							ALTER TABLE saf_activo ADD COLUMN otrasesp text;
							ALTER TABLE saf_activo ADD COLUMN codestuso character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codcolor character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codusoedi character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codaseg character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtipcob character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtiplug character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codcatuni character varying(4);
							ALTER TABLE saf_activo ADD COLUMN comp character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN tienecomp character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN esvehiculo character varying(1) DEFAULT '0';														
							ALTER TABLE saf_activo ADD COLUMN tiempogaran double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedgar character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtipveh character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codmarca character varying(10);
							ALTER TABLE saf_activo ADD COLUMN codmodelo character varying(10);
							ALTER TABLE saf_activo ADD COLUMN serialcar character varying(128);
							ALTER TABLE saf_activo ADD COLUMN serialmot character varying(128);
							ALTER TABLE saf_activo ADD COLUMN sigplaca character varying(128);
							ALTER TABLE saf_activo ADD COLUMN nrotitprop character varying(128);
							ALTER TABLE saf_activo ADD COLUMN capacidad double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedcap character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN sisrastreo character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN espsisrast text;
							ALTER TABLE saf_activo ADD COLUMN anofabveh character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN codtipani character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codprosem character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codraza character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codgenero character varying(4);
							ALTER TABLE saf_activo ADD COLUMN peso character varying(10);
							ALTER TABLE saf_activo ADD COLUMN codunimedpeso character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN nrohierro character varying(50);
							ALTER TABLE saf_activo ADD COLUMN fecnacsem date DEFAULT NULL;
							ALTER TABLE saf_activo ADD COLUMN senas text;
							ALTER TABLE saf_activo ADD COLUMN urbaniza text;
							ALTER TABLE saf_activo ADD COLUMN calleave text;
							ALTER TABLE saf_activo ADD COLUMN casaedif text;
							ALTER TABLE saf_activo ADD COLUMN oficregistro text;
							ALTER TABLE saf_activo ADD COLUMN refregistro text;
							ALTER TABLE saf_activo ADD COLUMN tomo character varying(50);
							ALTER TABLE saf_activo ADD COLUMN folio character varying(50);
							ALTER TABLE saf_activo ADD COLUMN protocoloreg character varying(50);
							ALTER TABLE saf_activo ADD COLUMN nroregistro character varying(50);
							ALTER TABLE saf_activo ADD COLUMN fecregistro date DEFAULT NULL;
							ALTER TABLE saf_activo ADD COLUMN propanterior text;
							ALTER TABLE saf_activo ADD COLUMN areaconst double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedarea character varying(4); 
							
						

08/05/2021 19:49:41  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_36_2015 ERROR->Invalid query: ERROR:  column "codprosem" of relation "saf_activo" already exists
Whole query: 			   				
							ALTER TABLE saf_activo ADD COLUMN codforadq character varying(4);
							ALTER TABLE saf_activo ADD COLUMN esptec text;
							ALTER TABLE saf_activo ADD COLUMN otrasesp text;
							ALTER TABLE saf_activo ADD COLUMN codestuso character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codcolor character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codusoedi character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codaseg character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtipcob character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtiplug character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codcatuni character varying(4);
							ALTER TABLE saf_activo ADD COLUMN comp character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN tienecomp character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN esvehiculo character varying(1) DEFAULT '0';														
							ALTER TABLE saf_activo ADD COLUMN tiempogaran double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedgar character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codtipveh character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codmarca character varying(10);
							ALTER TABLE saf_activo ADD COLUMN codmodelo character varying(10);
							ALTER TABLE saf_activo ADD COLUMN serialcar character varying(128);
							ALTER TABLE saf_activo ADD COLUMN serialmot character varying(128);
							ALTER TABLE saf_activo ADD COLUMN sigplaca character varying(128);
							ALTER TABLE saf_activo ADD COLUMN nrotitprop character varying(128);
							ALTER TABLE saf_activo ADD COLUMN capacidad double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedcap character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN sisrastreo character varying(1) DEFAULT '0';
							ALTER TABLE saf_activo ADD COLUMN espsisrast text;
							ALTER TABLE saf_activo ADD COLUMN anofabveh character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN codtipani character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codprosem character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codraza character varying(4);
							ALTER TABLE saf_activo ADD COLUMN codgenero character varying(4);
							ALTER TABLE saf_activo ADD COLUMN peso character varying(10);
							ALTER TABLE saf_activo ADD COLUMN codunimedpeso character varying(4); 
							ALTER TABLE saf_activo ADD COLUMN nrohierro character varying(50);
							ALTER TABLE saf_activo ADD COLUMN fecnacsem date DEFAULT NULL;
							ALTER TABLE saf_activo ADD COLUMN senas text;
							ALTER TABLE saf_activo ADD COLUMN urbaniza text;
							ALTER TABLE saf_activo ADD COLUMN calleave text;
							ALTER TABLE saf_activo ADD COLUMN casaedif text;
							ALTER TABLE saf_activo ADD COLUMN oficregistro text;
							ALTER TABLE saf_activo ADD COLUMN refregistro text;
							ALTER TABLE saf_activo ADD COLUMN tomo character varying(50);
							ALTER TABLE saf_activo ADD COLUMN folio character varying(50);
							ALTER TABLE saf_activo ADD COLUMN protocoloreg character varying(50);
							ALTER TABLE saf_activo ADD COLUMN nroregistro character varying(50);
							ALTER TABLE saf_activo ADD COLUMN fecregistro date DEFAULT NULL;
							ALTER TABLE saf_activo ADD COLUMN propanterior text;
							ALTER TABLE saf_activo ADD COLUMN areaconst double precision DEFAULT 0;
							ALTER TABLE saf_activo ADD COLUMN codunimedarea character varying(4); 
							
						

08/05/2021 20:59:45  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_saf_c_activos_fijos <br><b>METODO:</b> InsertActivoImport <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for integer: ""
LINE 9:           '0.00', '1900-01-01', '1900-01-01', '', '0.00', ''...
                                                      ^
Whole query:     DELETE FROM saf_import_activo WHERE codact='0006';
				               INSERT INTO saf_import_activo(
															codact, tipo, denact, marca, modelo, color, serial, observacion, 
															ubicacion, codubica, ubicacion_fisica, responsable_pri, responsable_uso, 
															costo, fec_incorp, fec_compra, vida_util, valor_recate, spg_cuenta, 
															cod_clasif, scg_cuenta, scg_cuenta_depreciacion, scg_cuenta_dep_acumulada)
								VALUES ('0006', 'MUEBLE', 'Mouse', 'SIRAGON', '', 'Negro/gris', 'S/S', '', 
										'Presidencia', '0100000000', 'Presidencia', 'Tibisay Leon', 'Tibisay Leon', 
										'0.00', '1900-01-01', '1900-01-01', '', '0.00', '', 
										'', '', '', '');
				         
						 
						  

08/05/2021 21:01:41  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_saf_c_activos_fijos <br><b>METODO:</b> InsertActivoImport <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for type date: "--"
LINE 9:           '362754604.20', '--', '--', '3', '0.00', '40409020...
                                  ^
Whole query:     DELETE FROM saf_import_activo WHERE codact='00262';
				               INSERT INTO saf_import_activo(
															codact, tipo, denact, marca, modelo, color, serial, observacion, 
															ubicacion, codubica, ubicacion_fisica, responsable_pri, responsable_uso, 
															costo, fec_incorp, fec_compra, vida_util, valor_recate, spg_cuenta, 
															cod_clasif, scg_cuenta, scg_cuenta_depreciacion, scg_cuenta_dep_acumulada)
								VALUES ('00262', 'MUEBLE', 'Laptop con Cargador, bateria y bolso', 'SIRAGON', 'NB-3300', 'Gris/Negro', '191017P20457SP0336', '', 
										'Coordinación de Compras', '0400000000', 'Coordinación de Compras', 'Milagros Alemán', 'Adriana Alviarez', 
										'362754604.20', '--', '--', '3', '0.00', '404090200', 
										'20020-0007', '', '', '');
				         
						 
						  

08/05/2021 21:09:00  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_saf_c_activos_fijos <br><b>METODO:</b> InsertActivoImport <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for type double precision: ""
LINE 9:           '', '--', '--', '0', '', 'PARTIDA', 
                  ^
Whole query:     DELETE FROM saf_import_activo WHERE codact='CODACT';
				               INSERT INTO saf_import_activo(
															codact, tipo, denact, marca, modelo, color, serial, observacion, 
															ubicacion, codubica, ubicacion_fisica, responsable_pri, responsable_uso, 
															costo, fec_incorp, fec_compra, vida_util, valor_recate, spg_cuenta, 
															cod_clasif, scg_cuenta, scg_cuenta_depreciacion, scg_cuenta_dep_acumulada)
								VALUES ('CODACT', 'TIPO', 'DESCRIPCIÓN', 'MARCA', 'MODELO', 'COLOR', 'SERIAL', 'OBSERVACION', 
										'UBICACIÓN', 'CODIGO UBICACIÓN', 'UBICACIÓN FISICA', 'RESPONSABLE PRIMARIO', 'RESPONSABLE DE USO DIRECTO', 
										'', '--', '--', '0', '', 'PARTIDA', 
										'CODIGO CLASIF', 'CUENTA CONTABLE', 'CUENTA GASTO DEPRECIACION', 'CUENTA GASTO DEPRECIACION ACUMULADA');