Sequence Error

sush26283 · Post by **sush26283** » Wed May 09, 2012 8:38 am

Ok..So I have a typical problem, which am not able to pass through may be someone can help.

I have a sequence for the jobs and its parameterised.
I have 2 sets of parameters, 1 for sources and the other for the target DB's and connection details, which includes the parameters for DB's, schemas, DSN etc.

Now, when I run the sequence, which say point to/from DB_1, randomly it will generate error Error calling DSSetParam(Pset.DB_X), code=-3 [ParamName does not reference a known parameter of the job]

so, it refers to some other DB and says its not being used in the job. and ABORTS.

If I run the jobs individually then its fine, but with sequence it will ABORT.

Can please help me an insight on it. Thanks.

BI-RMA · Post by **BI-RMA** » Wed May 09, 2012 8:58 am

How Do You pass the parameters to the jobs?

Do the jobs use the same parameter-sets? Or do you pass the parameters from the parametersets to individual job-parameters one by one?

Did you change the parameter-set after you last compiled any of the jobs?

sush26283 · Post by **sush26283** » Wed May 09, 2012 9:38 am

I guess Compile was the trick..I just compiled my all the jobs, and am running the Sequence now, I hope its a success. Thanks