Page 1 of 2
Problem while viewing data
Posted: Sun Oct 23, 2005 10:17 pm
by rajkraj
Oracle ----> Transformer---->Seq
when trying to view data of oracle its giving error msg. (7.5x2 windows parllel)
##I TOSH 000002 23:07:38(001) <main_program> orchgeneral: loaded
##I TOSH 000002 23:07:38(002) <main_program> orchsort: loaded
##I TOSH 000002 23:07:38(003) <main_program> orchstats: loaded
##W TCOS 000049 23:07:38(004) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##F TFPM 000281 23:07:39(000) <main_program> Fatal Error: Caught unknown exception in main program: terminating.
Thanks in advance.
Raj
Posted: Sun Oct 23, 2005 10:19 pm
by kcbland
Is this a new installation or an existing one? Has this worked before or do we need to walk you thru configuring PX for Oracle?
Posted: Mon Oct 24, 2005 10:45 am
by rajkraj
Bland ,
It is a new installation
Posted: Mon Oct 24, 2005 11:16 am
by kcbland
So, have you configured PX for Oracle? Is the Oracle client installed? What have you done? Was there an issue following the setup guides in your documentation? Can you post those error messages as well?
Posted: Mon Oct 24, 2005 3:58 pm
by rajkraj
kcbland wrote:So, have you configured PX for Oracle? Is the Oracle client installed? What have you done? Was there an issue following the setup guides in your documentation? Can you post those error messages as well?
Thanks for response,
Oracle client was installed sucessfully, but how we configured PX for Oracle???
Posted: Mon Oct 24, 2005 7:02 pm
by kcbland
Can you tnsping the Oracle instance from your DS server? Is Oracle local to your machine?
Did you try to import metadata using DS Manager? Did it connect using the sid, userid, and password? When you setup the OCI stage, are your DB Options set correctly? How about Remote Server, did you add it and put in the valid sid?
Posted: Tue Oct 25, 2005 9:40 am
by rajkraj
kcbland wrote:Can you tnsping the Oracle instance from your DS server? Is Oracle local to your machine?
Did you try to import metadata using DS Manager? Did it connect using the sid, userid, and password? When you setup the OCI stage, are your DB Options set correctly? How about Remote Server, did you add it and put in the valid sid?
I am able to connect Oracle through ODBC, DYNAMIC RDBMS stages but when I tried to connect Oracle Enterprise stage I am getting this error.
Posted: Tue Oct 25, 2005 9:54 am
by kcbland
To repeat: When you setup the OCI (Enterprise) stage, are your DB Options set correctly? How about Remote Server, did you add it and put in the valid sid?
Posted: Tue Oct 25, 2005 11:10 am
by rajkraj
kcbland wrote:To repeat: When you setup the OCI (Enterprise) stage, are your DB Options set correctly? How about Remote Server, did you add it and put in the valid sid?
I setup all the DB options correctly.
Posted: Tue Oct 25, 2005 11:10 am
by rajkraj
kcbland wrote:To repeat: When you setup the OCI (Enterprise) stage, are your DB Options set correctly? How about Remote Server, did you add it and put in the valid sid?
I setup all the DB options correctly.
Posted: Tue Oct 25, 2005 11:33 am
by kcbland
That's two in a row. I'm at a loss how to proceed other than to say it's pretty simple. Maybe it's time to call tech support.
Posted: Tue Oct 25, 2005 12:36 pm
by rajkraj
kcbland wrote:That's two in a row. I'm at a loss how to proceed other than to say it's pretty simple. Maybe it's time to call tech support.
Thanks for responses Bland
Posted: Fri Oct 28, 2005 12:53 am
by dxp
Hi raj,
whats the windows version...2000 or 20003?
Posted: Fri Oct 28, 2005 4:40 am
by Eric
Does this job work at runtime?
Posted: Fri Oct 28, 2005 8:11 am
by track_star
Have you been able to get any jobs to connect to Oracle and do anything?