Symptom
After ASE upgraded, "update index statistics" gets error 3626 / 11031 / 2706. Msg 11031 complains on partition. Msg 2706 complains the object does not exist. However, the object DOES exist.
1> update index statistics [db1.user1.table_t1] with sampling = 100 percent, consumers=26
2> go
Msg 3626, Level 17, State 4:
Server 'XXXX', 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: 77, suid: 7, hostname: cccc02.abcdefg.in, application name: isql
Msg 11031, Level 16, State 1:
Server 'XXXX', Line 1:
Execution of unknown type ptncond_1008771670_2 failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate user1.ptncond_1008771670_2.
Msg 2706, Level 11, State 1:
Server 'XXXX', Line 1:
Table 'db1.user1.table_t1' does not exist.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
Product
Keywords
3626, 11031, 2706, Msg 3626, Msg 11031, Msg 2706, update statistics, update index statistics, stack size, source text, syscomments , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.