768: Internal error in routine opjoin().

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henry - 06 Oct 2006 07:05 GMT

Hi all,

I hit with an error while executing a sql query. The error message is:

768: Internal error in routine opjoin().

Any idea what is it and how to solve it?

Thanks for your help!

Reply to this Message

Superboer - 06 Oct 2006 12:32 GMT

Phone TS.
sounds like you hit a bug.

run oncheck for the affected tables....execute qry.
if error then
try update stats for the tables-->> execute qry.
if error then
try update stats drop distributions for the tables affected -->>execute
qry.
if error then
update stats medium or high;-->> better use Arts dostats for it ...
-->>execute qry.

if still error ... sorry.

DO CONTACT TS

Superboer.

Henry schreef:

> Hi all,
>
[quoted text clipped - 5 lines]
>
> Thanks for your help!

Reply to this Message

scottishpoet - 06 Oct 2006 15:15 GMT

Known defects exist that report this error, in particular with left
outer ansi joins

Fixes should be available

Contact your support provider

Reply to this Message