Problem Loading into OCI9 stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ady
Premium Member
Premium Member
Posts: 189
Joined: Thu Oct 12, 2006 12:08 am

Problem Loading into OCI9 stage

Post by ady »

having problem loading the data into oracle database. the job runs successfully but not loading the final data into the database . the link to the database doesnt show any info.
in the log files it shows as
Type:Control Event : finished job
Type :Reset Event :Log prior to last 2 runs cleared by user
Type:Reset Event: Auto-purged 18 log entries.

how do i fix this problem?
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

The log messages you have provided does not give enough information to find the problem.
All it means that you have Auto-purge enabled, so it clears jobs logs upto 2 previous job runs.
Copy and paste the error/warning messages (if any) you get prior to these entries.

Also check to see if the extract query on source results in any rows.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Post Reply