Unable to read from Oracle Database Source

HemaSathya · Post by **HemaSathya** » Tue Apr 28, 2009 11:14 pm

Hi , We are migrating from sun Solaris to AIX server. Our imported jobs to the new server do not run due to the following error(s)

(info) : main_program: -nchar_cs option is deprecated.
use_strings option is deprecated.
(Info) : main_program: -nchar_cs option is deprecated.
(Info) : main_program: -nchar_cs option is deprecated.
-use_strings option is deprecated.
-nchar_cs option is deprecated.
-use_strings option is deprecated.

(Fatal ) : Orcl_FlflFcltyXref ( Oracle Source Stage ) The provided query statement did not prepare correctly; please verify that your statement is correct;

We import the table(s) metadata at job level,compiled ,validate and run. But the job aborts. What can be done to resolve this issue?

Thanks,
Hema

ray.wurlod · Post by **ray.wurlod** » Wed Apr 29, 2009 12:56 am

Take a look (in the Oracle stage) at the actual SQL statement that was generated/specified. Did this statement get logged in the job log before the job aborted? Is it the same? Can you execute this statement in a different client, such as sqlplus or TOAD?

chulett · Post by **chulett** » Wed Apr 29, 2009 6:29 am

What version of the Oracle client do you have installed on the new box? I'm curious if it is the same one as on the old box.

HemaSathya · Post by **HemaSathya** » Thu Apr 30, 2009 1:43 am

Our etl jobs presently reside on sun solaris .
These will be moved to Aix Server.
The oracle client version present in Aix is 10.2.01
The Oracle DB (10g) where our tables are present is on another Sun Solaris server.
Data Stage version on both the etl servers is 7.5.1

But the error we get is more of parse error than of Oracle .

chulett · Post by **chulett** » Thu Apr 30, 2009 5:34 am

Oracle is the one parsing your SQL. Can you take the logged SQL statement and run it in another tool? Is 10.2.0.1 the same client you are using on Solaris?

HemaSathya · Post by **HemaSathya** » Thu Apr 30, 2009 5:45 am

Yes the SQl query is correct and runs on other tools . The version of oracle client in sun solaris is 9.2.0.1

chulett · Post by **chulett** » Thu Apr 30, 2009 5:55 am

Are you able / willing to try a 9.2.0.1 version of the client on AIX as well?

HemaSathya · Post by **HemaSathya** » Thu Apr 30, 2009 6:45 am

we do not have privilages for that

.But might suggest if it can help .

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Apr 30, 2009 8:39 am

Normally it given the SQL statement which it is complaining about. Did you check it? Can you paste it here?

Did you use any parameters?

Is it the correct db you are connecting to ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Apr 30, 2009 8:39 am

Normally it given the SQL statement which it is complaining about. Did you check it? Can you paste it here?

Did you use any parameters?

Is it the correct db you are connecting to ?

dpsahoo · Post by **dpsahoo** » Sat Feb 13, 2010 6:10 pm

Hi,

Can you please post the resolution to this problem. I seem to have stuck with this same issue.

Appreciate if you can share your resolution.

Thanks,
Durga

dpsahoo · Post by **dpsahoo** » Sat Feb 13, 2010 6:11 pm

Hi,

Can you please post the resolution to this problem. I seem to have stuck with this same issue.

Appreciate if you can share your resolution.

Thanks,
Durga