DSXchange

Are the parameters $ORADB, $OraDBUserID
and $OraDBPswd defined in the job and as Project level env variables in the 7.5.2 project?

yes they are...

I checked all the logs of the job and did not found the DSCAPIOP_* parameters. Just last questions before i mark this thread as resolved, can this kind of problem originate if the job was created using 7.5 rather than 7.5x2, and what is the difference using the compiler of 7.5 against 7.5x2? thank y...

Ah.. Ok, thanks for the info.. i thought the problem was the job itself...

thanks...

Hi, Here is the job log: Since the error was srtClaims,0: Operator terminated abnormally: runLocally did not return APT_StatusOk , and srtClaims is the name of the sort stage, i assumed that it was the sort stage that is at fault... Occurred: 8:10:24 PM On date: 3/27/2008 Type: Control Event: Starti...

Hi,

The other fatal error found is this one:

Operator's runLocally() failed

Thanks...

Hi,

I would just like to ask if why the Sort Stage in the parallel job suddenly returns this fatal error...

Operator terminated abnormally: runLocally did not return APT_StatusOk

What does it mean and what is needed to fix it?

Thanks...

ahh... I see... thanks for the big help...

I was able to use the DSEXPORT under windows... thanks for the hint... i was not able to read your entire post (cant read premium contents) but i think i got what you were saying... i found the other topics that talk about the -logSUM and -logDETAIL and was un able to run the -logDETAIL... just a la...

Hi, Is there a way to individually export the DataStage jobs and also to extract the Directors log of a specific job using UNIX or via windows command line? The reason why i am asking because my connection to the server is a little slow at the moment and i need to export a specific job (not the whol...

Thanks for all that replied....

Hi,

Will that also tell what column has made the record fail?

thanks...

Hi, does datastage 7x have a functionality to return or write to a file the records that failed and the name of the column that failed with out using a transformer in the designer for validation? lets say I have 1000 records having 10 columns, record number 50 failed in column 5.. can datastage writ...