SAP Knowledge Base Article - Preview

2422617 - BEX query ending with SQL error 30046 and SQL error 325

Symptom

  • Error SQL 30046 is returned when executing a BEX query :

KBA_2422617_01.png

  • ST22 dump is generated as well:

Category Resource Shortage
Runtime Errors DBIF_REPO_SQL_ERROR
Date and Time

Short text 
SQL error 30046 occurred when accessing program 

What happened?

 Error Text of the Database: "[ASE Error SQL30046:08S01][SAP][ASE ODBC 
 Driver]Connection to the server has been lost. Connection died while reading 
 from socket. ERRNO returned 0. Check the server to determine the status of any 
 open transactions."

  • When checking SM21, error message SQL325 is also reported, and when checking the developer trace file along we can see the complete offending SQL code followed by these messages:

C dbdssyb: DBSL99 SQL325
C [ASE Error SQL325][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan, check its correspondence to the query. If not, please contact SAP Technical Support.
C
B ***LOG BY2=> sql error 325 performing OPC [dbds 398]
B ***LOG BY0=> [ASE Error SQL325][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan, check its correspondence to the query. If not, please contact SAP Technical Support.
[dbds 398]


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

CR800655, 800655, CR#800655, CR810688, CR#810688, 810688, abstract plan, query plan, SQL325 , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.