SAP Knowledge Base Article - Preview

2540218 - DBISQL: SQLCODE 311 The optimizer could not find a unique index which it could use to scan table 'dbo.process_status' for cursor 'jconnect_implicit_#' - SDK for SAP ASE

Symptom

  • When using Interactive SQL 16.0 connecting to ASE 15.7, an error is thrown.
  • Error SQLCODE=311, Severity Level=16, State=2:
    • The optimizer could not find a unique index which it could use to scan table 'dbo.process_status' for cursor 'jconnect_implicit_3'.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0 GA
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP138
  • DBISQL tool 16.0.0, build 1786
  • Microsoft Windows x64 (64-bit)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise SDK 16.0

Keywords

"SAP ASE", Developer's, Adaptive Server Enterprise SDK, Developers, OCS, jdbc, jConnect , KBA , BC-SYB-SDK , SDK , 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.