DSXchange

Go to Oracle Home on your unix box and check for tnsnames.ora file in $ORACLE_HOME/network/admin folder find out if the Entry for Database exists in the tnsnames.ora file. check if the tnsnames.ora is a local file or is it a file on the network (mounted using automout). If it is a file on the Networ...

Use a stage variable as a counter.. Initialize the value as 1

increment this value based on the First character of the source string ( If Instr(txt,H) = 1 then... StgVar = StgVar + 1)

Thanx Craig.

I have been monitoring the RTI service for about 48 hrs and looks like its pretty stable

I usually start the service using telnet and I have observed, just now, that the service goes down as soon as I close my telnet connection from which I start the RTI service.

Is this a valid observation ?

Actually found a message in RTI.log file

{ 2006-08-25 18:57:20,902 [JBoss Shutdown Hook] INFO com.ascentialsoftware.mwserver.jobpool.impl.JobPool WebModule - close request received. }

Any ideas why this is happening?

Hi ! RTI service stops all of a sudden. The .NET programs call the default web service in order to run the jobs. The calls are successful for most part of the day and suddenly the service goes down. I need help to find out the root cause of the problem. Are there any logs that are created when the s...

Hi !

I need to find list of Aborted Jobs in any given sequence (using Routine), so that I can reset the same.

I have the routine to Reset the jobs, but I cannot find a way to find aborted jobs in a sequence.

Can you help me out with this ?

Regards
Nagesh

To set an NLS_LANG environment variable for the job, go to Job Properties, Parameters, click in Add Environment Variable, click on New, enter the variable name as NLS_LANG and enter a prompt. Then you need to click on it (or possibly double click) to get it to appear in the paramter list (shows as $...

Thanx Guys,

It works.


-Nagesh

Hi ! I think my example has misled you a little. I want to be able to select the First Rows only for a given Site.. Irrespective of the Date. ie., If the file is Site Date Qty ------------------------------------ A 2006-02-17 1300 A 2006-02-16 1500 A 2006-02-18 1200 Then the output should be Site Da...

Hi ! My Source File is as follows Site ReplenishmentDate ReplenishmentQty -------------------------------------------------------- A 12-march-06 1200 B 15-march-06 1500 A 17-march-06 2200 C 18-march-06 1600 C 19-march-06 1700 I need to take first records only (based on Site) ie; My output should be ...

Thanx a ton Guys.

It was very helpful.

Regards
Nagesh

Hi !


Is there a way to find out which user has run the job.


Regards
Nagesh

Out of curiousity, how are you keeping it from creating the file regardless of the outcome of the source query? Just having the Sequential File stage in a job will create an empty file when it runs... Source -----> Transformation -----> Folder Stage Source is Oracle. The Source will have only one c...

HI Craig, Many thanx for the tip. I have designed the job in a sligthly different way.. 1. Start with the Start Loop Activity. 2. Call the Job Which will Read from the source table and create a file called "triggerfile" in the predefined directory, if the source table has a record with Nul...