DSXchange

Posted: **Fri Sep 30, 2005 8:33 am**

Hi,

Scenario:
There are two jobs in a sequence. The first one generates a single number (By aggregating). I need to pass this to next job as a parameter.

Implementation:
I have written a routine with following code.

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H 
Call DSSetUserStatus(Arg1) 
Ans = Arg1

and called the routine in a basic transformer.

Problem:
When I run the job, I get the following warning:
"Error reading Job Status record. JobNo = 553 JobName = sampleJob1.#0 WaveNo = 1"

and the user status in not passed to next job.

I have searched the site on this topic but I couldnot get a solution. Waiting your help. Thanks.

Posted: **Sun Oct 02, 2005 4:27 am**

Hi,
Are you using partitioning when you run it?
Does it also fail if you run the job sequentially?

I'd prefer writing the aggregation result to a file or any other storage place of your choice and have another server job setting user status for further use along your squence job (if you can't get this stable and working).

I've heard of some cases where basic transformer in PX job was not 100% stable, though I've yet to gain 1st hand eperiance of this.

IHTH,

Posted: **Sun Oct 02, 2005 9:49 am**

Hi Roy

I have tried running sequentially and I still get the same result. The reason I have to pass the parameter from one job to another is because I have another similar situation. This is beeing discussed at http://www.dsxchange.com/viewtopic.php?t=95614.

Thanks

Posted: **Fri Oct 07, 2005 8:14 pm**

Hi All,

I have learned from an Asscential emplyee that its not possible to use the function "DSSetUserStatus" in a parallel job. I was said that the parallel jobs uses partitions and the this routine cannot decipher the partitions even after using a basic transformer and making the stage sequential.

So, I have designed a server job and added as a job activity.

DSXchange

"DSSetUserStatus" warning

"DSSetUserStatus" warning