SAP Knowledge Base Article - Preview

2191566 - CREATE PROXY_TABLE raises Error 3626 with default stack size - SAP ASE on Windows

Symptom

  • A 'create proxy_table command fails with Error 3626:

1> create proxy_table test123_remote at "remote_ASE.testdb.dbo.test123"
2> go
Msg 3626, Level 17, State 4:
Server 'local_ASE', Line 1:
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: 18, suid: 1, hostname: testwindows, application name: isql
Msg 3626, Level 17, State 4:
Server 'local_ASE', Line 1:
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: 18, suid: 1, hostname: testwindows, application name: isql

  • The default stack size is used in the ASE server
  • Windows platforms


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher
  • Windows 64bit

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR786775, CR#786775, 786775, 'create existing table', existing, recursively , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.