Can't attach parameter from sequnce...

stefanfrost1 · Post by **stefanfrost1** » Wed Dec 05, 2007 9:27 am

Hi,

I have a problem. I wish to attach a complete db command as a parameter to a generic job from a sequence. However I can't get it to work. The sequence log gives the following error statement

ArkAxboPermanentSekvens..JobControl (@AddPartitionToPermanentArchive): Controller problem: Error calling DSSetParam(DBCMD), code=-4
[ParamValue/Limitvalue is not appropriate]

Does this mean that the parameter is to long? More importantly, where can i look up these error messages or codes ?

Ps. I have run the specified command as a parameter to the job (stand-alone ) succesfully

richdhan · Post by **richdhan** » Wed Dec 05, 2007 10:32 am

Hi,

Remove the parameter mapping from the job activity and hard-code the paramter value at the job activity level. I hope it is a string. Make sure you do not mention any double quotes as you would in a transformer.

If the above solution does not work try to reduce the size of the DB command i.e issue a simple command and check if that works.

HTH
--Rich

ArndW · Post by **ArndW** » Wed Dec 05, 2007 10:33 am

What is your parameter datatype, it seems as if the parameter contents are not valid for the type of parameter

stefanfrost1 · Post by **stefanfrost1** » Thu Dec 06, 2007 2:33 am

I got it working by adding some logic before triming the argument and adding \ before any ' sign....

Thanks.