26/08/2015 14:12:20  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_scv_c_viaticos <br><b>METODO:</b> SelectInfoViaticoPersona <br><b>ERROR->:</b><br>Invalid query: ERROR:  el operador no existe: character varying <> integer
LINE 32:             AND pn.staper != 3
                                   ^
HINT:  Ningún operador coincide con el nombre y el tipo de los argumentos. Puede desear agregar conversiones explícitas de tipos.
Whole query:  		
				SELECT p.codper,(p.nomper||' '||p.apeper) AS nomape,ua.desuniadm,uf.desubifis,
					   e_estsolvia.descequiv AS desc_estsolvia,p.cedper,p.codper, 
					   (CASE DATE_PART('month',sv.fecsolvia) WHEN '1' THEN 'enero' 
									  WHEN '2' THEN 'febrero'
									  WHEN '3' THEN 'marzo'
									  WHEN '4' THEN 'abril'
									  WHEN '5' THEN 'mayo'
									  WHEN '6' THEN 'junio'
									  WHEN '7' THEN 'julio'
									  WHEN '8' THEN 'agosto'
									  WHEN '9' THEN 'septiembre'
									  WHEN '10' THEN 'octubre'
									  WHEN '11' THEN 'noviembre'
									  WHEN '12' THEN 'diciembre'				      
													  ELSE 'numero de mes inválido' END) AS desmes,
					   (CASE n.racnom WHEN '1' THEN ac.denasicar ELSE ca.descar END) AS cargo,
					   dtp.monpervia, pn.codnom,
					   'SCV-0'||lpad(sv.codsolvia,10,'0') AS codsolvia,
					   sv.fecsalvia,sv.fecregvia,sv.fecsolvia,
					   (SELECT DISTINCT ON(codrut) desrut
					  FROM scv_rutas rut
					 WHERE sv.codemp=rut.codemp
					   AND sv.codrut=rut.codrut
					 GROUP BY codrut,desrut) AS desrut,
					   mis.denmis
				FROM scv_dt_personal dtp
				INNER JOIN scv_solicitudviatico sv ON sv.codemp = dtp.codemp
									  AND sv.codsolvia = dtp.codsolvia
				INNER JOIN sno_personalnomina pn ON pn.codemp = dtp.codemp
												AND pn.codper = lpad(dtp.codper,10,'0')
												AND pn.staper != 3
				INNER JOIN sno_personal p ON pn.codemp = p.codemp 
										 AND pn.codper = p.codper
				INNER JOIN sno_nomina n ON n.codemp = pn.codemp
									   AND n.codnom = pn.codnom
							   AND n.espnom='0'
				INNER JOIN sno_unidadadmin ua ON pn.codemp = ua.codemp
								  AND pn.minorguniadm = ua.minorguniadm
								  AND pn.ofiuniadm = ua.ofiuniadm
								  AND pn.uniuniadm = ua.uniuniadm
								  AND pn.depuniadm = ua.depuniadm
								  AND pn.prouniadm = ua.prouniadm
				INNER JOIN scv_misiones mis ON mis.codemp = sv.codemp
								   AND mis.codmis = sv.codmis
				LEFT JOIN sno_cargo ca ON pn.codemp = ca.codemp
							  AND pn.codnom = ca.codnom
							  AND pn.codcar = ca.codcar
				LEFT JOIN sno_asignacioncargo ac ON pn.codemp = ac.codemp
								AND pn.codnom = ac.codnom
								AND pn.codasicar = ac.codasicar
				LEFT JOIN sno_ubicacionfisica uf ON pn.codemp = uf.codemp
								AND pn.codubifis = uf.codubifis
				LEFT JOIN covensol_sigesp_equiv e_estsolvia ON e_estsolvia.dominio='scv_solicitudviatico'
									   AND e_estsolvia.campo='estsolvia'
									   AND e_estsolvia.valor= sv.estsolvia::text
				WHERE dtp.codemp = '0001'
				  AND sv.fecsolvia BETWEEN '2014-12-01' AND '2015-08-26' 
				ORDER BY sv.codsolvia,sv.fecsolvia
		

26/08/2015 14:14:05  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_scv_c_viaticos <br><b>METODO:</b> SelectInfoViaticoPersona <br><b>ERROR->:</b><br>Invalid query: ERROR:  el operador no existe: character varying <> integer
LINE 32:             AND pn.staper != 3
                                   ^
HINT:  Ningún operador coincide con el nombre y el tipo de los argumentos. Puede desear agregar conversiones explícitas de tipos.
Whole query:  		
				SELECT p.codper,(p.nomper||' '||p.apeper) AS nomape,ua.desuniadm,uf.desubifis,
					   e_estsolvia.descequiv AS desc_estsolvia,p.cedper,p.codper, 
					   (CASE DATE_PART('month',sv.fecsolvia) WHEN '1' THEN 'enero' 
									  WHEN '2' THEN 'febrero'
									  WHEN '3' THEN 'marzo'
									  WHEN '4' THEN 'abril'
									  WHEN '5' THEN 'mayo'
									  WHEN '6' THEN 'junio'
									  WHEN '7' THEN 'julio'
									  WHEN '8' THEN 'agosto'
									  WHEN '9' THEN 'septiembre'
									  WHEN '10' THEN 'octubre'
									  WHEN '11' THEN 'noviembre'
									  WHEN '12' THEN 'diciembre'				      
													  ELSE 'numero de mes inválido' END) AS desmes,
					   (CASE n.racnom WHEN '1' THEN ac.denasicar ELSE ca.descar END) AS cargo,
					   dtp.monpervia, pn.codnom,
					   'SCV-0'||lpad(sv.codsolvia,10,'0') AS codsolvia,
					   sv.fecsalvia,sv.fecregvia,sv.fecsolvia,
					   (SELECT DISTINCT ON(codrut) desrut
					  FROM scv_rutas rut
					 WHERE sv.codemp=rut.codemp
					   AND sv.codrut=rut.codrut
					 GROUP BY codrut,desrut) AS desrut,
					   mis.denmis
				FROM scv_dt_personal dtp
				INNER JOIN scv_solicitudviatico sv ON sv.codemp = dtp.codemp
									  AND sv.codsolvia = dtp.codsolvia
				INNER JOIN sno_personalnomina pn ON pn.codemp = dtp.codemp
												AND pn.codper = lpad(dtp.codper,10,'0')
												AND pn.staper != 3
				INNER JOIN sno_personal p ON pn.codemp = p.codemp 
										 AND pn.codper = p.codper
				INNER JOIN sno_nomina n ON n.codemp = pn.codemp
									   AND n.codnom = pn.codnom
							   AND n.espnom='0'
				INNER JOIN sno_unidadadmin ua ON pn.codemp = ua.codemp
								  AND pn.minorguniadm = ua.minorguniadm
								  AND pn.ofiuniadm = ua.ofiuniadm
								  AND pn.uniuniadm = ua.uniuniadm
								  AND pn.depuniadm = ua.depuniadm
								  AND pn.prouniadm = ua.prouniadm
				INNER JOIN scv_misiones mis ON mis.codemp = sv.codemp
								   AND mis.codmis = sv.codmis
				LEFT JOIN sno_cargo ca ON pn.codemp = ca.codemp
							  AND pn.codnom = ca.codnom
							  AND pn.codcar = ca.codcar
				LEFT JOIN sno_asignacioncargo ac ON pn.codemp = ac.codemp
								AND pn.codnom = ac.codnom
								AND pn.codasicar = ac.codasicar
				LEFT JOIN sno_ubicacionfisica uf ON pn.codemp = uf.codemp
								AND pn.codubifis = uf.codubifis
				LEFT JOIN covensol_sigesp_equiv e_estsolvia ON e_estsolvia.dominio='scv_solicitudviatico'
									   AND e_estsolvia.campo='estsolvia'
									   AND e_estsolvia.valor= sv.estsolvia::text
				WHERE dtp.codemp = '0001'
				  AND sv.fecsolvia BETWEEN '2014-12-01' AND '2015-08-26' 
				ORDER BY sv.codsolvia,sv.fecsolvia