DSXchange

Hi Everyone,


I get this Fatal Error when I run this job which extracts from Sybase to Oracle DB. Has anyone seen this before.




main_program: The TCP port being used for startup is 239478040; the associated socket number is 135924816.

main_program: unanticipated failure; please save output and contact Ascential Software.


main_program: Unable to contact one or more Section Leaders.
Probable configuration problem; contact Orchestrate system administrator.
[processmgr/pmpar.C:295]


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.
[processmgr/spawn.C:317]


main_program: APT_PMConnectionRecord::start: unable to create connection port [processmgr/newcontact.C:824]

main_program: APT_PMListenerPort: socket call failed: Too many open files [processmgr/inetutil.C:242]








Regards
Suresh

I will assume that you are not doing distributed or grid processing. Login to a UNIX shell then:

1. source the dsenv file . `cat /.dshome`/dsenv
2. export APT_CONFIG=$DSHOME/../Configurations/default.apt
3. orchadmin check

What does the orchadmin command return?

##I IIS-DSEE-TFCN-00006 01:45:24(001) <main_program> conductor uname: -s=Linux; -r=2.6.9-67.ELsmp; -v=#1 SMP Wed Nov 7 13:56:44 EST 2007; -n=dbdevdst; -m=x86_64
##I IIS-DSEE-TCOA-00067 01:45:24(002) <main_program> OS charset: ISO-8859-1.
##I IIS-DSEE-TCOA-00068 01:45:24(003) <main_program> Input charset: UTF-8.
##I IIS-DSEE-TFSC-00001 01:45:24(004) <main_program> APT configuration file: /op t/IBM/InformationServer/Server/Configurations/default.apt
##I IIS-DSEE-TOIX-00059 01:45:24(000) <APT_RealFileExportOperator in APT_FileExp ortOperator,0> Export complete; 5 records exported successfully, 0 rejected.
##I IIS-DSEE-TFSC-00010 01:45:24(005) <main_program> Step execution finished wit h status = OK.
##I IIS-DSEE-TCOA-00071 01:45:24(006) <main_program> Config file checker on node node3 reports 0 error(s), 0 warning(s).
.
##I IIS-DSEE-TCOA-00071 01:45:24(007) <main_program> Config file checker on node node2 reports 0 error(s), 0 warning(s).
.
##I IIS-DSEE-TCOA-00071 01:45:24(008) <main_program> Config file checker on node node4 reports 0 error(s), 0 warning(s).
.
##I IIS-DSEE-TCOA-00071 01:45:24(009) <main_program> Total virtual memory on nod e node1 is 34102.5 MB.
.
##I IIS-DSEE-TCOA-00071 01:45:24(010) <main_program> Config file checker on node node1 reports 0 error(s), 0 warning(s).
.
##I IIS-DSEE-TCOA-00072 01:45:24(011) <main_program> 0 error(s) detected.
##I IIS-DSEE-TCOA-00073 01:45:24(012) <main_program> 0 warning(s) detected.
[dsadm@dbdevdst ~]$

That has verified that your configuration file is syntactically (and semantically) correct, which needed to be eliminated first.

Now read the next part of the error message, about not having rsh set up properly or $APT_ORCHHOME not visible on all nodes.