Page 1 of 1
Unable to read from Oracle Database Source
Posted: Tue Apr 28, 2009 11:14 pm
by HemaSathya
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
Posted: Wed Apr 29, 2009 12:56 am
by ray.wurlod
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?
Posted: Wed Apr 29, 2009 6:29 am
by chulett
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.
Posted: Thu Apr 30, 2009 1:43 am
by HemaSathya
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 .
Posted: Thu Apr 30, 2009 5:34 am
by chulett
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?
Posted: Thu Apr 30, 2009 5:45 am
by HemaSathya
Yes the SQl query is correct and runs on other tools . The version of oracle client in sun solaris is 9.2.0.1
Posted: Thu Apr 30, 2009 5:55 am
by chulett
Are you able / willing to try a 9.2.0.1 version of the client on AIX as well?
Posted: Thu Apr 30, 2009 6:45 am
by HemaSathya
we do not have privilages for that
.But might suggest if it can help .
Posted: Thu Apr 30, 2009 8:39 am
by Sainath.Srinivasan
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 ?
Posted: Thu Apr 30, 2009 8:39 am
by Sainath.Srinivasan
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 ?
Posted: Sat Feb 13, 2010 6:10 pm
by dpsahoo
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
Posted: Sat Feb 13, 2010 6:11 pm
by dpsahoo
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