24/02/2021 20:40:36  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> sigesp_sep_c_solicitud <br><b>METODO:</b> ConsultaClasifSep <br><b>ERROR-></b><br>Invalid query: ERROR:  syntax error at or near "ORDER"
LINE 18:       ORDER BY c.codclasep
               ^
Whole query:  SELECT DISTINCT c.*
			            FROM sep_clasif_solicitudes c
						INNER JOIN sss_permisos_internos p ON p.codintper = c.scgcencost
						                                  AND codsis='SEP'
														  AND codusu='ADMINISTRADOR'
						WHERE denclasep ILIKE '%%'	
						 AND c.reqalm=1 	
						UNION
						SELECT DISTINCT c.*
			            FROM sep_clasif_solicitudes c
						INNER JOIN sss_permisos_especificos p ON p.tipperesp = 'PERMISO_CLASIFICACION_SEP'
						                                     AND codsis='SEP'
														     AND codusu='ADMINISTRADOR'
						WHERE denclasep ILIKE '%%'	
						 AND c.reqalm=1 			
						ORDER BY c.codclasep
						
						ORDER BY c.codclasep
					  

24/02/2021 20:40:56  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> sigesp_sep_c_solicitud <br><b>METODO:</b> ConsultaClasifSep <br><b>ERROR-></b><br>Invalid query: ERROR:  missing FROM-clause entry for table "c"
LINE 16:       ORDER BY c.codclasep
                        ^
Whole query:  SELECT DISTINCT c.*
			            FROM sep_clasif_solicitudes c
						INNER JOIN sss_permisos_internos p ON p.codintper = c.scgcencost
						                                  AND codsis='SEP'
														  AND codusu='ADMINISTRADOR'
						WHERE denclasep ILIKE '%%'	
						 AND c.reqalm=1 	
						UNION
						SELECT DISTINCT c.*
			            FROM sep_clasif_solicitudes c
						INNER JOIN sss_permisos_especificos p ON p.tipperesp = 'PERMISO_CLASIFICACION_SEP'
						                                     AND codsis='SEP'
														     AND codusu='ADMINISTRADOR'
						WHERE denclasep ILIKE '%%'	
						 AND c.reqalm=1 			
						ORDER BY c.codclasep
					  

24/02/2021 22:11:37  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> ConsultaIngresosCajaInvalid query: ERROR:  invalid input syntax for integer: ""
LINE 31:           AND ing.id_cliente=''
                                      ^
Whole query: SELECT  ing.codforpag,
					            fp.denforpag,
					            MAX(ing.codcaj) AS codcaj,
								MAX(ing.codsuc) AS codsuc,
								MAX(ing.codmon) AS codmon,
								MAX(abrmon) AS abrmon,
								MAX(denmon) AS denmon,
								MAX(ing.tascam) AS tascam,
								MAX(codcliente) AS codcliente,
								MAX(nombre_cliente) AS nombre_cliente,
								sum(ing.moning) AS moning,
								sum(ing.moningret) AS moningret,
								sum(ing.moningnc) AS moningnc,
								sum(ing.moningant) AS moningant,
								sum(ing.moningotros) AS moningotros,
								sum(ing.moncomp) AS moncomp
								  FROM cxc_ingresos ing  INNER JOIN cxc_formapago fp ON fp.codforpag = ing.codforpag
					                  INNER JOIN cxc_esting ei ON ei.esting = ing.esting
					                  INNER JOIN cxc_sucursales suc ON suc.codemp = ing.codemp 
									                              AND suc.codsuc = ing.codsuc
								      INNER JOIN cxc_cajas caj ON caj.codemp = ing.codemp 
																 AND caj.codsuc = ing.codsuc
																 AND caj.codcaj = ing.codcaj 
									  LEFT JOIN cxc_clientes c ON c.id_cliente = ing.id_cliente
									  LEFT JOIN sigesp_moneda mo ON ing.codmon = mo.codmon	
									  LEFT JOIN cxc_bancos b ON b.codban = ing.codbancli 
									  LEFT JOIN scb_banco be ON be.codemp = ing.codemp AND be.codban = ing.codban 
									  LEFT JOIN scb_ctabanco cbe ON cbe.codemp = ing.codemp AND cbe.codban = ing.codban AND cbe.ctaban = ing.ctaban 							   
					                  WHERE ing.codemp='0001' 
									    AND ing.fecing='2021-02-24'
										AND ing.id_cliente=''
										AND ing.esting!='ANU' 
									  GROUP BY 1,2
									  ORDER BY 1,2
									  

24/02/2021 22:11:51  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> ConsultaIngresosCajaInvalid query: ERROR:  invalid input syntax for integer: ""
LINE 31:           AND ing.id_cliente=''
                                      ^
Whole query: SELECT  ing.codforpag,
					            fp.denforpag,
					            MAX(ing.codcaj) AS codcaj,
								MAX(ing.codsuc) AS codsuc,
								MAX(ing.codmon) AS codmon,
								MAX(abrmon) AS abrmon,
								MAX(denmon) AS denmon,
								MAX(ing.tascam) AS tascam,
								MAX(codcliente) AS codcliente,
								MAX(nombre_cliente) AS nombre_cliente,
								sum(ing.moning) AS moning,
								sum(ing.moningret) AS moningret,
								sum(ing.moningnc) AS moningnc,
								sum(ing.moningant) AS moningant,
								sum(ing.moningotros) AS moningotros,
								sum(ing.moncomp) AS moncomp
								  FROM cxc_ingresos ing  INNER JOIN cxc_formapago fp ON fp.codforpag = ing.codforpag
					                  INNER JOIN cxc_esting ei ON ei.esting = ing.esting
					                  INNER JOIN cxc_sucursales suc ON suc.codemp = ing.codemp 
									                              AND suc.codsuc = ing.codsuc
								      INNER JOIN cxc_cajas caj ON caj.codemp = ing.codemp 
																 AND caj.codsuc = ing.codsuc
																 AND caj.codcaj = ing.codcaj 
									  LEFT JOIN cxc_clientes c ON c.id_cliente = ing.id_cliente
									  LEFT JOIN sigesp_moneda mo ON ing.codmon = mo.codmon	
									  LEFT JOIN cxc_bancos b ON b.codban = ing.codbancli 
									  LEFT JOIN scb_banco be ON be.codemp = ing.codemp AND be.codban = ing.codban 
									  LEFT JOIN scb_ctabanco cbe ON cbe.codemp = ing.codemp AND cbe.codban = ing.codban AND cbe.ctaban = ing.ctaban 							   
					                  WHERE ing.codemp='0001' 
									    AND ing.fecing='2021-02-24'
										AND ing.id_cliente=''
										AND ing.esting!='ANU' 
									  GROUP BY 1,2
									  ORDER BY 1,2