APT_ParallelSortMergeOperator: Error

pkothana · Post by **pkothana** » Fri Dec 12, 2003 7:20 am

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

pkothana · Post by **pkothana** » Sat Dec 13, 2003 2:45 am

Hi,
Is this happening because of space? The Same job when rane with much lesser data is working fine.
Pls let me know what can be the solution for this?
How can we optimize the space requirement?

Thanks & Regards
Pinkesh

pkothana · Post by **pkothana** » Sat Dec 13, 2003 6:55 am

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

bigpoppa · Post by **bigpoppa** » Mon Dec 15, 2003 4:51 pm

Please post the generated OSH script.

Thanks,
BP

pkothana · Post by **pkothana** » Tue Dec 16, 2003 9:40 am

Hi BP,

Thanks for your time.

Pls let me know where can i see this generated OSH script?

Thanks and Regards
Pinkesh

bigpoppa · Post by **bigpoppa** » Tue Dec 16, 2003 12:54 pm

It should be in the RT_BP(??) directory that is created on the server for that particular job.
-BP

pkothana · Post by **pkothana** » Wed Dec 17, 2003 6:18 am

Hi BP,
There are soooooooo many RT_BP files i.e. RT_BP1, RT_BP2.....RT_BP400 etc.........

Pls let me know how can i identify the file for particular job.
Appreciate if you can tell me the significance of thie RT_BP files also.

Thank & Regards
Pinkesh

pkothana · Post by **pkothana** » Wed Dec 17, 2003 6:18 am

Hi BP,
There are soooooooo many RT_BP files i.e. RT_BP1, RT_BP2.....RT_BP400 etc.........

Pls let me know how can i identify the file for particular job.
Appreciate if you can tell me the significance of thie RT_BP files also.

Thank & Regards
Pinkesh

bigpoppa · Post by **bigpoppa** » Wed Dec 17, 2003 10:11 am

If you look through the director log for that job, you should be able to find a reference to the right directory.

-BP

ray.wurlod · Post by **ray.wurlod** » Wed Dec 17, 2003 3:33 pm

Code: Select all

SELECT NAME, JOBNO FROM DS_JOBS WHERE NAME = 'name_of_job';

The JOBNO gives you a job number. The directory you need is RT_BPnn where nn is the job number.

vzoubov · Post by **vzoubov** » Wed Dec 17, 2003 6:50 pm

pkothana wrote:Hi BP,

Thanks for your time.

Pls let me know where can i see this generated OSH script?

Thanks and Regards
Pinkesh

1.Using DS Administrator GUI set OSH_ECHO=True (located under Parallel\Reporting)
2.Validate the job
3.In the Director open the job log entry that starts with
main_program: Echo:

Vitali.

Teej · Post by **Teej** » Wed Dec 17, 2003 9:28 pm

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.

Benouche · Post by **Benouche** » Mon Jan 26, 2004 9:57 am

Pinkesh,

did you solve this problem ?
I'm actually facing the same problem migrating to v7.

Thanks !
Benouche