Completion Date Earlier Than Start Date
COMP_DTS has a lower date and time stamp value than QUEUE_DTS and START_DTS
COMP_DTS value is calculated by the database where as QUEUE_DTS and START_DTS is updated by SARM server (ASAP Unix Box) while the ASDL's are provisioning.
The Time Stamp and Date for all systems BEA/ASAP/Database and the integrated Upstream/Downstream systems should all be in sync to avoid this issue.
Database
SQL> select SYSDATE from dual;
ASAP Unix Box
Unix Command: date
COMP_DTS value is calculated by the database where as QUEUE_DTS and START_DTS is updated by SARM server (ASAP Unix Box) while the ASDL's are provisioning.
The Time Stamp and Date for all systems BEA/ASAP/Database and the integrated Upstream/Downstream systems should all be in sync to avoid this issue.
Database
SQL> select SYSDATE from dual;
ASAP Unix Box
Unix Command: date
0