runLocally() of the operator failed

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
sreelalpp
Participant
Posts: 22
Joined: Sun Jan 01, 2006 6:51 am

runLocally() of the operator failed

Post by sreelalpp »

Hi,

I am getting the following error message on a lookup stage looking into an SQL Server table through ODBC stage.


"The runLocally() of the operator failed."

What could be the root cause for this ?

ODBC_CO_LOC_GL_V_LKP,0: The runLocally() of the operator failed.

Thanks,
Sreelal
lal
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

What kind of lookup is it?

Are you able to view data?
sreelalpp
Participant
Posts: 22
Joined: Sun Jan 01, 2006 6:51 am

Post by sreelalpp »

Sainath.Srinivasan wrote:What kind of lookup is it?

Are you able to view data?
It is a normal look up to an SQL Server table and I am able to view data.
The lookup stage has the reference link 'Entire' partition and the input stream auto.
lal
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Can you view the data ?
sreelalpp
Participant
Posts: 22
Joined: Sun Jan 01, 2006 6:51 am

Post by sreelalpp »

Sainath.Srinivasan wrote:Can you view the data ?
Yes. I am able. to view data.
lal
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What is your "Lookup Failed" rule?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sreelalpp
Participant
Posts: 22
Joined: Sun Jan 01, 2006 6:51 am

Post by sreelalpp »

ray.wurlod wrote:What is your "Lookup Failed" rule? ...
Ray, The lookup failed rule is 'Continue'
and no condition is set.
lal
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

What if you write a job with source from the ODBC stage?
Post Reply