Error on reading with Oracle Eneterprises

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sray2005
Participant
Posts: 1
Joined: Mon Aug 29, 2005 3:17 am

Error on reading with Oracle Eneterprises

Post by sray2005 »

We have recieve following errors very frequently :
---------------------------------------------------------------------------
DataStage Report - Summary Log for job: M_EXTRACT_CDR_DATA_S6
Produced on: 5/2/2007 12:57:07 PM
Project: RAS_PH1_WLESSCU6 Host system: 10.13.20.238
Items: 1 - 17
Sorted on: Date Sorter

Occurred: 12:33:17 PM On date: 5/2/2007 Type: Control
Event: Starting Job M_EXTRACT_CDR_DATA_S6. (...)

Occurred: 12:33:41 PM On date: 5/2/2007 Type: Info
Event: Environment variable settings: (...)

Occurred: 12:33:43 PM On date: 5/2/2007 Type: Info
Event: Parallel job initiated

Occurred: 12:33:53 PM On date: 5/2/2007 Type: Info
Event: main_program: Ascential DataStage(tm) Enterprise Edition 7.5.1A (...)

Occurred: 12:33:57 PM On date: 5/2/2007 Type: Info
Event: main_program: orchgeneral: loaded (...)

Occurred: 12:34:05 PM On date: 5/2/2007 Type: Info
Event: main_program: APT configuration file: /ds4/home/dsadm4/Ascential/DataStage/Configurations/default_db2ee.apt (...)

Occurred: 12:37:27 PM On date: 5/2/2007 Type: Info
Event: main_program: {0}.

Occurred: 12:37:27 PM On date: 5/2/2007 Type: Fatal
Event: main_program: APT_PMsyncWithSectionLeaders: non-zero status 7 from APT_PMpollUntilZero.

Occurred: 12:37:28 PM On date: 5/2/2007 Type: Fatal
Event: main_program: broadcastStepIR: step timed out sending 351,767 byte score; status = 7

Occurred: 12:37:33 PM On date: 5/2/2007 Type: Info
Event: main_program: Error during score broadcast or reload. Score size is 351,767 bytes.

Occurred: 12:37:33 PM On date: 5/2/2007 Type: Fatal
Event: main_program: Step execution finished with status = FAILED.

Occurred: 12:37:42 PM On date: 5/2/2007 Type: Info
Event: main_program: Startup time, 3:44; production run time, 0:00.

Occurred: 12:37:53 PM On date: 5/2/2007 Type: Control
Event: Job M_EXTRACT_CDR_DATA_S6 aborted.

Occurred: 12:57:02 PM On date: 5/2/2007 Type: Reset
Event: Log prior to last run cleared by user

End of report.

---------------------------------------------------------------------------

Hope that I will recieve positive response.
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard. :D

DSXchange is not a substitute for your official support provider. If you can not solve a particular problem yourself, your first port of call should be your support provider - after all, you're paying them to support you.

We're happy enough to comment upon your attempts at diagnosis but you have shown no attempt to do so. What do YOU think the problem is, and why?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply