SAP Knowledge Base Article - Preview

2557825 - Left Join hang when a particular query within SP runs - SAP ASE


After upgrading to PL06 Stored Procedure (SP) is hanging, all appears to be at queries that involve Left Joins. These queries run in seconds in Production ASE 16.0 SP02 PL05 version but never return (and fill up tempdb) in PL06.



SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL06


SAP Adaptive Server Enterprise 16.0


left Join, CR#804411,#804411 , 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.