1 Reply Latest reply on Dec 7, 2012 11:28 AM by Steven Hawkins

    Assertion failed

    Sabina Norderhaug Newbie

      One of our queries is giving error: Assertion failed

       

      I was able to simplify the query to the following while it is still giving this same error:

       

          SELECT CHORUS_B."SYSID", CHORUS_B."USERID", CHORUS_B."NAME",

                        CHORUS_B."LUDATE", CHORUS_B."CREDATE", CHORUS_B."SUSPEND", CHORUS_B."LUSYSID",

                        'SECURITY_USERUPDATE.BASEUSER' as "__objecttype__"

              FROM SECURITY_USERUPDATE.BASEUSER AS CHORUS_B

      INNER JOIN SECURITY.SCPUSER AS SU

                   ON (CHORUS_B.SYSID = SU.SYSID AND CHORUS_B.USERID = RTRIM(SU.USERMASK)) 

           WHERE SU.SYSID = 'DE29'

       

      I do not see anything in the query itself or the execution plan that would cause this error. In fact processing plan says "MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)" while based on the stacktrace it looks like data is still being sorted for the join. Is there hint I can try ?

       

      Please advise. Both stacktrace and execution plans are attached. It runs on Teiid8/JBoss7.

       

      Thanks,

      Sabina