15/04/2015 10:43:24  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->Fideicomiso MÉTODO->uf_procesar_personal_version3 ERROR->Invalid query: ERROR:  la columna «sno_hpersonalnomina.codperi» debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
LINE 74:         ORDER BY sno_hpersonalnomina.codper,sno_hpersonalnom...
                                                     ^
Whole query: SELECT sno_hpersonalnomina.codper, sno_hpersonalnomina.codnom, sno_hpersonalnomina.codded, 
				                sno_hpersonalnomina.codtipper,sno_hpersonalnomina.fecingper,sno_personal.fecingper AS fecingpersonal, 
								MAX(sno_hpersonalnomina.codtabvac) AS codtabvac, 
								SUM(sno_hpersonalnomina.sueintper) AS sueintper, 
								SUM((SELECT SUM(abs(sno_hsalida.valsal))  
						          FROM sno_hsalida, sno_hconcepto 
						         WHERE sno_hconcepto.asifidper ='1' 
									AND (sno_hsalida.tipsal='A' OR sno_hsalida.tipsal='R' OR  sno_hsalida.tipsal='P1')
									AND sno_hsalida.codemp = sno_hpersonalnomina.codemp 
						           AND sno_hsalida.codnom = sno_hpersonalnomina.codnom 
						           AND sno_hsalida.anocur = sno_hpersonalnomina.anocur 
						           AND sno_hsalida.codperi = sno_hpersonalnomina.codperi 
						           AND sno_hsalida.codper = sno_hpersonalnomina.codper 
						           AND sno_hsalida.codemp = sno_hconcepto.codemp 
						           AND sno_hsalida.codnom = sno_hconcepto.codnom 
						           AND sno_hsalida.anocur = sno_hconcepto.anocur 
						           AND sno_hsalida.codperi = sno_hconcepto.codperi 
						           AND sno_hsalida.codconc = sno_hconcepto.codconc )) AS asifidper, 
								SUM((SELECT SUM(abs(sno_hsalida.valsal))  
						          FROM sno_hsalida, sno_hconcepto 
						         WHERE sno_hconcepto.sueintfid ='1' 
									AND (sno_hsalida.tipsal='A' OR sno_hsalida.tipsal='P1')
									AND sno_hsalida.codemp = sno_hpersonalnomina.codemp 
						           AND sno_hsalida.codnom = sno_hpersonalnomina.codnom 
						           AND sno_hsalida.anocur = sno_hpersonalnomina.anocur 
						           AND sno_hsalida.codperi = sno_hpersonalnomina.codperi 
						           AND sno_hsalida.codper = sno_hpersonalnomina.codper 
						           AND sno_hsalida.codemp = sno_hconcepto.codemp 
						           AND sno_hsalida.codnom = sno_hconcepto.codnom 
						           AND sno_hsalida.anocur = sno_hconcepto.anocur 
						           AND sno_hsalida.codperi = sno_hconcepto.codperi 
						           AND sno_hsalida.codconc = sno_hconcepto.codconc )) AS sueintfid, 
								SUM((SELECT SUM(abs(sno_hsalida.valsal))  
						          FROM sno_hsalida, sno_hconcepto 
						         WHERE sno_hconcepto.asifidpat ='1' 
									AND sno_hsalida.tipsal='P2' 
									AND sno_hsalida.codemp = sno_hpersonalnomina.codemp 
						            AND sno_hsalida.codnom = sno_hpersonalnomina.codnom 
					 	            AND sno_hsalida.anocur = sno_hpersonalnomina.anocur 
						            AND sno_hsalida.codperi = sno_hpersonalnomina.codperi 
						            AND sno_hsalida.codper = sno_hpersonalnomina.codper 
						            AND sno_hsalida.codemp = sno_hconcepto.codemp 
						            AND sno_hsalida.codnom = sno_hconcepto.codnom 
						            AND sno_hsalida.anocur = sno_hconcepto.anocur 
						            AND sno_hsalida.codperi = sno_hconcepto.codperi 
						            AND sno_hsalida.codconc = sno_hconcepto.codconc)) AS asifidpat, 
								 (SELECT sno_fideicomiso.capantcom  
						           FROM sno_fideicomiso 
						         WHERE sno_fideicomiso.codemp = sno_hpersonalnomina.codemp 
						           AND sno_fideicomiso.codper = sno_hpersonalnomina.codper 
						          GROUP BY sno_hpersonalnomina.codemp, sno_hpersonalnomina.codper, sno_fideicomiso.capantcom ) AS capantcom,
								  sno_personal.estper,MAX(sno_hpersonalnomina.staper) as staper
						   FROM sno_hpersonalnomina, sno_hnomina, sno_hperiodo,sno_personal 
						  WHERE sno_hpersonalnomina.codemp = '0001'  AND ((sno_hpersonalnomina.codnom='0005')) 
						  	AND sno_hpersonalnomina.anocur = '2015' 
						 	AND (sno_hpersonalnomina.staper = '1' OR sno_hpersonalnomina.staper = '2') 
						 	AND substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) = '03' 
						 	AND substr(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2015' 
						 	AND sno_hnomina.espnom = '0' 
							AND sno_personal.fecingper<='2015-03-31'
						    AND sno_hpersonalnomina.codemp = sno_hnomina.codemp 
						 	AND sno_hpersonalnomina.codnom = sno_hnomina.codnom 
						 	AND sno_hpersonalnomina.anocur = sno_hnomina.anocurnom 
						 	AND sno_hpersonalnomina.codperi = sno_hnomina.peractnom 
						    AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp 
						 	AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom 
						 	AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur 
						 	AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi
						    AND sno_personal.codemp = sno_hpersonalnomina.codemp
							AND sno_personal.codper = sno_hpersonalnomina.codper						 
						  GROUP BY sno_hpersonalnomina.codemp, sno_hpersonalnomina.codper, 
						           sno_hpersonalnomina.codnom, sno_hpersonalnomina.codded, sno_hpersonalnomina.codtipper,
								   sno_hpersonalnomina.fecingper,sno_personal.fecingper,sno_personal.estper 
						  ORDER BY sno_hpersonalnomina.codper,sno_hpersonalnomina.codperi 

15/04/2015 10:49:18  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->FIDEICOMISO METODO->ObtenerDatosPersonal ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: 
					SELECT * FROM sno_personal WHERE codper='0004788201' 
		        

15/04/2015 10:49:18  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->Fideicomiso MÉTODO->uf_load_nomina ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: SELECT codnom, desnom   FROM sno_nomina  WHERE codemp='0001' 	AND espnom = '0' 
				  ORDER BY codnom
				

15/04/2015 10:52:14  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->FIDEICOMISO METODO->ObtenerDatosPersonal ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: 
					SELECT * FROM sno_personal WHERE codper='0004788201' 
		        

15/04/2015 10:52:14  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->Fideicomiso MÉTODO->uf_load_nomina ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: SELECT codnom, desnom   FROM sno_nomina  WHERE codemp='0001' 	AND espnom = '0' 
				  ORDER BY codnom
				

15/04/2015 10:58:32  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->FIDEICOMISO METODO->ObtenerDatosPersonal ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: 
					SELECT * FROM sno_personal WHERE codper='0004788201' 
		        

15/04/2015 10:58:32  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->Fideicomiso MÉTODO->uf_load_nomina ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: SELECT codnom, desnom   FROM sno_nomina  WHERE codemp='0001' 	AND espnom = '0' 
				  ORDER BY codnom
				

15/04/2015 11:01:24  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->FIDEICOMISO METODO->ObtenerDatosPersonal ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: 
					SELECT * FROM sno_personal WHERE codper='0004788201' 
		        

15/04/2015 11:01:24  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->Fideicomiso MÉTODO->uf_load_nomina ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: SELECT codnom, desnom   FROM sno_nomina  WHERE codemp='0001' 	AND espnom = '0' 
				  ORDER BY codnom
				

15/04/2015 15:22:30  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  <b>CLASE:</b> covensol_sno_c_nomina <br><b>METODO:</b> insertar_configuracion <br><b>ERROR-></b><br>Invalid query: ERROR:  llave duplicada viola restricción de unicidad «pk_sigesp_config»
Whole query: INSERT INTO sigesp_config(codemp, codsis, seccion, entry, "type", "value")
				 VALUES ('0001', 'SNO', 'CONFIG', 'FIDEICOMISO_SUELDO_INTEGRAL_FID', 'C', '1');

15/04/2015 17:29:35  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  <b>CLASE:</b> covensol_fop_c_formulacion <br><b>METODO:</b> InsertarEp2 <br><b>ERROR-></b><br>Invalid query: ERROR:  inserción o actualización en la tabla «fop_ep2» viola la llave foránea «fk_fop_ep1_fop_ep2»
DETAIL:  La llave (codemp,codplangob,anopresup,codestpro1,estcla)=(0001,1,2014,0000000000000000000PRY002,A) no está presente en la tabla «fop_ep1».
Whole query: INSERT INTO fop_ep2( codemp, anopresup, codplangob, codestpro1, estcla,codestpro2, 
												denestpro2, feciniep2, fecfinep2, coduniadm, desbienserv, codunimedep2,canmetep2,
												pfis_est, pfis_1, pfis_2, pfis_3, pfis_4, pfis_totact, 
                								pfis_totsig, pfis_totpost,
												pfin_est, pfin_1, pfin_2, pfin_3, 
											    pfin_4, pfin_totact, pfin_totsig, pfin_totpost, pfin_monrecord, 
											    pfin_monotrrec, pfin_monrecext, pfin_montotep2,pondera,
												fecreg,usureg)
						   VALUES (  '0001', 2014, 1, '0000000000000000000PRY002', 'A', '0000000000000000000000010', 'sasss', '2014-01-01', '2014-12-31', '0000000001', 'xxxx', '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.02', '0.00', '0.00', '0.02', '0.00', '2015/04/15 17:29:34', 'SIGESP'  ); 

15/04/2015 18:45:30  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->FIDEICOMISO METODO->ObtenerDatosPersonal ERROR->Invalid query: ERROR:  error de sintaxis en o cerca de «0005»
LINE 7:        WHERE sno_hpersonalnomina.codemp = '0001' 0005
                                                         ^
Whole query: 
					SELECT DISTINCT ON(sno_hpersonalnomina.codper) sno_hpersonalnomina.codper,
					                                               sno_hpersonalnomina.staper,
																   sno_hpersonalnomina.codperi,
																   sno_personal.estper
					FROM sno_hpersonalnomina, sno_hnomina, sno_hperiodo,sno_personal
				   WHERE sno_hpersonalnomina.codemp = '0001' 0005
					 AND sno_hpersonalnomina.anocur = '2015'					 
					 AND substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) = '03' 
					 AND substr(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2015' 
					 AND sno_hpersonalnomina.codper = '0004788201'
					 AND sno_hnomina.espnom = '0' 
					 AND sno_personal.fecingper<='2015-03-31'
					 AND sno_hpersonalnomina.codemp = sno_hnomina.codemp 
					 AND sno_hpersonalnomina.codnom = sno_hnomina.codnom 
					 AND sno_hpersonalnomina.anocur = sno_hnomina.anocurnom 
					 AND sno_hpersonalnomina.codperi = sno_hnomina.peractnom 
					 AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp 
					 AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom 
					 AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur 
					 AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi
					 AND sno_personal.codemp = sno_hpersonalnomina.codemp
					 AND sno_personal.codper = sno_hpersonalnomina.codper
					 ORDER BY sno_hpersonalnomina.codper,sno_hpersonalnomina.codperi DESC LIMIT 1 
		        

15/04/2015 18:49:03  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->FIDEICOMISO METODO->ObtenerDatosPersonal ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: 
					SELECT DISTINCT ON(sno_hpersonalnomina.codper) sno_hpersonalnomina.codper,
					                                               sno_hpersonalnomina.staper,
																   sno_hpersonalnomina.codperi,
																   sno_personal.estper
					FROM sno_hpersonalnomina, sno_hnomina, sno_hperiodo,sno_personal
				   WHERE sno_hpersonalnomina.codemp = '0001'  AND ((sno_hpersonalnomina.codnom='0005')) 
					 AND sno_hpersonalnomina.anocur = '2015'					 
					 AND substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) = '03' 
					 AND substr(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2015' 
					 AND sno_hpersonalnomina.codper = '0006445211'
					 AND sno_hnomina.espnom = '0' 
					 AND sno_personal.fecingper<='2015-03-31'
					 AND sno_hpersonalnomina.codemp = sno_hnomina.codemp 
					 AND sno_hpersonalnomina.codnom = sno_hnomina.codnom 
					 AND sno_hpersonalnomina.anocur = sno_hnomina.anocurnom 
					 AND sno_hpersonalnomina.codperi = sno_hnomina.peractnom 
					 AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp 
					 AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom 
					 AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur 
					 AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi
					 AND sno_personal.codemp = sno_hpersonalnomina.codemp
					 AND sno_personal.codper = sno_hpersonalnomina.codper
					 ORDER BY sno_hpersonalnomina.codper,sno_hpersonalnomina.codperi DESC LIMIT 1 
		        

15/04/2015 18:49:03  *****  ERROR DE SISTEMA:   *****  SIGESP  *****  CLASE->Fideicomiso MÉTODO->uf_load_nomina ERROR->Invalid query: FATAL:  terminando la conexión debido a una orden del administrador
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
Whole query: SELECT codnom, desnom   FROM sno_nomina  WHERE codemp='0001' 	AND espnom = '0' 
				  ORDER BY codnom