error while viewing the Oracle Enterprise stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajesh.ravi
Participant
Posts: 8
Joined: Thu Dec 20, 2007 1:04 am

error while viewing the Oracle Enterprise stage

Post by rajesh.ravi »

##I TFCN 000001 17:30:40(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TOSH 000002 17:30:40(001) <main_program> orchgeneral: loaded
##I TOSH 000002 17:30:40(002) <main_program> orchsort: loaded
##I TOSH 000002 17:30:40(003) <main_program> orchstats: loaded
##W TCOS 000049 17:30:40(004) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##F TFPM 000281 17:30:40(005) <main_program> Fatal Error: Caught unknown exception in main program: terminating.
>
>
Pls Help me for this issue
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Did this occur during a job run or while using View Data?

Does it happen every time, intermittently, or was it just the once?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rajesh.ravi
Participant
Posts: 8
Joined: Thu Dec 20, 2007 1:04 am

Post by rajesh.ravi »

while using View Data i am getting the above error .

pls suggest me to solve this issue.
Last edited by rajesh.ravi on Mon Jan 21, 2008 11:35 am, edited 1 time in total.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

rajesh.ravi wrote:while using View Data i got a error when it was fisrt time used. I am learning parrllel job.

pls help me for this issue.
Can you describe what properties you are setting in the OCI Stage.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
rajesh.ravi
Participant
Posts: 8
Joined: Thu Dec 20, 2007 1:04 am

Post by rajesh.ravi »

Hi i am using Oracle Enterprise stage, i got error like this.i gave the details like
table name,
user name,
password,
remote server.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

what else? For example what Read Method are you using? Do you have the correct column definitions for this table loaded?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rajesh.ravi
Participant
Posts: 8
Joined: Thu Dec 20, 2007 1:04 am

Post by rajesh.ravi »

Hi,
i gave read method is Table and gave correct column definition but i got error like this.

pls suggest me to solve this issue.
ramesh_inform
Participant
Posts: 57
Joined: Mon Dec 03, 2007 12:43 am
Location: hyderabad

Post by ramesh_inform »

do u hav the proper DSN connections? :roll:
ramesh.n.
ramesh_inform
Participant
Posts: 57
Joined: Mon Dec 03, 2007 12:43 am
Location: hyderabad

Post by ramesh_inform »

check ur DSN connections and remote server connections
If they r correct,open ur sql plus
and check whether the table exists or not?
ramesh.n.
Post Reply