set subjects_list [db_list aaa "select unique uned_subject_id  from alf_ehea_subjects vea join v_ehea_grados_asignaturas vega on
          (vea.uned_subject_id = vega.cod_estudios_asignatura and vea.term = vega.curaca) where term = '2011' and cuatrimestre = 2 and state = 'a'
and (to_char(last_sync_date,'YYYYMMDD') <> to_char(sysdate, 'YYYYMMDD')
or last_sync_date IS NULL) order by uned_subject_id"]

set i 0
set error_c 0

foreach subject $subjects_list {

    with_catch errmsg {
        integracion::ehea::sync::subject::students -uned_ehea_subject_id $subject
        incr i
        ns_log Notice "EHEA MANUAL: $subject sincronizada ($i de 62)"
    } {
         incr error_c
         ns_log Notice "EHEA MANUAL: Fallo al sincronizar usuarios en $subject : \n$errmsg"
   }
}
ns_log Notice "EHEA_MANUAL Fin: Correctas: $i Fallos: $error_c"