Disable database job

Important! If Web UI API has been installed previously, the installation process has already created the VALQAGG_INCREMENTALSYNC database job, which aggregates summary data for the Web UI dashboard. Prior to running subsequent installations of Web UI API, your must first disable this job using the following procedure.

  1. Log on to the IEE database as the schema owner (for example, ieedbo).

  2. Execute the following query on the IEE database to disable the job if it is running.

    set serveroutput on; declare job_exists number; begin select count(*) into job_exists from user_SCHEDULER_JOBS where job_name = 'VALQAGG_INCREMENTALSYNC' and enabled = 'TRUE'; if( job_exists = 1 ) then DBMS_SCHEDULER.DISABLE('VALQAGG_INCREMENTALSYNC'); dbms_output.put_line('Disabling the job VALQAGG_INCREMENTALSYNC'); else dbms_output.put_line('Job is not running'); end if; end; /

Note: If the following IEE REST API services are running, the Web UI API upgrade may fail:

  • Itron IEE Reading Service
  • Itron IEE Configuration Service
  • Itron IEE SystemConfig Service
  • Itron IEE Gateway Service
  • Itron IEE StreamData Service

Be sure to stop these services prior to upgrading or uninstalling.