SAP Knowledge Base Article - Preview

3053562 - ASE Error SQL30046 / Error 2780 : maxlen (#) is less than length (##) - SAP ASE

Symptom

  • Intermittent short dump with SQL30046

Database error text: "SQL message: [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." 

  • developer traces shows error SQ31031 at the time of the issue  : 

 ***LOG BY4=> sql error 31031  performing FET on table <tablename> [dbdbslst     4663]       

  • ASE log reports error 2780 (maxlen (8) is less than length (98)) with stacktrace in mk_constant

full stacktrace include the following calls :

terminate_process+0xb1e()        
exc__raise               
exc_raise           
mk_constant              
bconst                 
tdsrecv_params          
tdsrecv__paramfmt_params 
tdsrecv__xoltp_setup     
tdsrecv__dynexec_xoltp  
tdsrecv__dynexec   
tdsrecv_dynamic         

  • DBclient at the same ASE level
  • No discrepency between the  DDIC column definition of the table compared to the definition of the table at the database level


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PLxx
  • DBSL: 749.05 Patch Level: 936

Product

SAP Supplier Relationship Management 7.0 on SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

SQL31031, DBSQL_SQL_ERROR, 30046, sql error 30046,SQL30046, error 2780 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.