12/06/2021 18:53:05  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Importar Prestamos MÉTODO->uf_buscar_periodo_prestamo ERROR->Invalid query: ERROR:  invalid input syntax for type date: "16/0-/2-21"
LINE 1: ...WHERE codemp='0001'    AND codnom = '1000'    AND '16/0-/2-2...
                                                             ^
Whole query: SELECT codperi   FROM sno_periodo  WHERE codemp='0001'    AND codnom = '1000'    AND '16/0-/2-21' BETWEEN fecdesper AND  fechasper 

12/06/2021 18:53:05  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Prestamo MÉTODO->uf_validar_prestamo ERROR->Invalid query: ERROR:  invalid input syntax for type date: "16/0-/2-21"
LINE 9:         AND pp.feciniper<='16/0-/2-21'
                                  ^
Whole query:    SELECT * 
					FROM sno_prestamosperiodo pp
					INNER JOIN sno_prestamos p ON p.codemp = pp.codemp
								   AND p.codnom = pp.codnom
								   AND p.codtippre = pp.codtippre
				    WHERE pp.codnom='1000'
				    AND pp.codper='0004585608'
				    AND pp.codtippre='0000006020'				
				    AND pp.feciniper<='16/0-/2-21'
				    AND pp.fecfinper>='16/0-/2-21'
					/*AND p.fecpre<'16/0-/2-21'*/
					

12/06/2021 18:53:05  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Prestamo MÉTODO->uf_validar_prestamo ERROR->Invalid query: ERROR:  invalid input syntax for type date: "16/0-/2-21"
LINE 1: ...c='0000006020'   AND perinipre='000'   AND fecpre='16/0-/2-2...
                                                             ^
Whole query: SELECT *   FROM sno_prestamos  WHERE codemp='0001'   AND codnom='1000'   AND codper='0004585608'   AND codtippre='0000006020'   AND codconc='0000006020'   AND perinipre='000'   AND fecpre='16/0-/2-21' ORDER BY numpre DESC

12/06/2021 18:53:05  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_sno_c_importarprestamos MÉTODO->uf_procesar_prestamo ERROR->Invalid query: ERROR:  invalid input syntax for type date: "16/0-/2-21"
LINE 1: ...6020',15,'0000006020', 1,3774437.64,12.00,'000',0,'16/0-/2-2...
                                                             ^
Whole query: INSERT INTO sno_prestamos(codemp,codnom,codper,codtippre,numpre,codconc,stapre,monpre,numcuopre,perinipre,monamopre,fecpre,tipcuopre,obsrecpre)VALUES('0001','1000','0004585608','0000006020',15,'0000006020', 1,3774437.64,12.00,'000',0,'16/0-/2-21','0','')

12/06/2021 21:01:35  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_sno_c_nomina Personal MÉTODO->ConsultaDescuentoPrestamoPersonal ERROR->Invalid query: ERROR:  ORDER BY "codperi" is ambiguous
LINE 21: ... ORDER BY pp.codper,pp.codtippre,pp.numpre,pp.numpre,codperi
                                                                 ^
Whole query: 
		
					SELECT p.nacper,p.nomper,p.apeper,pp.*,pre.*
					FROM sno_hprestamosperiodo pp
					INNER JOIN sno_hprestamos pre ON pre.codemp=pp.codemp		
					                                 AND pre.codnom=pp.codnom						 
										             AND pre.codper=pp.codper
										             AND pre.anocur=pp.anocur 
									                 AND pre.codperi=pp.codperi 
													 AND pre.codtippre=pp.codtippre
													 AND pre.numpre=pp.numpre													 
					INNER JOIN sno_hpersonalnomina pn ON pn.codemp=pp.codemp		
					                                 AND pn.codnom=pp.codnom						 
										             AND pn.codper=pp.codper
										             AND pn.anocur=pp.anocur 
									                 AND pn.codperi=pp.codperi 
					INNER JOIN sno_personal p ON p.codemp=pn.codemp AND p.codper=pn.codper 
					WHERE pp.codemp='0001'
					  AND pp.estcuo=1
					   AND pp.codnom BETWEEN '1000' AND '1000'  AND pp.codtippre BETWEEN '0000006010' AND '0000006023'  AND pp.anocur = '2021'  AND pp.codperi BETWEEN '011' AND '011' 				  
					ORDER BY pp.codper,pp.codtippre,pp.numpre,pp.numpre,codperi