Orchadmin - Unix error 10,061

[jhmckeever]

Hi everyone,

We're trying to use orchadmin commands on a Windows-based Information Server installation, but are not having much luck ...

Code: Select all

E:\MyDatasetDir>orchadmin describe dsMyData.ds
<snip>

##I IIS-DSEE-TFCN-00006 10:36:57(001) <main_program> conductor uname: -s=Windows Server 2012; -r=; -v=6.2; -n=MYSERVERNAME; -m=x86-Intel
##I IIS-DSEE-TFSC-00001 10:36:57(002) <main_program> APT configuration file: C:/Users/dmadmin.MYDOMAIN/AppData/Local/Temp/2/aptoa453299c5a186
##E IIS-DSEE-TFIO-00211 10:36:59(000) <APT_RealFileExportOperator in APT_FileExportOperator,0> APT_Communicator::connectTo: connect() failed due to Unix error = 10,061 (Unknown error) on node MYSERVERNAME using ConnectionInfo object 'TCP,  connection Host: MYSERVERNAME.MYDOMAIN.com (10.25.3.166), TCP port number: 0', RETRYING connect()
##E IIS-DSEE-TFIO-00211 10:37:00(000) <APT_RealFileExportOperator in APT_FileExportOperator,0> APT_Communicator::connectTo: connect() failed due to Unix error = 10,061 (Unknown error) on node MYSERVERNAME using ConnectionInfo object 'TCP,  connection Host: MYSERVERNAME.MYDOMAIN.com (10.25.3.166), TCP port number: 0', RETRYING connect(
)
##F IIS-DSEE-TFIO-00112 10:37:00(001) <APT_RealFileExportOperator in APT_FileExportOperator,0> Fatal Error: APT_Communicator::pmSendPartitionInfo() failed on node MYSERVERNAME for partition 0 of dataset 0 (write failed to handle 5) Bad file descriptor
##E IIS-DSEE-TFPM-00192 10:37:00(000) <node_node1> Player 2 terminated unexpectedly.
##E IIS-DSEE-TFPM-00338 10:37:00(000) <main_program> APT_PMsectionLeader(1, node1), player 2 - Unexpected exit status 1.
##E IIS-DSEE-TFPM-00339 10:37:00(001) <main_program> APT_PMsectionLeader(1, node1), player 1 - Unexpected termination by Unix signal 15(SIGTERM).

We've set up ipv4 and ipv6 host references the way we think we should on that server ...

Code: Select all

# C:\Windows\System32\drivers\etc\hosts file

127.0.0.1	localhost						 # Information Server (ipv4)
127:0:0:1	MYSERVERNAME					 # Information Server (ipv4)
127:0:0:1	MYSERVERNAME.MYDOMAIN.COM	# Information Server (ipv4)

::1 		localhost						 # Information Server (ipv6)
::1 		MYSERVERNAME					 # Information Server (ipv6)
::1 		MYSERVERNAME.MYDOMAIN.COM	# Information Server (ipv6)

... but still get the error. Can anyone provide any advice?

Thanks,

[SURA]

It is worth to check the settings again.

Make sure host file has two entries and ping it.


http://www-01.ibm.com/support/docview.w ... wg21961605

Same information, in case if the link didn't work.

Code: Select all

1. Set APT_CONFIG_FILE to your configuration file
For example:
set APT_CONFIG_FILE=C:\IBM\InformationServer\Server\Configurations\default.apt
2. Set APT_ORCHHOME =C:\IBM\InformationServer\Server\PXEngine
3. From directory C:\IBM\InformationServer\Server\PXEngine\bin
enter
sh -c "orchadmin delete <Path>/Datasetname.ds"

If you would like to delete many files then below is an example:

sh -c "orchadmin delete `ls D:/My_Projects/Dataset/ABC*.ds`"

Note that the "\" (backslash) characters have to be replaced by "/"
(slash) characters. and that the command passed to the shell itself
need to be enclosed between quotes. 

[jhmckeever]

Thanks, but we don't see anything funny in our setup ...

Code: Select all

E:\IBM\InformationServer\Server\PXEngine\bin>env
<SNIP>
APT_CONFIG_FILE=E:\IBM\InformationServer\Server\Configurations\default.apt
APT_ORCHHOME=E:\IBM\InformationServer\Server\PXEngine
<SNIP>

E:\IBM\InformationServer\Server\PXEngine\bin>sh -c "orchadmin describe E:\\Data\\dev\\datasets\\dsActuals.ds"
<SNIP - Same error as original post>
##E IIS-DSEE-TFSC-00011 11:23:34(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOA-00041 11:23:34(001) <main_program> Describe FAILED for E:\Data\dev\datasets\dsActuals.ds.

Thanks again,

[SURA]

Have you tried this?

http://www-01.ibm.com/support/docview.w ... wg21622965

Code: Select all

Technote (troubleshooting)

Problem(Abstract)

Errors related to this issue:

unable to connect to port 10000 on conductor; socket = 0, Unknown error

APT_Communicator::connectTo: connect() failed due to Unix error = 10,061 (Unknown error) on node HOST_NAME using ConnectionInfo object 'TCP, connection Host: HOST_NAME (IP_ADDRESS), TCP port number: 0', RETRYING connect()
Resolving the problem

Hosts should have at least the following 2 entries:

# localhost name resolution is handled within DNS itself.
127.0.0.1 localhost
::1 localhost

You should be able to ping localhost via V4 and V6 IP topologies:
ping -4 localhost
ping -6 localhost

Set $APT_USE_IPV4=1 as the default in all projects or set this as Windows default environment.

Steps to set $APT_USE_IPV4 DataStage Administrator client:

    Select Projects tab
    Select Project
    Click Properties
    Click Environment button
    Click Parallel Category
    Locate APT_USE_IPV4 and set to TRUE

[jhmckeever]

Have you tried this?
Set $APT_USE_IPV4=1 as the default in all projects ...

*** or set this as Windows default environment.***

Ha! That was the problem. We'd set it up in our projects but had totally forgotten to set it in the console. Thanks very much SURA!

J.