DSXchange

The parallel Engine won't run without a Config File and it is the parallel engine which controls the Compile of the transformer.

You require a Compiler installed on the DataStage Server Machine.

Can you try running the job again with a Configuration.apt file with less nodes configured?

krystlecsy wrote: user (ETL_USER) to access the tables who has been granted the rights to select from the table and also a public synonym is created for the F_01 table

The Oracle user must have access to a number of system tables.
These are all detailed in the Enterprise: Job developers guide.

richdhan wrote:Hi,

Fix the first error

Parameter specified but not used in flow: DSProjectMapName

Still if the problem persists then let us know.

HTH
--Rich

Pride comes before a fall
Humility comes before honour

messages with ##W are a warning
the errors start with ##E

The job with a transformer will always use the config file given at runtime regardless of the config file used at compile time

Hi yaminids, can you compile and run a job as the user 'dsadm'?

From an oracle point of view you can install both the oracle clients on the same server. From DataStage you would have to install the OCI8 into one project and OCI9 into another project. Then set the ORACLE_HOME env values in the administrator as user defined values. These will then be applied per p...

Hi All, I need to know the procedure to install DataStage PX on a Linux Machine. Firstly can this be done or would it only work with licensed UNIX versions. If i can install on linux can somebody tell me the following: DataStage server is supported on RedHat linux and you would need a different ins...

It looks like you don't have a c compiler installed.

The dsenv file does not set project level Environment Parameter, it can only set server wide values. Set you project level values though the Administrator.

PS. Have you tried starting DataStage under different shell types?

I think this relates to the Shell Type that was used to start the DataStage Server. (Not all shell types support PWD .i.e ksh)

Have you tried starting the DataStage services under the shell type "sh" ?

I guess you should speak to your server admin

If you install DataStage with NLS then you can choose the MAP used when reading/writing data as one of the stage options.

I guess you would have to give more detail about the failure