07/09/2015 13:34:10  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_39_2015 ERROR->Invalid query: ERROR:  el valor de hora/fecha está fuera de rango: «9999-99-99»
HINT:  Quizás necesite una configuración diferente de «datestyle».
Whole query: 			   				
							CREATE TABLE saf_origen_adquisicion
							(
								codemp character varying(4) NOT NULL,
								ori_codori character varying(12) NOT NULL,
								ori_codforadq character varying(4) NOT NULL,
								ori_claforadq character varying(1),
								ori_denconc character varying(255),
								ori_nroconc character varying(30),
								ori_fecconc date DEFAULT '9999-99-99',
								ori_codprov character varying(10),
								ori_nrocontconc character varying(30),
								ori_feccontconc date DEFAULT '9999-99-99',
								ori_nronotentconc character varying(30),
								ori_fecnotentconc date DEFAULT '9999-99-99',
								ori_nrofact character varying(30),
								ori_fecfact date DEFAULT '9999-99-99',
								ori_numordcomp character varying(30),
								ori_fecordcomp date DEFAULT '9999-99-99',
								ori_nompropant character varying(100),
								ori_nomben character varying(100),
								ori_nomautor character varying(100),
								ori_nrosentactcont character varying(30),
								ori_fecsentactcont date DEFAULT '9999-99-99',
								ori_nomreg character varying(100),
								ori_tomo character varying(20),
								ori_folio character varying(6),
								ori_fecreg date DEFAULT '9999-99-99',
								ori_nomceddac character varying(100),
								ori_nomdon character varying(100),
								ori_nomcopper character varying(100),
								ori_nomlicit character varying(255),
								ori_nrolict character varying(30),
								ori_feclicit date,
								ori_nompertrans character varying(200),
								ori_nombenrecibtrans character varying(200),	
								CONSTRAINT pk_saf_origen_adquisicion PRIMARY KEY (codemp, ori_codforadq, ori_codori)  
							)
							WITH (
							  OIDS=FALSE
							);
							ALTER TABLE saf_origen_adquisicion
							  OWNER TO postgres;
							
						

07/09/2015 14:42:58  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> sigesp_saf_c_activo <br><b>METODO:</b> InsertarOrigenAdq <br><b>ERROR-></b><br>Invalid query: ERROR:  la sintaxis de entrada no es válida para tipo date: «»
LINE 12:        '', '', '', '', '', 
                    ^
Whole query:  INSERT INTO saf_origen_adquisicion(
							codemp, ori_codori, ori_codforadq, ori_claforadq, ori_denconc, 
							ori_nroconc, ori_fecconc, ori_codprov, ori_nrocontconc, ori_feccontconc, 
							ori_nronotentconc, ori_fecnotentconc, ori_nrofact, ori_fecfact, 
							ori_numordcomp, ori_fecordcomp, ori_nompropant, ori_nomben, ori_nomautor, 
							ori_nrosentactcont, ori_fecsentactcont, ori_nomreg, ori_tomo, 
							ori_folio, ori_fecreg, ori_nomceddac, ori_nomdon, ori_nomcopper, 
							ori_nomlicit, ori_nrolict, ori_feclicit, ori_nompertrans, ori_nombenrecibtrans)
					VALUES ('0001', '111', '0008', 'A', 'AAAA', 
							'123445', '2015-09-01', '', '2222', '2015-09-02', 
							'33333', '2015-09-03', '44444', '2015-09-04', 
							'', '', '', '', '', 
							'', '1900-01-01', '', '', 
							'', '', '', '', '', 
							'', '', '1900-01-01', '', ''); 

07/09/2015 22:26:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->activo MÉTODO->uf_saf_insert_activo ERROR->Invalid query: ERROR:  INSERT tiene más columnas de destino que expresiones
LINE 10:              propanterior, areaconst, codunimedarea, codori
                                                              ^
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','000000000240002','EDIFICIO SAN GERMAN. SEDE PRINCIPAL','','','2015-09-07',        '1998-10-10','01','404110200                ','2','31010-0001',1000000.00,        '1','  XXXXXX','','058','001','001','',        '','',0.00,'01','','1900-01-01',        '1','01','---','---','---','---','','-----',
				  		   '0001','aaaaaa','bbbbbbb','0001',
						   '0032','0008','0010','0001','0016',
						   '0','0','0','20.00','03','',
						   '','','','','','',
						   '0.00','','0','','','',
						   '','','','0.00','','',
						   '1900-01-01','','Elparaiso','Paez','Victoria','ElSilencio',
						   '1111','222','3333','444','555','1998-06-05',
						   'YelitzaArias','500.00','0003','2222'						   
				  
				  )