I have a set of around 74 K records in a dataset, which i have to insert into a new table. When i try to run a parallel job, that has a Dataset(source), Transformer and a target Oracle table, I get the following errors from the director:
main_program: APT_PMConnectionRecord::start: waitpid(18708, 0, 0) returned -1, No child processes
main_program: **** Parallel startup failed ****
This is usually due to a configuration error, such as
not having the Orchestrate install directory properly
mounted on all nodes, rsh permissions not correctly
set (via /etc/hosts.equiv or .rhosts), or running from
a directory that is not mounted on all nodes. Look for
error messages in the preceding output.
main_program: A startup script is not being used.
main_program: Unable to contact one or more Section Leaders.
Probable configuration problem; contact Orchestrate system administrator.
For the job, i have four nodes defined in the configuration file.
Interestingly, i am able to create a table and load 5 million records using the same configuration file.
Any Idea what could be the reason for such a problem to occur?
The process table is a low level component in UNIX (think of the pid as a row number in this table). There is one entry associated with each process; it's used to keep track of timeslice, execution priority, and so on.
The fact that you can execute when not writing to a table seems to exonerate the process table as a candidate cause. Hence my original opening "it's rare".
Have you checked all the things mentioned in the error message? This seems to suggest an incomplete installation or incomplete configuration of the underlying "Orchestrate" engine, or insufficient remote execution access/privileges.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks,
Not specifying the remote server has been the error.
It was done in the prior job, which loaded the table, but not in this job..Hence the error.
But, the error message a bit confusing in this regard..!!
Nelab
How was this dataset created?? Was it created using the same configuration file?? This kind of error frequently happens when the config file or datastet are ported from dev to test.
Thanks
dsxuserrio
Yes, The dataset was created using the same configuration file. There was no porting done, across projects or systems.
Well, while porting the projects, from dev to test/ prdn., checking on the configuration file, and to maintain consistencies will avoid any such errors.
But my problem was that, it was not reflecting the error message that "the db server" was not mentioned. Rather the log indicates relook at the configuration/installation.