Invalid NLS Format

nkln@you · Post by **nkln@you** » Tue Jun 13, 2006 5:39 am

I am using ORAOCI 7 stage to read from Oracle 7 table. When i try to import meta data of table, it says Invalid or Unknown NLS Parameter value specified.

How can i correct this error.

mfranke · Post by **mfranke** » Tue Jun 13, 2006 6:04 am

When you import a definition and the plug-in selection menu appears you should be able to choose a nls format, maybe you already thought of that, but have you tried to choose another nls format?

mario

nkln@you · Post by **nkln@you** » Tue Jun 13, 2006 6:15 am

Yeah i tried to change the NLS format, but i don't know exactly which one to select.; The default one was ISO 8859-1.

mfranke · Post by **mfranke** » Tue Jun 13, 2006 6:31 am

it depents on your database, if it is unicode utf-8 or utf-16 is better. i'm using oci9 and also iso8859-1 and i have a database in utf-8, but this is no problem, maybe oci7 likes more precision in the chioce of the nls.
determine what your source database is like

nkln@you · Post by **nkln@you** » Tue Jun 13, 2006 6:37 am

When i queried source database as

SELECT * FROM NLS_DATABASE_PARAMETERS

the value for NLS_CHARACTERSET IS WE8IS08859P1, but this character set is not displayed in Datastage.

Should i look for any other variable in database to retriev the NLS format.
If so can you tell me which one to look

mfranke · Post by **mfranke** » Tue Jun 13, 2006 7:02 am

I think you look at the right one, WE8-ISO8859-P1 means you should use ISO 8859-1 as nls, sorry to say so, but seems your problem lies somewhere else

ray.wurlod · Post by **ray.wurlod** » Tue Jun 13, 2006 3:16 pm

Look in the second log entry for the job run (where the environment variables' values are displayed). Check that NLS_LANG and LANG_C are both set.

nkln@you · Post by **nkln@you** » Mon Jun 19, 2006 3:08 am

Hi Ray, the error is coming while importing table table definition itself, oracle database we are using is Oracle 7 and the plugin used is ORAOCI 7.

I checked the nls_database parameters, the character set is same as specified in datastage.

Still invalid NLS format is coming

chulett · Post by **chulett** » Mon Jun 19, 2006 6:06 am

nkln@you wrote:the value for NLS_CHARACTERSET IS WE8IS08859P1, but this character set is not displayed in Datastage.

nkln@you also wrote:I checked the nls_database parameters, the character set is same as specified in datastage.

These seem to contradict each other. Please post your exact NLS_LANG setting from your dsenv file. I would guess it's not quite right. The issue here isn't whether it matches your database or not, that's irrelevant in this context... it's just invalid.

nkln@you · Post by **nkln@you** » Mon Jun 19, 2006 6:41 am

Chulet,

Can you tell me in which directory can we find this dsenv file

chulett · Post by **chulett** » Mon Jun 19, 2006 6:51 am

Oh my. In your DSEngine directory, which should be pointed to by the $DSHOME environment variable.

Also, what version of 7.x is your installation? I don't recall there still being an OCI7 stage in that version.

nkln@you · Post by **nkln@you** » Mon Jun 19, 2006 7:05 am

Chullet

The value is AMERICAN_AMERICA.WE8ISO8859P1.

The version which we are using is 7.0

chulett · Post by **chulett** » Mon Jun 19, 2006 7:16 am

Ok... that seems... fine. Are you setting any other 'NLS' parameters there? Is so, post them - both the variable names and the values you are setting them to, please.

nkln@you · Post by **nkln@you** » Mon Jun 19, 2006 7:30 am

We are not setting any other environment variables there.

Also the stage ORAOCI7 is a plugin

DSXchange

Invalid NLS Format

Invalid NLS Format

Re: Invalid NLS Format

Re: Invalid NLS Format