2557825 - Left Join hang when a particular query within SP runs - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL06

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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