DSXchange

Kim - I believe the problem is with no. of hash files and not with the oracle client. Because once i split the job in to two and reduced the hash look ups the jobs are running in PROD as well. Is my understanding wrong? Thanks craig. I found where to change the write cache limit in administrator. Th...

Hi, Thanks for the replies. The hash file is not that big. It has very few columns. And it is below 1 GB. The warnings come when the hash file reaches 100 MB and they keep coming once in a while until the job completes. Craig -- How to increase the write cache at the project level?? If i turn off th...

hi, I get these two errors in my director log when i run my jobs. 1. Abnormal termination of stage. (Error) This job has lot of hash file lookups. Around 10 hash file look ups. The job reads from a sequential file, looks up in these 10 hash files and loads in to Oracle as well as a couple of hash fi...

Thank you Ray for the response. We will change the T30FILE configuration parameter and rerun the sequence again. And why is this time out problem coming? Controller problem: Error calling DSRunJob(ExtractCalendarQtrDim), code=-14 [Timed out while waiting for an event] Is it that the server capacity ...

Hi, I am running a master sequence and it calls 5 more sequences at a time. Out of the 5 couple of them run fine but remaining of them abort giving the following error. One of the job this sequence calls aborted with the following error Controller problem: Error calling DSRunJob(LoadCalendarMonthDim...

Hi, I am getting this error sometimes when i run this sequencer. SeqDealOrderDim_Main_test3..JobControl (@SeqDealDim): Controller problem: Error calling DSRunJob(SeqDealDim), code=-14 [Timed out while waiting for an event] Is there a way to increase the time to wait for an event? The error comes out...

Ahhhh.. So silly on my part. Overlooked something very basic like that. :oops: Reason is first time when i ran the sequencer i am getting warnings. So, i added that warning exit status as well. But didn't realize that both warning and Ok status can not happen at the same time. Thanks Ray and Craig. ...

Thanks Craig. That's really cool. Let me post my job snapshot here. http://img360.imageshack.us/img360/3849/seqerror0qp.th.gif Guess it's working. Can anyone help on my actual sequence problem. Hope the snapshot helps. In the job all my activities seqdealdim, seqorderdim_main, seqorderlinedim_main, ...

Hello Roy, Thanks for the reply. You are right. If i have a trigger of OK and if i had warnings in my previous activity then it is not going to get there. But i had two triggers - one for Ok - (Conditional) and one for Warning - (Conditional). In any case all my activities run with out warnings. Sec...

Hi, I have this sequencer which calls two sequencers and on successful completion of both it should trigger a server job. Seq1---------------> Sequencer Condition Activity -----------> Server Job ^ - - Seq2------------------------------------- Seq1 and Seq2 completes fine and reaches Sequencer Condi...

Oops! correction in my last post.
I mean stopping the job from director didn't give the same results as killing the PIDS.

Thanks,
Srikanth

Thanks Craig! I got the problem solved. Just killed the PIDS using the command given by kim. ps -ef | grep phantom | grep MyJobName Thanks kim for that. :D But i didn't understand why stopping the job from designed didn't give me the same results and why the status is misleading me saying the job go...

Ray, In my job i have 3 parallel OCI stages extracting data and loading to a sequential file. OCI1 ------> SEQ1 OCI2 -------> SEQ2 OCI3 -------> SEQ3 I tried stopping my job from director. It shows job is stopped. But two of the OCI stages are still extracting data and loading in to SEQ file. The jo...

Ascential do provide training services in India. Request your employer to contact Ascential and get the details and arrange for the training. The ascential guys come to your company and train you but i guess you need to have a batch of people for that. They won't train for just 1 person. They charge...

Today we got one more patch from Ascential to fix this problem with routine activity.

After applying the patch on the client side the problems with sequencer got resolved.

Now the sequencer just works fine!!!

Thanks,
Srikanth