Problem while viewing data

rajkraj · Post by **rajkraj** » Sun Oct 23, 2005 10:17 pm

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

kcbland · Post by **kcbland** » Sun Oct 23, 2005 10:19 pm

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?

rajkraj · Post by **rajkraj** » Mon Oct 24, 2005 10:45 am

Bland ,

It is a new installation

kcbland · Post by **kcbland** » Mon Oct 24, 2005 11:16 am

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?

rajkraj · Post by **rajkraj** » Mon Oct 24, 2005 3:58 pm

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???

kcbland · Post by **kcbland** » Mon Oct 24, 2005 7:02 pm

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?

rajkraj · Post by **rajkraj** » Tue Oct 25, 2005 9:40 am

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.

kcbland · Post by **kcbland** » Tue Oct 25, 2005 9:54 am

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?

rajkraj · Post by **rajkraj** » Tue Oct 25, 2005 11:10 am

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.

rajkraj · Post by **rajkraj** » Tue Oct 25, 2005 11:10 am

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.

kcbland · Post by **kcbland** » Tue Oct 25, 2005 11:33 am

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.

rajkraj · Post by **rajkraj** » Tue Oct 25, 2005 12:36 pm

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

dxp · Post by **dxp** » Fri Oct 28, 2005 12:53 am

Hi raj,

whats the windows version...2000 or 20003?

Eric · Post by **Eric** » Fri Oct 28, 2005 4:40 am

Does this job work at runtime?

track_star · Post by **track_star** » Fri Oct 28, 2005 8:11 am

Have you been able to get any jobs to connect to Oracle and do anything?