05/01/2022 17:04:31  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_saf_c_activos_fijos <br><b>METODO:</b> ConsultaEstadoConservacion <br><b>ERROR->:</b><br>Invalid query: ERROR:  column "codorg" does not exist
LINE 5:         ORDER BY codorg;
                         ^
Whole query:     SELECT trim(codconbie) as codconbie, 
							  rtrim(denconbie) as denconbie,
							  rtrim(desconbie) as desconbie
						 FROM saf_conservacionbien
					   ORDER BY codorg;
				  

05/01/2022 17:20:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_saf_load_activos ERROR->Invalid query: ERROR:  column "edocon.denconbie" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ivo.maract,saf_activo.modact,saf_activo.feccmpact,edocon.den...
                                                             ^
Whole query: SELECT saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,edocon.denconbie,
				       saf_activo.costo
				  FROM saf_activo
				   LEFT JOIN saf_dta ON saf_dta.codemp=saf_activo.codemp AND saf_dta.codact=saf_activo.codact
				   LEFT JOIN srh_organigrama ON saf_dta.codemp=srh_organigrama.codemp AND saf_dta.coduniadm=srh_organigrama.codorg
				   LEFT JOIN sno_personal rp on rp.codper = saf_dta.codrespri
				   LEFT JOIN sno_personal ru on ru.codper = saf_dta.codres
				   LEFT JOIN saf_conservacionbien edocon on edocon.codconbie = saf_activo.codconbie
				   
				 WHERE saf_activo.codemp='0001'  AND saf_activo.codconbie='14'  GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact