DSXchange

Hi Ray, I've tried to log the Link row count and it is zero after the first pass. So the loop got a normal exit. I think the two environments are almost the same except that I can see "Generated OSH" tab in Development Machine but not in Production. It seems like the DSGetLinkInfo is not b...

Hello, I have a Parallel job which Loops through 2 other jobs. The following is the exit condition of the loop. LinkRow = DSGetLinkInfo (hJob1, "Transformer_86", "DSLink87", DSJ.LINKROWCOUNT) If (LinkRow > 0) then Goto THE_BEGINNING I have found that the loop is working fine in o...

Thx a lot for the info.

And any idea on how much downtime do we need to apply the patch?

Hi All, I am using an environment variable (Oracle login password) as a job parameter. I can run the job successfully using it, but when i tri to do "view data" i can't and get this error... Error executing View Data command: Bad dboption list. Failed on Expected value for property "p...

Hello,

Is it possible to register Job Sequence in RTI?
Our currently design is... to create an empty job which invokes the job seq through "Job Control" and then register that empty job in RTI as web service.

Thanks & Regards,
william

Thanks for amost instant replies

After monitoring the job run for a few rounds....i found that the order is almost random.

thx for explanation.

Hi all, I am extracting aggregated data from the warehouse using oracle sql ( invovled joining dimension and fact tables , summing up some measures, some translation of data column and sorting ) Now i need to build the DS job for it. -should i get better performance if I break the logic down into a ...

Case Closed!! It turned out that we didn't pay attention to details. RTI/Tx was working fine...data duplication was caused by some mistakes in the job design. RTI local acess log shows time in 24 hr format : one service call was on 28/Mar/2006:00:54:26 +0800 another at 28/Mar/2006:12:52:49 +0800 but...

Thx Roy, We have already contacted the support team and the case is being investigated now. The initial findings are: 1) we are quite sure that only one of the RTI/TX servers was running(active) at that time. 2) RTI Localhost_Access_log shows "there was only one service call to that particular ...

Hi All, We have 2 DataStage servers with identical jobs/configuration for High Availability. The RTI server should read parameters & time-to-run from the schedule table and run the job on one of servers ( Job Status will be updated once the job is done) . Today, our RTI Server( 7.5.0.1 ) invokes...