SAP Knowledge Base Article - Preview

2967180 - Object is stuck during Upgrade with activation error : POOLD COMPRESS YES" is too long. The maximum length is 18. SQLSTATE=42622

Symptom

  • Below error is coming up during the Upgrade in SPAM/ SAINT.

Phase CHECK_REQUIREMENTS: Explanation of Errors

 Inactive runtime objects exist for the following ABAP Dictionary
 objects. This represents a system inconsistency and can cause errors
 when importing the Support Package Queue. The import is only continued
 if no inactive runtime objects exist.

 Proceed as follows:
 - Open a new mode
 - Start transaction SE11
 - Enter the relevant object and activate it
 - If it is not possible to activate it using transaction SE11, contact
   SAP Support using component BC-DWB-DIC-AC
 - Repeat the import phase. If no further inconsistencies are found, the
   import is continued

 Phase CHECK_REQUIREMENTS: inactive runtime objects

 Object Type       Object Name

 Table             /ASU/XXX_CONTNV
                   /SDF/XXXX_HEADER

  • Check SE11:

Table /ASU/XXX_CONTNV does not exist in the
Database

=========================

Upon checking the consistency of table in SE11 after moving ahead from above message:

Technical log for mass activation
See log DDIC20200908194734:ACT

TABL  /ASU/XXX_CONTNVwas not activated

=========================================================================
End of activation of worklist
=========================================================================

  • Click See log

Database Log:     DDIC20200908192751:ACT

IN "ED9#POOLD"
INDEX IN "ED9#POOLI"
LONG IN "ED9#POOLD COMPRESS YES"
SQL0107N The name "ED9#POOLD COMPRESS YES" is too long. The maximum
length is "18". SQLSTATE=42622
DDL time(___1): ........21 milliseconds
The SQL statement was not executed
Table  /ASU/XXX_CONTNV (Error adjusting the database)
Table  /ASU/XXX_CONTNV was not activated

===========================


Read more...

Environment

Software Update Manager -ABAP

Database -DB6, DB2

Product

SAP ERP 6.0 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

R3load, DB6, DB2, deferred table creation, compression, PAT05, SQL error -107, SPAM, Support Packages, SQL0107, SQL0107N, SQL0010N , KBA , BC-UPG-OCS , Online Corr. Support (Tools:Supp.-Pack., Addon Install/Upgr) , BC-DWB-DIC-AC , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , BC-DB-DB6-SYS , Database Interface/DBMS , 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.