Inconstistencies between database object and runtime object

[TJRP]

Hello there,

I have created an append structure for table QMEL called ZAQMEL and have added some fields to this structure.

Today I have added a new field to the append structure and I am having problems activating the table.

I carried out the following.

I created a new data element and activated the element.

I activated the append structure and a message popped up saying that the append strucutre and table QMEL were partically activated.

I used transaction SE14 to activate and adjust the database, this came up with an error "Using Transaction SE11 (Extras->Database object-> Check) determine the type of inconsistency and correct it. Then activate the table again and execute the conversion"

I have tried this and I keep going round in cirles. SE11 -> se14 and then se14 -> se11.

Currently the runtime object has my new field on but the database object does not.

Any suggestions?

Cheer J-J

[FredericGirod]

Hi,

First, what kind of data you would like to add ? Do you see any error message ? Did you check the SM21 ?

Second, did you try to go in SE11 Extra->Database ->activate & maintain data ?

Rgd

Frédéric

[TJRP]

Hi Frédéric,

I have looked at SM21 and have found this > ORA-00904: "ZZBX_INSP_UP": invalid identifier.

the filed that I was trying to add has a dataype of INT4 length 10

econd, did you try to go in SE11 Extra->Database ->activate & maintain data ? and cannot see this we are using version 47, will the path be different?

Cheers

J-J

[FredericGirod]

Maybe start with the solution of Laxmana Kumar.

SE11 Utilities -> Database utilities -> Direct + Save data + Activate and adjust database.

Fred

[Laxmana_Appana_]

Hi,

Check the enhancement category of the table , if it is not 'Can be enhanced(deep) , you can't add all kinds of data type fields.

Laxman

Reward points if the answer is useful to you.

Message was edited by: Laxmana Kumar

[TJRP]

Laxman

I have checked the enhancement category and it can only have character type or numeric type.

I have tried to change my data type and re-activate it but this then partically activates the table and we go round in a loop again.

We now know the cause of the problem

Cheers

J-J

[Laxmana_Appana_]

Hi

Run this program : RSDDCHECK, you will know the consistency. give type name as QMEL

Laxman

[TJRP]

Laxman

I have run the program and it came up with QMEL was not active I tried to activate it and it came back with errors during activation and said use SE14, I ran SE14 and erros occured and it said use SE11.... back in my loop again

Cheers

J-J

[Former Member]

U need to name ur field(eg:zzfieldname or yyfieldname) according to user name space ....... try to find this errror while creating ur append structure. The error log will specify u the name spaces valid for creating append structures.

[Former Member]

Hi,

First activate the structure then , come to your table QMEL .

first <b>check the synatx</b> of the tabel.

now Go to menu <b>Utilities-> Data Base Utiliy-> Activate and Adjust.</b>

now again activate the Table.

Regards

vijay

[Former Member]

This is how that Oracle message is explained

[code]

ORA-00904: string: invalid identifier

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word. [/code]

Based on your message, I don't think it is the column name that is the issue here. What is data element for this field? Is that activated? Also check the activation log, it will show the underlying database commands that SAP is using. May be you will find some hint there.

Srinivas

[TJRP]

The table can be reactivated using FM DD_TABL_ACTM and option 12 Activation of table without checks.

Cheers

JJ