SAP Knowledge Base Article - Preview

3088362 - UPDATE STATISTICS Error SQL267 during SUM

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

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

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.