Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Unable to delete/modify Index

Former Member

‎2010 Jun 01 1:07 PM

0 Likes
755

Hi,

i'm currently upgrading from R/3 4.6C to ERP 6.0 EHP4 SP06 and the upgrade stopped in PARCONV_UPG due to non-existent field in user index VBAP~Z02. The filed in question has been removed as part of the upgrade but is still part of the customer index. For that reason PARCONV_UPG failed trying to create the index.

Now, SE11 -> display results in SYNTAX_ERROR maybe due to running upgrade.

SE11 -> change tells me that table is locked due to existing protocol.

How can i drop the index in question from ABAP Dictionary without SE11 ?

Regards,

Hi,

i'm currently upgrading from R/3 4.6C to ERP 6.0 EHP4 SP06 and the upgrade stopped in PARCONV_UPG due to non-existent field in user index VBAP~Z02. The filed in question has been removed as part of the upgrade but is still part of the customer index. For that reason PARCONV_UPG failed trying to create the index.

Now, SE11 -> display results in SYNTAX_ERROR maybe due to running upgrade.

SE11 -> change tells me that table is locked due to existing protocol.

How can i drop the index in question from ABAP Dictionary without SE11 ?

Regards,

Reply
2 REPLIES 2
Read only

Former Member

‎2010 Jun 01 1:49 PM

0 Likes
569

Hi,

I am not sure if this won't end the same as operations you have tried in se11, but you can give it a try -> SE14 (ABAP Dictionary - Database Utility).

You can maintain e.g. indexes in there.

Regards,

MC

Read only

Former Member
In response to Former Member

‎2010 Jun 01 2:22 PM

0 Likes
569

Marcin,

already tried but he told me that the table is locked due to active conversion. Trying to unlock the table in order to delete the index will remove all entries of the table which is not good.

As this is a sandbox system i tried modifying tables DD17S, DD12T and DD12L using SQL-Interface removing the index in question. It seems to work and PARCONV_UPG completed without further errors.

Regards,