DSXchange

Thanks for that. Weird problems make you look for weird things...
I'll keep you posted.

Please tell me it can't be a lock on the APT configuration file when several jobs try to access it simultaneously ?!

Nope, since DSXchange has beaten them in the past more than once... But you're right. Will give them a fair chance to prove otherwise... In the meantime, still open for suggestions...

Jobs hanging again. Datastage-processes still up, but not running (no changes in CPU or memory allocation). No DB-processes and no usefull information in the logs after having ran with APT_DISABLE_COMBINATION. Just the job waiting there for the 'Load completed message' from the second node... Any ot...

wbeitler wrote:We're on 8.1 fixpack

ehhhrrr 8.1.2 that is...

We're on 8.1 fixpack 1. No direct access on the ETL-server unfortunately, so couldn't check myself. But sure will get support to find out about serverside processes (if I get it to ' hang' again...)

William

Checked that. No Oracle processes running for that table when the job seemed to be hanging.
Have been constantly looping the 75+ jobs in which the error sometimes occured with the APT_DISABLE_COMBINATION set. No luck in trapping the error again so far...

Hi, - APT_ORACLE_LOAD_OPTIONS isn't set explicitly, hence we're running with: OPTIONS(DIRECT=TRUE, PARALLEL=TRUE, SKIP_INDEX_MAINTENANCE=YES) - Oracle-trace doesn't show any problems. - No indexes (or rebuilds) on the table yet. So index-maintenance options not set Turned the operator combination of...

Morning, we're running a very simple parallel job, writing to an oracle table using the Load-method. We've got 2 nodes defined in the APT-config. For both nodes we receive the 'Export complete' message along with a rowcount. At times (by the look of it rather random) we're receiving just 1 ' Load co...

Worked my way around it by only checking a given Sequence. This fits the customers purposes. Query used to select Jobs in Sequence (thanks to kduke): select DS_JOBS.NAME JobName FMT '40L' FMT '40L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE = 'CJSJobActivity' and DS_JOBS.NAME = ':1' and...

I was afraid so...

How bout a DS_JOBS query that recursively finds me all the underlying jobnames of a named sequence (which I do have)?

The correct way of getting the status is to use the DSGetJobInfo() routine instead of looking at the status file contents Agree... Problem is I want to loop through the list of jobs that didn't finish correctly (And then take all the warnings from the log and put those in a seperate HTML-file... ) ...

Hi All,

trying to retrieve the Job Status through a Universe Stage. As it is not stored in the DS_JOB ther must be another place... But hey... Where's that ?!

William

PS documentation-suggestions on DS_JOBS and alike are also welcome...

Traced it back to 2 specific environment variables containing path-names. Changed the '\' into '/' within the values and it worked like a charm...

Looks like we ran into a similar problem as muralisankarr viewtopic.php?t=125557

Thanks alot for helping out !

Line 2144 ?

"DSD.GetProjEnvVarValue" Errmsg PARAM.NAME PARAM.VALUE ENV.TYPE => $R246