Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    29

    Unanswered: Help need regarding IQ Error

    Hi Experts,

    I am getting the below error while executing the procedure.

    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
    Can someone please help me in solving this error.

    Thanks in advance,
    Shiya
    Last edited by shiya; 05-06-08 at 09:49.

  2. #2
    Join Date
    Mar 2007
    Posts
    29
    Hi,

    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,

    In fact, this error came from the indexes.I deleted and recreated, and since then everything has returned to normal.
    I tried the same, but the problem is not solved. Still I face the error.
    Kindly help me on this.

    Regards,
    Shiya

  3. #3
    Join Date
    Mar 2007
    Posts
    29

    Thumbs up

    I managed to solve the internal error

    The problem was with a merge join condition used in my query.


    Regards,
    Shiya

  4. #4
    Join Date
    May 2004
    Posts
    21
    set temporary option join_preference = '-1';

    it will avoid sort merge

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •