SAP Knowledge Base Article - Preview

2512989 - Error 11055: Query contains an illegal outer-join request - SAP ASE

Symptom

  • Old stored procedure with queries that have outer joins fail with Error 11055 on ASE 16.0:

Error (11055) Severity (16) State (2) Server (xxxxxx) Procedure (xxxxxxx) Query contains an illegal outer-join request 

  • The same stored procedures run without errors on ASE 15.0.3.  
      
  • This is a simplified example of a failing query:

select   p1.person_id,
           p1.ssn,
           (select p2.person_id
                  from    unused_person_id p2
                  where  p1.person_id *= p2.person_id)
from    person_test p1,
           dp_person_test dp
where  p1.ssn *= dp.ssn           


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

CR125533, CR#125533, 125533, CR#194304, CR194304, 194304, TF, trace, flag, 298, correlated, outer, join, subquery, 11013, 301 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.