10/05/2021 05:13:20  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_saf_load_activos ERROR->Invalid query: ERROR:  unterminated quoted string at or near "'0001 GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact"
LINE 7:      WHERE saf_activo.codemp='0001 GROUP BY saf_activo.codac...
                                     ^
Whole query: SELECT saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,       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
				 WHERE saf_activo.codemp='0001 GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact

10/05/2021 05:13:26  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_saf_load_activos ERROR->Invalid query: ERROR:  unterminated quoted string at or near "'0001 GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact"
LINE 7:      WHERE saf_activo.codemp='0001 GROUP BY saf_activo.codac...
                                     ^
Whole query: SELECT saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,       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
				 WHERE saf_activo.codemp='0001 GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact

10/05/2021 05:14:34  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_saf_load_activos ERROR->Invalid query: ERROR:  unterminated quoted string at or near "'0001  GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact"
LINE 8:      WHERE saf_activo.codemp='0001  GROUP BY saf_activo.coda...
                                     ^
Whole query: SELECT saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,
				       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
				 WHERE saf_activo.codemp='0001  GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact

10/05/2021 05:16:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_saf_load_activos ERROR->Invalid query: ERROR:  unterminated quoted string at or near "'0001  GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact"
LINE 8:      WHERE saf_activo.codemp='0001  GROUP BY saf_activo.coda...
                                     ^
Whole query: SELECT saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,
				       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
				 WHERE saf_activo.codemp='0001  GROUP BY saf_activo.codact,saf_activo.denact,saf_activo.maract,saf_activo.modact,saf_activo.feccmpact,          saf_activo.costo ORDER BY codact

10/05/2021 19:19:32  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_declaracion_xml_cabecera ERROR->Invalid query: ERROR:  syntax error at or near ","
LINE 37:             /*SUM(sno_hsalida.valsal) as baseimp*/, 
                                                           ^
Whole query:  SELECT '' AS codper, pro.rifpro, ben.rifben,dt.numfac AS numrecdoc, dt.numcon AS numref,
						 (dt.cmp_monobjret) as baseimp,
						  ded.codconret ,ded.porded,ded.codded, 
						  'CXP' AS procedencia, fecemisol AS fecope,sol.numsol 
					FROM scb_cmp_ret cmp
					INNER JOIN scb_dt_cmp_ret dt ON cmp.codemp = dt.codemp
									AND cmp.codret = dt.codret
									AND cmp.numcom = dt.numcom
									AND cmp.tipsolpag = dt.tipsolpag
					INNER JOIN cxp_solicitudes sol ON dt.codemp = sol.codemp
									  AND dt.numsop = sol.numsol
					INNER JOIN sigesp_deducciones ded ON ded.codemp=dt.codemp
									 AND ded.codded=dt.cmp_codret
					LEFT JOIN rpc_proveedor pro ON cmp.cmp_codpro=pro.cod_pro 
									   AND cmp.cmp_tipproben='P'
					LEFT JOIN rpc_beneficiario ben ON cmp.cmp_cedbene=ben.ced_bene 
									  AND cmp.cmp_tipproben='B' 
					WHERE cmp.codret='0000000006'
				     AND cmp.codemp = '0001' 
					 AND ded.islr = 1				 
					 AND sol.estprosol NOT IN ('A','N')
					 AND cmp.estcmpret<>0
					 AND (sol.tipsolpag ='SOPA' OR sol.tipsolpag ='FOAN' OR sol.tipsolpag ='FOAV' OR sol.tipsolpag ='LIQA')
					  AND sol.fecemisol >='2021-04-01' AND sol.fecemisol <='2021-04-30' AND ( sol.codsuc IN (
														SELECT p.codintper 
														FROM sss_permisos_internos p 
														INNER JOIN cxc_sucursales suc ON suc.codsuc = p.codintper
														WHERE codsis='CXC'
														  AND codusu='ADMINISTRADOR'
													)
								  OR sol.codsuc=''
								  OR sol.codsuc IS NULL
							   )	
						     
						 
				 UNION SELECT sno_personal.codper, MAX(sno_personal.rifper) AS rifpro,'' AS rifben,'0' AS numrecdoc,'' AS numref, 
				        /*SUM(sno_hsalida.valsal) as baseimp*/, 
			            SUM(abs(sno_hsalida.valsal)*100/sno_personalisr.porisr) AS baseimp, 
				
					   MAX(sno_personalisr.codconret) AS codconret, 
				       MAX(sno_personalisr.porisr) AS porded, sno_personalisr.codisr AS codded, 
					   'SNO' AS procedencia, MAX(sno_hperiodo.fechasper) AS fecope,'' as numsol   FROM sno_hsalida, sno_personalisr, sno_personal, sno_hperiodo,sno_hconcepto  WHERE sno_hsalida.codemp = '0001'    AND SUBSTR(sno_hperiodo.fecdesper,1,4) = '2021'    AND SUBSTR(sno_hperiodo.fecdesper,6,2) = '04'    AND sno_personalisr.codisr = '04'   AND sno_hperiodo.fecdesper >='2021-04-01' AND sno_hperiodo.fecdesper <='2021-04-30'   AND sno_hconcepto.aplisrcon = 1     AND sno_hsalida.codemp = sno_hconcepto.codemp     AND sno_hsalida.anocur = sno_hconcepto.anocur     AND sno_hsalida.codperi = sno_hconcepto.codperi     AND sno_hsalida.codnom = sno_hconcepto.codnom     AND sno_hsalida.codconc = sno_hconcepto.codconc     AND sno_hsalida.codemp = sno_hperiodo.codemp     AND sno_hsalida.anocur = sno_hperiodo.anocur     AND sno_hsalida.codperi = sno_hperiodo.codperi     AND sno_hsalida.codnom = sno_hperiodo.codnom     AND sno_hsalida.codemp = sno_personalisr.codemp     AND sno_hsalida.codper = sno_personalisr.codper     AND sno_personal.codemp = sno_personalisr.codemp     AND sno_personal.codper = sno_personalisr.codper  
				    AND sno_hsalida.codper IN ( 
						SELECT codper 
						FROM sno_hsalida s 
						INNER JOIN sno_hconcepto c ON c.codemp = s.codemp 
												  AND c.anocur = s.anocur 
												  AND c.codperi = s.codperi 
												  AND c.codnom = s.codnom 
												  AND c.codconc = s.codconc 
						INNER JOIN sno_hperiodo p ON s.codemp = p.codemp 
									  AND s.anocur = p.anocur 
									  AND s.codperi = p.codperi 
									  AND s.codnom = p.codnom 				                         
						  WHERE  SUBSTR(p.fecdesper,1,4) = '2021' 
							   AND SUBSTR(p.fecdesper,6,2) = '04' 				       
							    AND p.fecdesper >='2021-04-01' AND p.fecdesper <='2021-04-30'
							   AND s.valsal<>0 
							   AND c.aplisrcon=1 
						 GROUP BY codper
		            ) 
				 GROUP BY sno_personal.codper, sno_personalisr.codisr