Job sequence -

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
sandeshmp
Participant
Posts: 2
Joined: Wed Feb 06, 2008 4:04 pm

Job sequence -

Post by sandeshmp »

I have a squence ROLE_SEQ with Jobs :
1)ROLE_JOB
2) ROLE_INDV_JOB
3)ROLE_FND_JOB,
4)ROLE_SVC_RQST_TYP_JOB

There are no errors except few warnings, but no data gettong populated in target. when run Individaully, they run fine.

Given below is the log file, plz help.



DataStage Report - Summary Log for job: SEQ_ROLE


Occurred: 4:22:31 AM On date: 5/5/2008 Type: Control
Event: Starting Job SEQ_ROLE. (...)

Occurred: 4:22:31 AM On date: 5/5/2008 Type: Info
Event: Environment variable settings: (...)

Occurred: 4:22:31 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH

Occurred: 4:22:31 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@Coordinator): Starting new run of checkpointed Sequence job

Occurred: 4:22:38 AM On date: 5/5/2008 Type: RunJob
Event: SEQ_ROLE -> (ROLE_JOB): Job run requested (...)

Occurred: 4:22:38 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSRunJob): Waiting for job ROLE_JOB to start

Occurred: 4:22:39 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Waiting for job ROLE_JOB to finish

Occurred: 4:22:44 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Job ROLE_JOB has finished, status = 2 (Finished with warnings)

Occurred: 4:22:44 AM On date: 5/5/2008 Type: Warning
Event: SEQ_ROLE..JobControl (@ROLE_JOB): Job ROLE_JOB did not finish OK, status = 'Finished with warnings'

Occurred: 4:22:44 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_JOB): Report on job: ROLE_JOB (...)

Occurred: 4:22:44 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_JOB): Checkpointed run of job 'ROLE_JOB'

Occurred: 4:22:50 AM On date: 5/5/2008 Type: RunJob
Event: SEQ_ROLE -> (ROLE_INDV_JOB): Job run requested (...)

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSRunJob): Waiting for job ROLE_INDV_JOB to start

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Waiting for job ROLE_INDV_JOB to finish

Occurred: 4:22:55 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Job ROLE_INDV_JOB has finished, status = 2 (Finished with warnings)

Occurred: 4:22:55 AM On date: 5/5/2008 Type: Warning
Event: SEQ_ROLE..JobControl (@ROLE_INDV_JOB): Job ROLE_INDV_JOB did not finish OK, status = 'Finished with warnings'

Occurred: 4:22:55 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_INDV_JOB): Report on job: ROLE_INDV_JOB (...)

Occurred: 4:22:55 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_INDV_JOB): Checkpointed run of job 'ROLE_INDV_JOB'

Occurred: 4:23:01 AM On date: 5/5/2008 Type: RunJob
Event: SEQ_ROLE -> (ROLE_FND_JOB): Job run requested (...)

Occurred: 4:23:01 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSRunJob): Waiting for job ROLE_FND_JOB to start

Occurred: 4:23:02 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Waiting for job ROLE_FND_JOB to finish

Occurred: 4:23:07 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Job ROLE_FND_JOB has finished, status = 2 (Finished with warnings)

Occurred: 4:23:07 AM On date: 5/5/2008 Type: Warning
Event: SEQ_ROLE..JobControl (@ROLE_FND_JOB): Job ROLE_FND_JOB did not finish OK, status = 'Finished with warnings'

Occurred: 4:23:07 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_FND_JOB): Report on job: ROLE_FND_JOB (...)

Occurred: 4:23:07 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_FND_JOB): Checkpointed run of job 'ROLE_FND_JOB'

Occurred: 4:23:20 AM On date: 5/5/2008 Type: RunJob
Event: SEQ_ROLE -> (ROLE_SVC_RQST_TYP_JOB): Job run requested (...)

Occurred: 4:23:20 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSRunJob): Waiting for job ROLE_SVC_RQST_TYP_JOB to start

Occurred: 4:23:21 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Waiting for job ROLE_SVC_RQST_TYP_JOB to finish

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (DSWaitForJob): Job ROLE_SVC_RQST_TYP_JOB has finished, status = 2 (Finished with warnings)

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Warning
Event: SEQ_ROLE..JobControl (@ROLE_SVC_RQST_TYP_JOB): Job ROLE_SVC_RQST_TYP_JOB did not finish OK, status = 'Finished with warnings'

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_SVC_RQST_TYP_JOB): Report on job: ROLE_SVC_RQST_TYP_JOB (...)

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@ROLE_SVC_RQST_TYP_JOB): Checkpointed run of job 'ROLE_SVC_RQST_TYP_JOB'

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@Coordinator): Removed checkpoint record at successful completion of sequence

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@Coordinator): Note: Sequencer 'Sequencer' was entered, but never exited

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Info
Event: SEQ_ROLE..JobControl (@Coordinator): Summary of sequence run (...)

Occurred: 4:23:26 AM On date: 5/5/2008 Type: Control
Event: Finished Job SEQ_ROLE.

End of report.

+3
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You need to check the individual job logs that had the warnings, you can't get those details from the Sequence's log.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sandeshmp
Participant
Posts: 2
Joined: Wed Feb 06, 2008 4:04 pm

here's log of job

Post by sandeshmp »

DataStage Report - Summary Log for job: ROLE_INDV_JOB
Items: 1 - 234
Sorted on: Date Sorter
Entries are filtered

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Control
Event: Starting Job ROLE_INDV_JOB. (...)

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Info
Event: Environment variable settings: (...)

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Info
Event: Parallel job initiated

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Info
Event: Parallel job default NLS map ISO-8859-1, default locale OFF

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Warning
Event: main_program: Unrecognized module name "odbcupsert" in environment variable APT_DEBUG_MODULE_NAMES [ifdebug/ifdebug.C:65]

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Info
Event: main_program: Module debug messages on for odbcupsert

Occurred: 4:22:50 AM On date: 5/5/2008 Type: Info
Event: main_program: Ascential DataStage(tm) Enterprise Edition 7.5.2 (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: The open files limit is 100; raising to 65536.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: orchgeneral: loaded (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseOperator::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseOperator::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseOperator::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseCountOp::reportOutputAttachment().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returning from APT_LicenseCountOp::reportOutputAttachment().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseCheckOp::reportInputAttachment().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returning from APT_LicenseCheckOp::reportInputAttachment().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseOperator::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseOperator::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseOperator::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCountOp in APT_LicenseOperator::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCountOp in APT_LicenseOperator::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCountOp in APT_LicenseOperator::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCountOp in APT_LicenseOperator::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCountOp in APT_LicenseOperator::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCountOp in APT_LicenseOperator::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCheckOp in APT_LicenseOperator::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCheckOp in APT_LicenseOperator::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCheckOp in APT_LicenseOperator::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCheckOp in APT_LicenseOperator::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCheckOp in APT_LicenseOperator::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCheckOp in APT_LicenseOperator::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: APT configuration file: /usr/local/dstage/Ascential/DataStage/Configurations/default.apt (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::preDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::describeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::postDescribeOperator().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: This step has no datasets. (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCountOp in APT_LicenseOperator::checkConfig().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCountOp in APT_LicenseOperator::checkConfig().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Calling APT_LicenseCheckOp in APT_LicenseOperator::checkConfig().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator: Returning from APT_LicenseCheckOp in APT_LicenseOperator::checkConfig().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::checkConfig().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::checkConfig().

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseOperator::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_LicenseOperator::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseCountOp in APT_LicenseOperator::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_LicenseCountOp in APT_LicenseOperator::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseCheckOp in APT_LicenseOperator::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_LicenseCheckOp in APT_LicenseOperator::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_CombinedOperatorController::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_CombinedOperatorController::preRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Max inbound connections per node = 0 (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Defining Section Leaders.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Contacting Section Leaders.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Warning
Event: main_program: Warning: the value of the PWD environment variable (/usr/local/softdepot/datastage/Ascential.media) does not appear to be a synonym for the current working directory (/usr/local/dstage/A (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: APT_PM_LocalShell: <rsh> /usr/local/dstage/Ascential/DataStage/PXEngine/etc/standalone.sh /usr/local/dstage/Ascential/DataStage/PXEngine -APT_PMprotoSectionLeaderFlag --APTNoSetupProgram (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Warning
Event: node_node1: Unrecognized module name "odbcupsert" in environment variable APT_DEBUG_MODULE_NAMES [ifdebug/ifdebug.C:65]

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: node_node1: Module debug messages on for odbcupsert

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Broadcasting score.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Score (7064 bytes) sent.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Starting Players.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Waiting for Players to start.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Setting up data connections among Players.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,0: APT_PMPlayer: new Player running, PID = 29135

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Starting step execution.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Waiting for step completion.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator,0: Output 0 produced 1 records.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_LicenseOperator,0: Input 0 consumed 1 records.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,0: Heap growth during runLocally(): 0 bytes

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Releasing Section Leaders; parallel step time was 0.005 seconds.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returning step status of APT_StatusOk.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Step execution finished with status = OK.

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseOperator::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_LicenseOperator::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseCountOp in APT_LicenseOperator::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_LicenseCountOp in APT_LicenseOperator::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_LicenseCheckOp in APT_LicenseOperator::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_LicenseCheckOp in APT_LicenseOperator::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_CombinedOperatorController::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_CombinedOperatorController::postRun()

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Echo: (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Explanation: (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: main_program: Dump: (...)

Occurred: 4:22:51 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Calling ROLE_INDV_JOB::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Returned from ROLE_INDV_JOB::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling Transformer::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returned from Transformer::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Calling ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Returned from ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Calling ROLE_INDV_JOB::reportOutputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Returning from ROLE_INDV_JOB::reportOutputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling Transformer::reportInputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from Transformer::reportInputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling Transformer::reportOutputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from Transformer::reportOutputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Calling ROLE_INDV_DW::reportInputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Returning from ROLE_INDV_DW::reportInputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Calling ROLE_INDV_JOB::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Returning from ROLE_INDV_JOB::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Calling ROLE_INDV_JOB::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Returning from ROLE_INDV_JOB::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Calling ROLE_INDV_JOB::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Returning from ROLE_INDV_JOB::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling Transformer::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from Transformer::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling Transformer::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::reportInputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::reportInputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::reportOutputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::reportOutputAttachment().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returned from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from Transformer::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling Transformer::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from Transformer::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 gfd Type: Info
Event: Transformer: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Calling ROLE_INDV_DW::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Returning from ROLE_INDV_DW::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Calling ROLE_INDV_DW::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Returning from ROLE_INDV_DW::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Calling ROLE_INDV_DW::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Returning from ROLE_INDV_DW::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::preDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::describeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::postDescribeOperator().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: This step has 1 dataset: (...)

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Calling ROLE_INDV_JOB::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB: Returning from ROLE_INDV_JOB::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: Transformer: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Calling ROLE_INDV_DW::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW: Returning from ROLE_INDV_DW::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Calling APT_CombinedOperatorController::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController: Returning from APT_CombinedOperatorController::checkConfig().

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Warning
Event: ROLE_INDV_JOB: When checking operator: When binding output interface field "ROLE_KY" to field "ROLE_KY": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precisio (...)

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Warning
Event: ROLE_INDV_JOB: When checking operator: When binding output interface field "INDV_KY" to field "INDV_KY": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precisio (...)

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Schemas: (...)

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling ROLE_INDV_JOB::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from ROLE_INDV_JOB::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling Transformer::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from Transformer::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling ROLE_INDV_DW::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from ROLE_INDV_DW::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_CombinedOperatorController::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_CombinedOperatorController::preRun()

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Max inbound connections per node = 4 (...)

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Defining Section Leaders.

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: Contacting Section Leaders.

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: main_program: APT_PM_LocalShell: <rsh> /usr/local/dstage/Ascential/DataStage/PXEngine/etc/standalone.sh /usr/local/dstage/Ascential/DataStage/PXEngine -APT_PMprotoSectionLeaderFlag --APTNoSetupProgram (...)

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Warning
Event: node_node1: Unrecognized module name "odbcupsert" in environment variable APT_DEBUG_MODULE_NAMES [ifdebug/ifdebug.C:65]

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Warning
Event: node_node3: Unrecognized module name "odbcupsert" in environment variable APT_DEBUG_MODULE_NAMES [ifdebug/ifdebug.C:65]

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: node_node1: Module debug messages on for odbcupsert

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Warning
Event: node_node2: Unrecognized module name "odbcupsert" in environment variable APT_DEBUG_MODULE_NAMES [ifdebug/ifdebug.C:65]

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: node_node2: Module debug messages on for odbcupsert

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: node_node3: Module debug messages on for odbcupsert

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Warning
Event: node_node4: Unrecognized module name "odbcupsert" in environment variable APT_DEBUG_MODULE_NAMES [ifdebug/ifdebug.C:65]

Occurred: 4:22:52 AM On date: 5/5/2008 Type: Info
Event: node_node4: Module debug messages on for odbcupsert

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Broadcasting score.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Score (27424 bytes) sent.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Starting Players.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Waiting for Players to start.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Setting up data connections among Players.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,1: APT_PMPlayer: new Player running, PID = 29166

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,3: APT_PMPlayer: new Player running, PID = 29167

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB,0: APT_PMPlayer: new Player running, PID = 29165

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,2: APT_PMPlayer: new Player running, PID = 29168

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,0: APT_PMPlayer: new Player running, PID = 29169

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Starting step execution.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Waiting for step completion.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,3: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,1: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,3: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,0: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB,0: Calling ROLE_INDV_JOB::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,0: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB,0: Returning from ROLE_INDV_JOB::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,0: Calling ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,1: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,1: Calling ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,1: Returning from ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,2: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,2: Returning from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,2: Calling ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,3: Calling ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,3: Returning from ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,0: Returning from ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,2: Returning from ROLE_INDV_DW::initializeFromArgs_().

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,0: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,0: Output 0 produced 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB,0: Output 0 produced 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,0: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_JOB,0: Heap growth during runLocally(): 0 bytes

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,1: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,1: Output 0 produced 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,1: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,2: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,2: Output 0 produced 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,2: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,3: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Transformer,3: Output 0 produced 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: ROLE_INDV_DW,3: Input 0 consumed 0 records.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,0: Heap growth during runLocally(): 663552 bytes

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,1: Heap growth during runLocally(): 1056K bytes

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,2: Heap growth during runLocally(): 1056K bytes

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: APT_CombinedOperatorController,3: Heap growth during runLocally(): 1056K bytes

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Releasing Section Leaders; parallel step time was 0.394 seconds.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Returning step status of APT_StatusOk.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Step execution finished with status = OK.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling ROLE_INDV_JOB::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from ROLE_INDV_JOB::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling Transformer::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from Transformer::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_TransformOperatorImplV0S1_ROLE_INDV_JOB_Transformer in Transformer::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling ROLE_INDV_DW::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from ROLE_INDV_DW::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Calling APT_CombinedOperatorController::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Returned from APT_CombinedOperatorController::postRun()

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: main_program: Startup time, 0:02; production run time, 0:00.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Info
Event: Parallel job reports successful completion

Occurred: 4:22:53 AM On date: 5/5/2008 Type: Control
Event: Finished Job ROLE_INDV_JOB.

Occurred: 4:22:53 AM On date: 5/5/2008 Type: RunJob
Event: (SEQ_ROLE) <- ROLE_INDV_JOB: Job under control finished.

End of report.
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Isolate the Warning messages and read them carefully. They contain everything you need to know.

Do you really need to be running in debug mode?
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