DSXchange

Hi all,

My client is going to upgrade to IIS v11 and BigInsights v4.1. One person told me that you can install IIS on a BigInsights node? Is that possible? If so, does anyone have any information on how to accomplish that?

Thanks in advance.

I took rkashyap's advice and it worked. I manually added the NLS_LANG project level variable in the Admin client and added the Stage database NLS settings. After this, the jobs that had issues were successful. One more question - is there some other setting in IIS that defaults the NLS setting so we...

The NLS settings are the same between the two projects. The general NLS setting is MS1252-CS and the default server map is UTF8 in both projects. Where can I find the NLS_LANG environment variable? I do not see it in the Admin client. @priyadar - Both databases have same DDL and I have loaded into t...

Hi all, We are having a problem loading special characters into a table in oracle 11g. However, this same job works in our Dev environment, but not in Staging. The DDLs for the two environments are the same, and when we use the Dev DataStage job and load into the Staging oracle table, we are success...

Admin created soft links and this is no longer an issue. Said they will get to a full install later.

Thanks chulett.

The admin got back to me and said the Oracle client library is not a full install and is missing some of the soft links.

Will update after fixes have been made and tests have been completed.

I don't see anywhere I can specify using a client version in the SK stage. So I don't know if I am using 10g or 11g but it seems like it defaults to 10g.

I don't believe its a new install but I believe the did perform some patch work recently. Not sure if the SK stage ever worked on this box before, this is the first time we are using it in the environment.

These were taken from the failing job from the Director using 'Full Report'.

And the environment variable you mentioned, will it only change the version on the Oracle Connector stage? Because my problem lies within the Surrogate Key Gen stage.

ORACLE_HOME=/usr/lib/oracle/11.2/client64

TNS_ADMIN=/usr/lib/oracle/11.2/client64/lib

LD_LIBRARY_PATH=:/usr/lib/oracle/11.2/client64/lib

The error is: SK_Generator,2: Library orchoracle could not be loaded; Could not load "orchoracle": libclntsh.so.10.1: cannot open shared object file: No such file or directory. I was getting same error for Oracle Connector stages when using 10g version, but when specified to use 11g, it wo...

Hi all, I am using the Surrogate Key Generator stage in many of my jobs using an Oracle database sequence with client version 11g. However, when I run, it throws an error complaining about 10g client libraries not installed. Is there a way to default the stage to use 11g? Or can it only use 10g? Tha...

Hi All, I have a generic job that uses RCP which will take a table name and use it as its source table in one Oracle database and will extract the source data and load directly into another Oracle database with same table name, data types, etc. I have this job set up as multi-instance so I can pass ...

My assumption as well chulett. I will contact IBM resources and if I get a resolution, I will update the thread. I will set post as WORKAROUND.

MT - if you experienced the same issue, what did you do to resolve it? chulett - there has been some type of a workaround developed. Code is below. And I plan on contacting IBM tech resources then support. Following Changes were done: Stage Variable: svDeptID Data Type Changed to VarChar Existing De...