Symptom
- UPDATE INDEX STATISTICS failed during SUM upgrade:
EXECUTING G:\usr\sap\Q3L\SUM\abap\bin\SAPuptool.EXE execdb ..\var\SYBSHDSTATS.TSQL
Logging to 'G:\usr\sap\Q3L\SUM\abap\log\SYBSHDSTATS.LOG'
1EETQ008 Error message: DBSL error 99 (db code 267):
1EETQ009X[ASE Error SQL267]Object '##DDANNOENTITY_C~' cannot be found.
SYBSHDSTATS.LOG
===============
3 ETQ398 SQL: select $EXEC( 'UPDATE INDEX STATISTICS [SAPSR3.DDANNOENTITY_C~] ')
4 ETQ010 Date & Time: 20210812093139
1EETQ008 Error message: DBSL error 99 (db code 267):
1EETQ009X[ASE Error SQL267]Object '##DDANNOENTITY_C~' cannot be found.
1EETQ003 exit code: "20"
4 ETQ399 Rollback.
- Create and query GTT out of SUM also fail with same error SQL267:
1> CREATE GLOBAL TEMPORARY TABLE sapsa_t1(c1 int)
2> go
1> select * from sapsa_t1
2> go
Msg 267, Level 16, State 5:
Server 'xxx', Line 1:
Object '##sapsa_t1' cannot be found.
1> UPDATE INDEX STATISTICS sapsa_t1
2> go
Msg 267, Level 16, State 5:
Server 'xxx', Line 1:
Object '##sapsa_t1' cannot be found.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
CR 821261, SUM, SYBSHDSTATS, UPDATE INDEX STATISTICS, UPDATE STATISTICS, GTT, SQL267, Object '##' cannot be found. , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview