2020-08-23 20:53:45,147{Europe/Brussels}  ERROR [com.traxxeo.buildixx.model.views.DebuggableView] (http-thread-pool-8081(21)) JBO-27122: Erreur SQL lors de la pr鰡ration d'une instruction. Instruction : SELECT * FROM (select OPERATION_CENTER_ID,
    GUI_USER_ID,
    PERSON_ID,
    PERSON_DATA_ID,
    VEHICLE_DATA_ID,
    EVENT_DATE,
    EVENT_DATE_STR,
    EVENT_TYPE_HARD,
    EVENT_NAME,
    VEHICLE_ID,
    FIXED_UNIT_ID,
    VEHICLE_NAME,
    GRAPHICAL_SYMBOL,
    EVENT_TYPE,
    TOTAL_KM,
    TOTAL_HR,
    VEHICLE_DATA_RG_ADRESS,
    VEHICLE_DATA_SPEED,
    POI_NAME,
    POI_ID_LIST,
    WGS84_LATITUDE,
    WGS84_LONGITUDE,
    COMMENTS from V_ADF_PERSON_HISTORY
    where PERSON_ID = ?
    and gui_user_id=?
    and ((? is null and to_char(EVENT_DATE,'dd/MM/yyyy') = to_char(sysdate,'dd/MM/yyyy'))
or (EVENT_DATE >= ? and EVENT_DATE <= ?))) QRSLT  ORDER BY person_data_id desc DebuggableView.executeQueryForCollection name= VPersonDayTrackingView1
2020-08-23 20:53:45,147{Europe/Brussels}  ERROR [com.traxxeo.buildixx.model.views.DebuggableView] (http-thread-pool-8081(21)) QUERY:SELECT * FROM (select OPERATION_CENTER_ID,
    GUI_USER_ID,
    PERSON_ID,
    PERSON_DATA_ID,
    VEHICLE_DATA_ID,
    EVENT_DATE,
    EVENT_DATE_STR,
    EVENT_TYPE_HARD,
    EVENT_NAME,
    VEHICLE_ID,
    FIXED_UNIT_ID,
    VEHICLE_NAME,
    GRAPHICAL_SYMBOL,
    EVENT_TYPE,
    TOTAL_KM,
    TOTAL_HR,
    VEHICLE_DATA_RG_ADRESS,
    VEHICLE_DATA_SPEED,
    POI_NAME,
    POI_ID_LIST,
    WGS84_LATITUDE,
    WGS84_LONGITUDE,
    COMMENTS from V_ADF_PERSON_HISTORY
    where PERSON_ID = ?
    and gui_user_id=?
    and ((? is null and to_char(EVENT_DATE,'dd/MM/yyyy') = to_char(sysdate,'dd/MM/yyyy'))
or (EVENT_DATE >= ? and EVENT_DATE <= ?))) QRSLT  ORDER BY person_data_id desc