27/01/2021 02:12:30 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SCV_24_2020 ERROR->Invalid query: ERROR: query string argument of EXECUTE is null CONTEXT: PL/pgSQL function eval(text) line 5 at EXECUTE Whole query: UPDATE scv_solicitudviatico SET tascam=1 WHERE tascam=0; ALTER TABLE scv_dt_asignaciones ADD COLUMN montarvia double precision DEFAULT 0; ALTER TABLE scv_dt_asignaciones ADD COLUMN monasig double precision DEFAULT 0; ALTER TABLE scv_dt_asignaciones ADD COLUMN montarext double precision DEFAULT 0; ALTER TABLE scv_dt_asignaciones ADD COLUMN codmontar character varying(5); SELECT eval('UPDATE scv_dt_asignaciones SET montarvia='''||montar||''', monasig='''||monasig||''', montarext='''||montarext||''', codmontar='''||codmontar||''' WHERE codsolvia='''||codsolvia||''' AND proasi='''||proasi||''' AND codasi='''||codasi||''';') FROM ( SELECT det.codsolvia,det.codasi,det.proasi,det.canasi,det.tascam, round(((det.montar*det.tascam))::numeric,2) as montar, round(((det.montar*det.tascam)*det.canasi)::numeric,2) as monasig, det.montar as montarext, (CASE WHEN det.codmontar IS NULL THEN '' ELSE det.codmontar END) as codmontar FROM ( SELECT dt.codsolvia,dt.codasi,dt.proasi,dt.canasi,dt.monasig,dt.montarvia, s.codmon,s.tascam, ( CASE WHEN dt.proasi='TVS' THEN (tar.monbol+tar.mondol+tar.monpas+tar.monhos+tar.monali+tar.monmov) WHEN dt.proasi='TRP' THEN (tartra) WHEN dt.proasi='TDS' THEN (montar) WHEN dt.proasi='TOA' THEN (tarotrasi) ELSE 0 END ) AS montar, ( CASE WHEN dt.proasi='TVS' THEN (tar.codmon) WHEN dt.proasi='TRP' THEN (tra.codmon) WHEN dt.proasi='TDS' THEN (tdis.codmon) WHEN dt.proasi='TOA' THEN (otro.codmon) ELSE '' END ) AS codmontar FROM scv_dt_asignaciones dt INNER JOIN scv_solicitudviatico s ON s.codsolvia = dt.codsolvia LEFT JOIN scv_tarifas tar ON tar.codemp = dt.codemp AND tar.codtar = dt.codasi AND dt.proasi='TVS' LEFT JOIN scv_transportes tra ON tra.codemp = dt.codemp AND tra.codtra = dt.codasi AND dt.proasi='TRP' LEFT JOIN scv_tarifakms tdis ON tdis.codemp = dt.codemp AND tdis.codtar = dt.codasi AND dt.proasi='TDS' LEFT JOIN scv_otrasasignaciones otro ON otro.codemp = dt.codemp AND otro.codotrasi = dt.codasi AND dt.proasi='TOA' ) det ) AS dv