DSXchange

Hi All, Off late we have started experience the following error message when just creating a smiple Job in some Projects: ************************************************************* Error while creating job Sample Error on CREATE.FILE command (Creating file "RT_CONFIG22" as Type 30.mkdbf...

Hi,

You could try the following:

hashfile_lookup.NOTFOUND in the constraint.

Should work.

Thanks & Regards
Mahesh

Hi All,

Thanks to all your comments, I know this is a huge task but would definitely be helpful, This is will something to lessons learnt.

But Just had an idead and wanted to share the same.

Appreciate all your responses.

Thanks & Regards
Mahesh

Hi Siva,

Thanks for the information, Will do the same.

was wondering if someday had a write up regarding the various cases/scenarios of Adminstering the Data Stage Jobs, what are the possible cases and solutions that could be done?

But anyway thanks to all.

Regards
Mahesh

Hi All, Thanks to both of you'll , I followed the steps indicated and I was able to remove the project alone. Thanks again, I was able to learn some of the Administrative part of DS as well. Could you'll please let me know if I could by any chance get some more information (Tips and Tricks) about th...

Hi Ray, The Server is on HP Unix and There are multiple projects on the server which I am able to work on but when I try to open one particular project I get the following error, When I use "cat /.dshome" it goes to the directory where DSEngine is available. I get the following error messa...

Hi All, I have an issue here, A project was created and the project has been corrupted so I tried deleting the project but I was not able to do so using Adminstrator, when tried to log on to the project I get the following error message Failed to connect to host: <servername>, project: <projectname>...

Hi, Did you go into Services and check for the Profile Stage Message Switch " MGXSwitch" , before doing that check the Initialization ".ini" file available in the Client if there is an entry for the Message Switch, as you have installed all the compnents locally, go into"C:\...

Hi, The Steps are as follows: 1. got to the .odbc.ini Give the name of the connection, then pass the User ID/ PWD and also give the IP Address,Port number. If needed you can test the connection by going into the example directory and run example and pass the Conenction Name and UserID/PWD 2. Then on...

Hi All,

Thanks for your valuable suggestions, I have opted rather use a Sequential File Stage for the output instead of a Hash file.

Because most of the Lookups use other tables with lesser number of data for lookups, Thanks Ray.

I also apologize for marking the post as URGENT.

Thanks
SMK

Hi, When I am executing the job the executes and I get the following error DataStage Job 35 Phantom 28398 Program "DSU.TransactionType": Line 14, Unable to open the operating system file "DSU_BP.O/DSTransformerError". [ENOENT] No such file or directory Program "DSU.Transacti...

Thank you for your valuable suggestion,was able to check and rectify the issue.


Have a great day.


Thanks
SMK

Hi All, I have executed a Job LooKUp(HashFile) | | Hashfile ----> Transformer -----> HashFile Is the setup of the Job, The job is compling and after the execution of the Job, I get the following Warning messages ************************************************************* Program "JOB.18616503...

Hi Rich, I am really not sure if this is a better way but you could try this, Step 1: Goto the Unix box and Data Stage home directory and type in the following command dsjob -ljobs <ProjectName> which will give all the jobs asscociated with the project, Step 2: You could do dsjob -ljobs <ProjectName...

Hi All, I have got a huge set of legacy data on a DVD for one of the legacy system and I need to FTP the data on to the UNIX box, 1. When FTPing the data I get a problem when I FTP it in ASCII mode but no issues when I FTP the data in BINARY mode. I checked both the cases and both have a Carriage re...