Page 1 of 1
Job sequence -
Posted: Wed May 07, 2008 4:21 pm
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
Posted: Wed May 07, 2008 4:32 pm
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.
here's log of job
Posted: Wed May 07, 2008 4:59 pm
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.
Posted: Wed May 07, 2008 7:33 pm
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?