topic Database object inconsistency in Application Development and Automation Discussions

Database object inconsistency

Former Member — Wed, 13 Feb 2008 10:56:15 GMT

Hi,

My requirement is to change the field size from 50 chars to 40 for nearly 35 fields fo a DB table (contains data already). But when I try to activate the table, it asks for adjustment via SE14. Now, when i go to SE14 to adjust and activate, it gives me an error saying "Database table object is inconsistent". I check the details which tells "following fields in database table are inconsistent with those in runtime object". And it fails to activate thetable.

Is there some way so that i can sync the runtime object with the database object and hence activate the table? Any pointers to this would be highly appreciated.

Thanks in advance,

Re: Database object inconsistency

Former Member — Wed, 13 Feb 2008 11:13:28 GMT

Hi,

The usual steps for doing databases changes through se14 is when you are changing the primary keys (adding/modifying/deleting) and you have a pre-existing data in the table.

If you do not have any data in the table or the data is not important please se14 or se16 to clean the entire table. Then make your changes to the table. Then save them and activate it.

If there is important data in the table, you should be a little careful with SE14. I would suggest that the field type for the table attribute you are modifying itself should be activated. Then please save and check what are the list of warnings given besides what you can do in se14. Once all that is cleared goto se14 then activate and adjust the table with save as one of the options.

Let me know if this satisfies your query.

Regards,

Arnab Panigrahi.

Re: Database object inconsistency

Former Member — Wed, 13 Feb 2008 11:44:59 GMT

hi..

thanks for the quick response... but the datatype for the changed fields are only CHAR. And the data in the table are very much necessary.

The actual error shown is that: "following 4 fields are not consistent." and then that the lengths of those fields are shown to be conflicting in the database object and the runtime object.

Thanks

Re: Database object inconsistency

Former Member — Wed, 13 Feb 2008 15:56:07 GMT

Hi,

According to your responce the entries in those feilds have length 50 characters. you are trying to truncate them then computer won't decide where it has to truncate. So you have to go to that feilds one by one and do the modifications. That is the only way I can suggest if Se14 is help less.

Thanks

Sarada