APT_ParallelSortMergeOperator: Error
Moderators: chulett, rschirm, roy
APT_ParallelSortMergeOperator: Error
Hi,
My Datastage jobs which were running fine with certain input files have started aborting when i changed the input files.
The input file is a Fileset. Iam getting the below error when i run the DataStage job with a certain input FileSet.
"APT_ParallelSortMergeOperator: Error when checking operator: Key field "GUEST_I" not found in view-adapted input schema. This may indicate an error in 'setOutputSortKeys()' in an upstream operator."
I have made sure that the field GUEST_I is present in the input file and is in Table definition of all the stages.
Please help me in understanding what the exact error is and some possible solutions.
Rgds,
Pinkesh
My Datastage jobs which were running fine with certain input files have started aborting when i changed the input files.
The input file is a Fileset. Iam getting the below error when i run the DataStage job with a certain input FileSet.
"APT_ParallelSortMergeOperator: Error when checking operator: Key field "GUEST_I" not found in view-adapted input schema. This may indicate an error in 'setOutputSortKeys()' in an upstream operator."
I have made sure that the field GUEST_I is present in the input file and is in Table definition of all the stages.
Please help me in understanding what the exact error is and some possible solutions.
Rgds,
Pinkesh
Hi,
I am getting the following error when i am running the same job with an input file containing 300K records.
"CopyOfGTLJB0500.#0.TrmMfdDaysSinceLastVisitQty.LkFromBOMitmMfdW-Input.LkFromBOMitmMfdW: ds_ipcgetnext - timeout waiting for mutex."
And I am getting the following error even when running the job with records less than 1000.
"main_program: ORCHESTRATE step execution terminating due to SIGINT"
Can anybody help me on this. Hihgly appreciate your prompt help.
Thanks & Regards
Pinkesh
I am getting the following error when i am running the same job with an input file containing 300K records.
"CopyOfGTLJB0500.#0.TrmMfdDaysSinceLastVisitQty.LkFromBOMitmMfdW-Input.LkFromBOMitmMfdW: ds_ipcgetnext - timeout waiting for mutex."
And I am getting the following error even when running the job with records less than 1000.
"main_program: ORCHESTRATE step execution terminating due to SIGINT"
Can anybody help me on this. Hihgly appreciate your prompt help.
Thanks & Regards
Pinkesh
APT_ParallelSortMergeOperator: Error
Please post the generated OSH script.
Thanks,
BP
Thanks,
BP
APT_ParallelSortMergeOperator: Error
It should be in the RT_BP(??) directory that is created on the server for that particular job.
-BP
-BP
APT_ParallelSortMergeOperator: Error
If you look through the director log for that job, you should be able to find a reference to the right directory.
-BP
-BP
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
SELECT NAME, JOBNO FROM DS_JOBS WHERE NAME = 'name_of_job';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
1.Using DS Administrator GUI set OSH_ECHO=True (located under Parallel\Reporting)pkothana wrote:Hi BP,
Thanks for your time.
Pls let me know where can i see this generated OSH script?
Thanks and Regards
Pinkesh
2.Validate the job
3.In the Director open the job log entry that starts with
main_program: Echo:
Vitali.
I do have a program that shows the main OSH code on the GUI interface. It does not show the Transformer OSH code (there may be a newer version that does that). But for now and for this job, I bet we could identify the code that is causing you problem.
PM me with contact info.
-T.J.
PM me with contact info.
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).