Unknown Exception from runlocally()

[aniruddha.joglekar]

Hi,


We are facing following problem when trying to run very simple job.

Job reads information from a SQL server table and upserts into another table. No processing happens in between. As a standard practice we are using a PX Transformer to pass data through (without any change to format, length etc.)

+++++++++++++++++++++++++++++++++++++++++++
When running the job, we are getting following error:
main_program: APT configuration file: E:/ascential/datastage/Configurations/default.apt
APT_CombinedOperatorController,0: Caught unknown exception from runLocally(). Operator signalled one or more errors.
APT_CombinedOperatorController,0: Operator terminated abnormally: runLocally did not return APT_StatusOk
main_program: Step execution finished with status = FAILED.

+++++++++++++++++++++++++++++++++++++++++++

The Configuration file for the project looks like this :

*************************************************************
{
node "node1"
{
fastname "2K5"
pools ""
resource disk "e:/ascential/datastage/Datasets" { pools "" }
resource scratchdisk "e:/ascential/datastage/Scratch" { pools "" }
}
}

*************************************************************

We tried cleaning up resources, locks on the job. But it has not acquired any locks, resources and hence does not show anything up. We restarted Datastage services. then the server as well but still it is of no help.

Has any 1 faced similar problem?

Thanks,
Aniruddha

[Krazykoolrohit]

Do you have any warnings. check for rows before you got these errors.

[aniruddha.joglekar]

No warnings at all.

Just after loading of configuration file, I get this error and job aborts.

[ray.wurlod]

Can a network name legally begin with a non-alphabetic character?

[aniruddha.joglekar]

May be it works.

I changed the job to remove transformer and update directly into target table. Then the job works perfectly alright.

Problem seems to be with usage of transformer.

Any idea why this could be heappening?

Aniruddha

[mctny]

is it a basic transformer stage or regular?

[kumar_s]

Try to set the option APT_DISABLE_COMBINABLE to True and use back the transformer and check.

[aniruddha.joglekar]

I'm using regular transformer.

Kumar, as per your suggestion changed the parameter and tried running the job.

Job is not aborting now, however the same error continues.
No records are getting inserted/updated.

In addition to error message, following warning is reported now:
ODBC_Enterprise_10,0: runLocally() did not reach EOF on its input dataset 0. [api\operator_rep.C:3952]

Regards,
Aniruddha