DSXchange

Posted: **Fri Aug 20, 2010 5:51 am**

Hi All, we have been receiving the following error on some of our jobs:

main_program: ERROR: gethostbyname(dcob04) returned null; node node1 cannot be used.

If the job is re-started it runs fine.

What's common about the jobs that are failing are they all read from the same Oracle Database. Jobs may run fine for weeks then fail.

Jobs are simple and similar

Oracle Enterprise --->Transformer------>Teradata Multiload

Posted: **Fri Aug 20, 2010 5:56 am**

Sorry here is some extra info and configuration file:

main_program: Unable to define node 'node1'.
Probable configuration problem; contact Orchestrate system administrator.

main_program: APT configuration file: /home/dsadm/Ascential/DataStage/Configurations/2 Nodes Prod.apt
{
node "node1"
{
fastname "dcob04"
pools ""
resource disk "/home/dsadm/Ascential/DataStage/Datasets/ProdDatasets" {pools ""}
resource scratchdisk "/home/dsadm/Ascential/DataStage/Datasets/Scratch" {pools ""}
}
node "node2"
{
fastname "dcob04"
pools ""
resource disk "/home/dsadm/Ascential/DataStage/Datasets/ProdDatasets" {pools ""}
resource scratchdisk "/home/dsadm/Ascential/DataStage/Datasets/Scratch" {pools ""}
}
}

Posted: **Fri Aug 20, 2010 12:45 pm**

Wondering this may related to Linux. We are running Red Hat.

Posted: **Fri Aug 20, 2010 6:31 pm**

Do you have Null handling in place?