DSXchange

We created the parallel job and made the executable(DSX) and ater importing tried running it in testing environment and it was working fine. When i tried running the same job in production environment i got the following errors: 1. Oracle_Nxrp_Ctr_Flag: APT_OraInstanceSet::setup() failed to find an ...

Kumar,
There is no logic in Transformer.

Andrw,
Can you please tell me the post name whcih i have to search? I searched stating the error but i could not find a exact match.

Hi, I want to load a oracle database from a XML file. This file contains four columns and its associated data. When i execute the job it is throwing me the error DataStage Job 695 Phantom 7491 Program "DSD.StageRun": Line 295, Square root of a negative number. DataStage Phantom Finished My...

Jeez, didn't even think of that - but you are right, it only works from the Director. It is restart aware, Designer could care less. :!: You need to get out of the habit of running jobs from the Designer unless you are debugging them. The Director is the weapon of choice to fight that particular ba...

If you've done everything correctly, the job will be in an 'Aborted/Restartable' status. Only then can you run it and have it pick up where it left off. ... I am not able to re-run the sequence without compiling the sequence job through the data stage designer. But i can re-run the job through the ...

chulett wrote:Without recompiling or resetting... just run it again. ...

When i am trying to rerun the sequence without compiling the sequece, I am getting the error saying "Job is not in the runnable state. It need to be recompiled. The job is in Aborted Status".

Do the non-failed activities have "do not checkpoint run" selected? This will cause them to be executed on every run of the sequence, irrespective of whether checkpointing is used in the sequence. ... Actually i missed to select the checkbox "Automatically handle failure" and i ...

Do the non-failed activities have "do not checkpoint run" selected? This will cause them to be executed on every run of the sequence, irrespective of whether checkpointing is used in the sequence. ... Actually i missed to select the checkbox "Automatically handle failure" and i ...

I want to restart the sequence job from the failed job activity. Though the checkbox is checked in the sequence job's job properties against "Add checkpoint so sequence is restartable on failure", Its not starting from the failure activity. It's starting from the begining. Please advice re...

Hi all... Can anybody tell how t o use exception handler activity in seequence. And what is the main purpose of it? and is it link to the job activity,which handles the aborted job? and i am seeing only general tab in its properties....is it right??? thanks and regards GS saravanan When some stage ...

There should be an entry in the log now that states "from previous run..." which might contain additional information. Can you post those contents, please. ... Sorry yar no such inforamtion.First it is saying Resetting stage then it is saying finished resetting the stages.Finally saying J...

It is saying Job has been reset . Am i giving the right info which you are expecting or something else you want? one more question wat is the use of this Reset command?

Is this a server job (as your header) or a PX job (as in the forum you posted it in)? What does your shared container do? Does it contain sequential file stages which write to a file that might be the same for concurrent runs, i.e. if the name is hardcoded or as a shared container parameter that ot...

Hi all, I created a shared container which some stages in it. I tried using the same shared container in six different flows within the same job. But it is throwing me an error Abnormal termination of stage OBP_NS..TRANS_DATE detected .When i tried using it upto 4 flows it is running fine. But after...

Hi, I am getting the following compilation error. Error Calling Subroutine DSR_RECORD(Action=2) Check Datastage is set up correctly in the Project DEv (Internal Error(81021)) Error Calling Subroutine DSR_NLS(Action=22) Check Datastage is set up correctly in the Project DEv (Internal Error(81021)) Wh...