SAP Knowledge Base Article - Preview

3260267 - Query with table variable hangs when parallel plan used - SAP ASE

Symptom

  • Error 8206 is reported.
  • Query with table variable hangs when a parallel plan is used.
    Error: 21, Severity: 20, State: 1
    WARNING - Fatal Error 8206 occurred at ??29 2022 10:40AM.  Please note the error and time, and contact a user with System Administrator (SA) authorization.
    Error: 8206, Severity: 20, State: 5
    Object -xxxxxxxxx was not found in WorkTabList.
    Thread (spid=160) initiating parallel primary error processing.
  • Functions in the stack for process.
    LeWkTbl::closeWkTbl
    LePlanOpenAndExecute+0xdb3
    LeScrollCache::LeCacheRelease
    tabvar_release
    s_copytmps+0x198
    batch_loopend
    cem_cec_conn
    LeCleanupTh+0xf2
    LavaThreadDriverMain+0x37e


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise all versions

Keywords

Error: 8206, 8206 , LeWkTbl::closeWkTbl, LePlanOpenAndExecute, LeScrollCache::LeCacheRelease, s_copytmps, CR# 827292 3361305 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.