VBAP table activation taking forever - unable to add new fields

[Former Member]

Hi Experts,

We are facing a strange issue while adding new fields to VBAP table via append structure. After adding new fields and clicking ACTIVATE, it goes into wait mode (probably hang mode), we had waited for 15-16 hours, then had to kill the process.

• New fields in append structure are simple CHAR fields.
• New Z Structure name is provided such that these fields will be in the end of table and not in the middle of existing fields.
• This is happening in DEV (not related to PRD or Transports etc)
• SE14 (adjust database) step is after activation, but here issue is in activation itself
• Runtime and database objects are all consistent before trying to add the fields
• Table fields length doesn't exceed max limit of 4030 char
• There are 9 custom append structures already in table (with our custom fields), I though it can be due to max limit of 9 append in any table, but tried on a customer transparent table (ZXYZ) and able to add more than 9 append structures easily
• Data in our VBAP table is huge (30 million) but that shouldn't be reason of activation problem
• Basis team also cannot find anything unusual database side for VBAP table

Please suggest what else can be tried out. Is there a possible way that new fields can be added by basis team at database level directly (using alter table), will it work, how to transport it ?

[matt]

I was going to suggest that you talk to Basis as this is most likely a database issue. However, you've done that, so I think your only recourse is to report to SAP and have them have a look.

[Former Member]

Thanks Matthew for response, yes we have already raised an incident to SAP today morning, waiting for their response as well.

[former_member186746]

Hi,

Ask basis to check if this is a memory/sizing issue. Either the specs of the dev system is low or the allocation to dialog processes is low.

Oh and check OSS there are notes on this subject.

Kind regards, Rob Dielemans

[former_member321143]

Is SE14 - activate and adjust in background mode not working as well?

[Former Member]

Isn't that suppose to work only after activation

[Former Member]

Yeah Rob, I was also counting on basis but unfortunately they couldn't find anything 😞

[Former Member]

Any other tips which can be tried....or maybe some detailed steps which we can ask Basis team to try out