DSXchange

Loading from original software cd solved the issue

When installing the DataStage server on a Windows 2003 server we get the error:
Failed to load 'C:\Ascential\DataStage\Engine\BIN\DSENGINE.dll'.
Line:509 File:c:\build\dstage\NTINST~1\Engine\Setup\dsse.rul

Any ideas on how to proceed?

Each night a project runs and one job (extracting from oracle based on a join on large tables and moving data to another oracle table) leds to the following error Contents of phantom output file => RT_SC177/OshExecuter.sh[20]: 2924746 Memory fault(coredump) Parallel job reports failure (code 139) Th...

The problem seemed to be the copy that was done on windows which for some reasen created a file of the same size as the original one (132 MB)but with an abrupt ending of the code in the middle of a job.
For that reason the dsx just was incomplete and caused the error mentioned in the first post.

When importing a dsx in a new datastage project i am getting the following error: Line 3307579: Unknown property name 'LeftTex'. Object=V0S4P2 Class=CJSActivityOutput I do not know which job or routine causes the error as the error appears before updating all the imported jobs. Any suggestions on ho...

Hi, We have a unixmachine with datastage enterprise edition running on it. We need to set up a different server with exactly the same installation en filesystem and also with the same projects. Can this be done by copying the entire backup (filesystem (including users and groups) and data (datasets,...

I found it, the link property was set to fail when the lookup condition was not met.

Hi all, In a parallel job I get the following error on a parallel job which does several look-ups to oracle database tables: Job aborting due to lookup failure on link: readContractDim and The runLocally() of the operator failed. That is all i am getting from the director. Restarting the job still g...

Thanks for the answers. I passed the instructions on to IT and they executed them, unfortunaltely with no result. Apparenty the project had been fully deleted by the delete action but someone (there are a lot of datastage users) still had an open loginscreen from the director with the default select...

Hi there, We deleted a project but while deleting the datastage server went down. When trying to create the project datastage gives an error that the project already exists (although it can't be seen in the administrator). is there a way to create the project with the same name it had? We already st...

The O/S user which was assigned to the datastage user didn't have enough rights on Unix.

Hello, I have added a new datastage user. When using this new user, with its own unixuser instead of dsadm, I get the error C Stage PlugIn function "Get" required. I have read the topics concerning this problem but in this case everything works fine when addressing the O/S as dsadm. Do you...

Hello, On the host site of Websphere I added a user . With this user I am able to logon to Datastage. Datastage uses the user 'dsadm' to connect to unix from the datastage server. Now i added a user on unix. Because I want the new datastage user to logon to unix with the new unixuser i added a user ...

Hi Ray,

Thanks for your fast response.
I found the file and with 'localuv' as the DSN in the Universe stage I am able to look at the hash file now.

Greetings, Roy

You're missing the From <table> clause in your statement.
Oracle then always returns the last column in your select statement as the column which cannot be found
make sure the from clause is added