DSXchange

Hi Craig,

Thanks for responding. Still haven't resolved. Have taken this with Unix admin team and DS admin team.

I will post the workaround or solution whenever resolved.

Meanwhile, if someone has any solution/suggestion, I would like to try it out.

Hi, I am reading excel file using unstructured data stage. And in our server we have mixed NAS (accessible through UNIX and Windows). There are some directories which are not NAS (non-shared). When I read the file from non-shared directory (not on NAS) the file is read and job runs without error. Al...

Yes, I modified tnsnames.ora.

I missed changing the JDBC connection through Administrative console. Once changed, the connection was successful.
Marking the post resolved.

Thanks.

Hi, The solaris server has datastage version 8.1 and 8.7 with the configuration as: 1. Engine and Service tier on same server and metadata repository on different server 2. When the version was upgraded, the existing user-id was used for datastage administrator I now have to unistall the older versi...

The client is working fine with Citrix XenApp 6.5 or 7.6 in Windows 2008.

Thanks.

It was firewall issue. Openeing the required ports resolved the issue.

Thanks.

Hi, I have installed Datastage client v8.7 on windows 2008 R2 and trying to connect to solaris server. I am unable to connect to server with the following error: "The provider url [iiop://<server_hostname>:2810] given to connect to server [<server_hostname>] on port [9080] seems to be incorrect...

Hi,

Can anyone please help me to know if Datastage client 8.7 is compatible with Citrix XenApp 6.5 or 7.6 in Windows 2008 R2?


Thanks,
Arti

The issue resolved when I gave Database name in RemoteServer property of Oracle Enterprise stage.

Thanks.

Also, I can import data using Import --> PlugIn metadata definitions --> ORAOCI9.

I can see the enteries of databases defined in TNSNAMES.ORA in dropdown for Database Source Name.

Hi Ray, The following environment variables are set in $DSHOME/dsenv: ORACLE_HOME=<Oracle Server Home Directory>; export ORACLE_HOME LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH PATH=$PATH:$DSHOME:$ORACLE_HOME/bin; export PATH TNS_ADMIN=$ORACLE_HOME/network/admin export ...

Hi, ORACLE_HOME environment parameter was pointing to wrong directory, hence encountered that error. After pointing it to correct ORACLE_HOME directory, the error did not occur. However, now I have a different issue; The job throws this error: <main_program: (aptoci.C:105). Message: ORA-12504: TNS:l...

Hi, I have installed Datastage 11.3 on Solaris. All the tiers and Oracle DB are installed on same machine and this is for the development environment. I have made the configuration in .odbc.ini and uvodbc.config and tested the connection successfully with command line. Modified the dsenv file to poi...

Hi,


We did share the user registry. Howerver it is still throwing the same error. What could be the reason?

Thanks,
Rashmi

Thanks for your response. I have created the dsadm user. However we getting the same error. what do you mean by "Share the server credentials"?

FYI - We have configured Engine Credentials as well.

Thanks,
Rashmi