Failure during execution of operator logic.

sateeshbabu · Post by **sateeshbabu** » Thu Aug 24, 2006 11:32 pm

Hi Folks,

I am using sybase stage as source and sequential file as target. I am inserting one user defined query in the sybase stage. When executing the job, I am getting the following error.

Failure during execution of operator logic.

Fatal: Attempt to get target table info from sp_tables failed.

But when i run the query in sybase it showing the data.

Could anybody suggest me on this.

Regards,
Sateesh.M

sateeshbabu · Post by **sateeshbabu** » Thu Aug 24, 2006 11:42 pm

Hi ,

Regarding the above topic i had splitted the query and i ran now.Now i am getting the following warning.

Sybase Server warning 11055 (severity 16) from stored procedure 'sp_tables', line 191: Query contains an illegal outer-join request.

Any suggestions would be great.

Thanks in advance.

Regards,
Sateesh.M

ray.wurlod · Post by **ray.wurlod** » Fri Aug 25, 2006 1:57 am

Lose the illegal outer-join part of your query.