DSXchange

11:42:37: Exchange_Extraction (JOB CopyOfFXRate_Extraction) finished, status=3 [Aborted] gopal Is there any detail to this log and did this log come from the sequencer job or the actual job that ran. If this is just the sequencer then look at the log for the actual job that the sequencer called. Mo...

Hi Everybody, I have good experience in datawarehousing but very new to datastage. I have created a job sequence and one parameter file which will have all parameters needed for all jobs. I have 3 jobs inside the sequence and all three have parameters (in the job as well). When i run the sequence i...

Hi! This is not strictly DS question but maybe someone had similar situation. Let's say we have two dimensions: customer and vendor, and one fact table with columns: customer_id, vendor_id and value. In one row in fact table we can have reference to customer dim or vendor dim (never to both of them...

You need to fix your PATH or the dsjob command should be so full path. The dsjob command is in DSEngine/bin. I fixed my version by making the dsjob parameter default to ../../DSEngine/bin/dsjob -report. We are having problems with the paramiter for this job. Can someone post an example of what the ...

Use DSExecute with 'dir *' to check the directory entries. You may have to them locate the file by some logic. A coleage has found a way to output a file with the current file name using the folder stage. We think this output can be used some how as input for a paramiter that can be used as the FIL...

We have a situation where we are delivered a file every day with a slightly different file name. The difference is always the date and time. Is there a way to program a routine to look for a file name using wild cards? Jim

JDionne, the repository, while accessible through the DS-Shell and readable from within DataStage itself, is effectively "undocumented" by Ascential. This means that if you write some snazzy reporting based on the current structure of the repository and Ascential changes the format around...

I need to know how to get access to the DS repository where job completion information is stored. I need to extract all of that info and put it into DB2. I dont want to gather this information at the end of every job, because we are creating a monitoring system and we need to automate gathering for ...

On windows, a scheduled job is run with the user name that is provided on the Schedule tab of the Project Properties page accessible via the Administrator client. Check if this User Name is different than your User Name. It is probably preferable to avoid using a mapped drive and use the Windows UN...

Maybe you have checked this already !! All actions in DataStage takes place in the Server. So this path of 'G:' etc must be in the DataStage server and not on your client. Also this must be visible to the user logging into DataStage. Can you please confirm this for me. there is a mapped drive on th...

Try reducing the wait time to zero (or 1 minute) You may use a loop of 1 to 60 covering the wiat-for-file-activity stage. On presence of the file, you can exit. On failure, continue with the loop. This is only a test and work-around and not the final solution. This is the msg I get after the wait f...

Maybe you can see the time of the message. That will give you an idea of how long the sequencer is designed to wait. You can also check it in the wait-for-file activity stage. Its set up to wait for one hour, but i physicaly remove the file and put it back and the job still does not launch. This on...

Can you see what it says in the 'director log' for the job when the job 'appears' to be hanging. This will give you a clue on what stage the job is waiting. Maybe you had crossed the waiting stage but did not have an exception when the file is not present or maybe there was no code to perform after...

Check whether the file is opened by some other process. Windows, by default, locks files when it is opened by one process and hence the second has to wait for it to be released. You can try to cut / delete your file from Windows explorer. If it raises a sharing violation, it will imply the existenc...

I have a new problem with this same job. Thats why I am posting under this topic. I have this job set to run in a loop 3 times. I also have it schedualed to run every 4 hours. The patern that I am finding is that if the job is started by the schedualer and the file is in place that the job needs, th...