DSXchange

Hi All, I have a Master Sequencer running 5 sequencer jobs using a parameter Set until last nite. I had to add 2 new parameters to the parameter set and when i run the master sequencer now i get an error : CUSTOMER_UNIT_SEQ..JobControl (@Delete_Job_Seq): Controller problem: Error calling DSSetParam(...

That comes from having the option "Automatically handle activities that fail" turned on as routines that do not return a zero value are considered to have failed. It should also have mentioned the fact that it is an "unhandled" failure and the secret to making it go away is to (...

What exact warning are you receiving? The fact that it doesn't return a zero value? These can be dealt with, there should be no need to go under the covers for something like that. I do get a warning in the log when the return code <> 0 as "The routine activity did not finish ok, return code='...

Curious why you would think you'd need to edit the generated job control. Craig, I am using a routine activity in Sequencer and have a condition to run the jobs down the line if it meet. There will be a warning in the log if the condition is not met which i do not want. So, i thought editing the jo...

Hi,
I am trying to edit Job Control in Sequencer using dsadm and i see that i dont have edit access to it. It been long time i'm back to server, does anyone know if i need to enable anything in order to edit job control.

-- Thanks in advance.

Search? Floating point is not fully supported, because it can't be. Study the IEEE standards on storage of floating point numbers in computers to find out why. Hi Ray, Thanks for the info. But the job that i ran in Datastage dev server gave no warnings but when i run the same job in Datastage Prod ...

Hi All, I am running a job in Production which sources the data from Oracle and i get the warnings: Floating point decimal is not fully supported: Adjusting the scale. I ran the same job in Dev Server many times before moving it to prod but didnt get any of this warnings. I'm not sure if this is bco...

Could you clarify what "cleaned up the DataStage home directory" means, please? Hi Craig, In the dev box while we were running jobs that creates Datasets, i noticed that failed jobs created virtual datasets in DS home Dataset directory and were not cleaned up after next run, which filled ...

ray.wurlod wrote:Why not disable operator combination and find out precisely where the error is occurring?

Thanks Ray!!! It happened to show the error at every stage when disabling the combination. We cleaned up the datastage home directory and now it works fine.

Hi Chulett,
The scratch and resource disk space i am writing to is only 1% full but the datastage installation disk space is 99% full, is this causing the issue?

Please advice...

Hi, I have a job which sources from database table with order by key column and then i have transformer and then remove duplicate stage which keeps last and then writes them to dataset. This job used to run before sucessfully but not i am getting the following error in the log: Type: Fatal Event: AP...

Hi, I am writing 2 columns(length 40 each) which are defined as varchar in source to a fixed width sequential file. In the transformer i have set the datatype for the target columns to be char and in the sequential file stage format properties i have set record length to fixed and column extended pr...

Hi , I tried using 4 stage variables and concatenating the values for the same key and later used remove duplicate stage to retain the last one. 1) keycol ----- SvCurr 2) SvCurr <> SvPrev ----- SvCheck 3) If svCheck then lnk.value else svSvValue :', ': lnk.value ----- SvValue 4) SvCurr ----- SvPrev

Hi All,
I am trying to do Vertical Pivot as defined in the following link which work when the max no of input rows is known:

viewtopic.php?t=118685

But in my case the max no of input rows for a key is not known. Any suggestions plz.

Thanks.

Hi All,
I am trying to handle null in a Date (length 10) and timestamp (length 26) datatype columns in Modify Stage. I specified as follows:

Date1=handle_null(date2,'1111-11-11')
timestamp1=handle_null(timestamp2,'1111-11-11 11:11:11.111111').

This is not working. Any suggestions plz.