Symptom
- Error SQL 30046 is returned when executing a BEX query :
- An 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/dev_w* for that related ST22 dump, 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
Keywords
CR800655, 800655, CR#800655, CR810688, CR#810688, 810688, abstract plan, query plan, SQL325 , KBA , BW-SYS-DB-SYB , BW 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.