DSXchange

Hi,
Thanks for your suggestions, Now I got rid of the "& "files and I deleted the project. Yes, I will find out how to get the reporsitory updated from the other postings on this forum.
Thanks much and I appreciate it.

Lalitha

If you did ever stop the server for something and then restarted the server using these commands $DSHOME/bin/uv -admin -stop and $DSHOME/bin/uv -admin -start Then the JobMonApp also gets stopped by the "stop" command but does not get restarted with the "start " command...no expla...

Hi, I deleted a project from DS Administrator as I has some errors while importing from .dsx files. But when I go into the Projects folder...I can see the project still being listed when I do ls -l and when I saw what were there within the projects I saw the 3 files &PH&, &SAVEDLISTS&...

Hi, I faced this exact same problem...Your job would have executed correctly. The target tables would be populated but still you cannot see the link change color nor get the performance stats. For this, I learnt from the forum that JobMonApp should be running. Make sure your JobMonApp is running. el...

Hi, After re-installation of the Datastage we are facing numerous problems. I have a simple 3-stage job called coe_lals_pt1. It compiled with no errors. But when I try to run the job it aborts with the message "Starting Job coe_lals_pt1" "Attempting to Cleanup after ABORT raised in st...

Thanks guys for your suggestions. Yes, I did go to the cleanup resources in DS Director and checked the PID that was troubling me and clicked on "logout". I have successfully compiled it now. But I am still trying to validate and run it but after a break..So I may post again if I face any ...

Hi, One job was hanging for 14 hrs and so I tried to stop and then clicked "clear status file". So, now it is in compiled state. When I am trying to compile again, It throws an error "Cannot get exclusive access to executable file for job <job_name> - job may be being monitored" ...

Hi, I re-installed Oracle Plug in and stopped the DS server and ran the dsenv and then again started the DS Server. With this, I now got rid of the problem. I am able to use Oracle Tables in my jobs as source. Thanks everyone who replied for all your efforts. Though, I am not in a position to say ex...

I have recalled the posting Sorry

In my Oracle Database the NLS_LANG is set to AMERICAN_AMERICA.AL32UTF8. In dsenv, after setting the LD_LIBRARY_PATH, I am also writing these lines: NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export NLS_LANG After this, I have a .bash_profile where I mention most PATHs and I add this also export NLS_LANG=AME...

Thanks Again Ray and Eric!!! :lol: I have a doubt here, While installing the plug-ins, We did not install the NLS character set. But, I chose English as the language. Later on reading the document, found that if you choose English then you need to install NLS. So, I guess I have to install NLS. The ...

Ray and Eric, Thanks for your suggestions. The problem was that the oracle path was missed in the dsenv. I added that to dsenv and got rid of the orchoracle error, but I have a new error Location_table: connect failed for env: cats, user: train1, password: ***** Oracle error: -12705 ORA-12705: inval...

Hi, Server OS - Linux Initially got the error "orchoracle" not found in the default path i.e. LD_LIBRARY_PATH. After reading posts on similar thread, I added the path home/dsadm/Ascential/DataStage/PXEngine/lib to dsenv. Then I found that there was no orchoracle.so but there were orchoracl...

Hi, We did an upgrade to our OS ( Linux) where DS Sever was installed. I took the backup of my projects that were on the server. For that, I did the following: Export all jobs in all projects - I exported projects to *.dsx and to *.xml Backup all critical DataStage files i. dsenv ii. uvconfig iii. u...

Hi,
Can we use ICONV and OCONV for these date conversions???

if the data is Jan 12 1995
then the result would be

ICONV("12 Jan 1995","D4-DMY[2,A3,4"]>=0
OCONV(0,"D4 YDM[4,2,2]">= 1995 1 12

Hope this helps.
Lalitha