SAP Knowledge Base Article - Preview

1894602 - How to solve error "[ASE error SQL158]Too many ORDER BY expressions. The maximum is 31." - SAP ASE for BS

Symptom

You are running SAP Business Suite on SAP Sybase ASE 15.7 and a business transaction or a report stops with the following error message:

Category                 Installation Errors

Runtime Errors           DBIF_RSQL_SQL_ERROR

Except.                  CX_SY_OPEN_SQL_DB

Date and Time            24.06.2013 10:28:30 


Short text               SQL error 158 when accessing table "FAGLFLEXT".


What happened?           Error Text of the Database: "[ASE Error SQL158]Too many ORDER BY expressions.  The maximum is 31."


The Short text may reference a different table name.


Read more...

Environment

The following versions of SAP Sybase ASE are affected:

  • SAP Sybase Adaptive Server Enterprise (ASE) 15.7 up to and including ESD#4.2 for Business Suite
  • SAP Sybase Adaptive Server Enterprise (ASE) 15.7 SP100, SP101, SP102, and SP103 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7

Keywords

ASE error SQL 158; CR730154; Adaptive Server Enterprise; Fehlermeldung; DB-Fehler; , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.