2074831 - Errors running sp_shmdumpdisp - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2074831 - Errors running sp_shmdumpdisp - SAP ASE

Symptom

  • Msg 265, Level 16, State 1 - Insufficient result space for explicit conversion of INT value '1234567' to a CHAR field.

 

 

When running the following command we got errors:

sp_shmdumpconfig;

 

Configured Shared Memory Dump Conditions

----------------------------------------

 

  Error      3626

    Error Text              The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break

the query into smaller pieces. spid: %d, suid: %d, hostname: %.*s, application name: %.*s

    Maximum Dumps:          Default (1)

    Dumps since boot:       0

    Halt Engines:           Default (Halt)

    Cluster:                Default (Local)

    Page Cache:             Default (Omit)

    Procedure Cache:        Default (Include)

    Unused Space:           Default (Omit)

    Dump Directory:         /var/crash/sybase/

    Dump File Name:         3626_error.dmp

    Estimated Compressed File Size:    49055 MB

    Estimated Uncompressed File Size:    196221 MB

 

 

Current number of conditions: 1

Maximum number of conditions: 10

 

Configurable Shared Memory Dump Configuration Settings

------------------------------------------------------

Dump on conditions: 1

Number of dump threads: 8

Include errorlog in dump file: 1

Merge parallel files after dump: 1

Shared memory dump file compression level: 1

Msg 265, Level 16, State 1

Server 'SERVER', Procedure 'sp_shmdumpdisp', Line 873

Insufficient result space for explicit conversion of INT value '1395375' to a CHAR field.

(return status = -6)

 

 


Read more...

Environment

SAP Adaptive Server Enterprise 15.7 ESD 4.2

Product

SAP Adaptive Server Enterprise 15.7

Keywords

sybmon, CSMD, memory dump , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.