ETL jobs in SAS Markdown Optimization such as Load_STG2DM_Vehicle and Load_STG2DM_Vehicle_attr, might fail to respond when used with an Oracle database because they cannot complete the update/insert loads to the database. These jobs currently use an update/insert technique which uses a DATA step modify by column that fails with Oracle. The jobs do not return successfully and have to be manually terminated.

A workaround for this issue is to load the Oracle tables using the APPEND procedure. The following is an example for the vehicle table.

PROC APPEND BASE=DI_DM2RE.VEHICLE
      (DBSASTYPE=(START_DT='DATE9.'
          END_DT='DATE9.'
          IMPACT_START_DT='DATE9.'
          IMPACT_END_DT='DATE9.'
          APPROVED_BY_DT='DATE9.'
                  )
       )
      DATA=WORK.MAPPED FORCE;
   RUN;

NOTE: To avoid an integrity constraints violation (since since WORK.MAPPED includes both new and updated items), you must delete all records from the BASE= tables before running PROC APPEND. In addition, make sure you use the DATE option while appending if you chose to run PROC APPEND.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Merchandise Intelligence 3.2 is available at: