var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help need regarding IQ Error
I am getting the below error while executing the procedure.
Can someone please help me in solving this error.
ASA Error -1006001: IQ Internal error. Please report this to Sybase IQ support. Input to merge join #06 from child #07 not ordered as required
Thanks in advance,
Last edited by shiya; 05-06-08 at 08:49.
When I tried in google regarding the error, I managed to get a link which says about the same error I faced. The solution mentioned in that link was,
I tried the same, but the problem is not solved. Still I face the error.
In fact, this error came from the indexes.I deleted and recreated, and since then everything has returned to normal.
Kindly help me on this.
I managed to solve the internal error
The problem was with a merge join condition used in my query.
set temporary option join_preference = '-1';
it will avoid sort merge