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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.