2422617 - BEX query ending with SQL error 30046 and SQL error 325 - SAP ASE for BW

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

• 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]

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

CR800655, 800655, CR#800655, CR810688, CR#810688, 810688, abstract plan, query plan, SQL325 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem