Problem while viewing data
Moderators: chulett, rschirm, roy
Problem while viewing data
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
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
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?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Thanks for response,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?
Oracle client was installed sucessfully, but how we configured PX for Oracle???
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?
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?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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.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?
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?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 60
- Joined: Sat Jan 24, 2004 12:52 pm
- Location: Mount Carmel, IL