DSXchange

Hi,
Welcome Aboard :D !!!

Install and upgrade Guide. (dsupgde.pdf) available in client CD.

It may be due to server overload. But not constantly on particular job. What is the job design? Does it have any dependency on other jobs to get finishes?
How many Jobs were running parallely?

No, it was using MELLASWDS01 and pointing that the current host name is MELLARWDS01.

It should be a case where the source has metadata defined, and the rest of the stages should receive the metadata info through RCP. And in that case if you change the source stage, it will reach till its boundary.

You servername should be MELLARWDS01 and not mellaswds01.

You can use RCP to some extend.

If both server and client are in same Laptop, why corporate network need to be connected?

Oracle error code is produced from Oracle stage. As mentioned, the format is not compatible. If you dont use user defined SQL, you should be able to see the build in SQL in it.

What is the data field that you specified? What is the value been populated?
If you are using User defined SQL, use to_date() function to convert it into required format.

Check if you have LAN card installed? Any fire wall blocking it?
First try in your Command window pinging your localhost.
>ping localhost

dsimport.exe /H=hostname /U=username /P=password /O=omitflag /NUA
project|/ALL|/ASK dsx_pathname1 dsx_pathname2

There might be a chance where one or other stream might take a long time to finish. What happens, if you write it in individual stream into a sequential file for testing purpose. You can increase the row buffering, for any improvement in performance.

Are you sure that you are using default.apt? And are you not using any other file like, mellaswds01_11.apt? Do a grep on the location /datastage/Ascential/DataStage/Configurations/ to check if any files have the value of fastname as MELLARWDS01? What is the value of the command uname -n on the server?

Check the field DATE_FLD . It has been changed from Date data type do a different. And more over, it has been changed to Not nullable. Where a null value is comming and is converted to *'s by default. As specified, you can handle the null by using handle_null function in modify stage or the null han...

I guess you intention to automate the process of compiling the code as soon as it is promoted from Dev to Test. The other option available is, pass on the list of jobs that are promoted to 'dscc', a client executable, to compile the jobs.