Inconsistent Database object with Runtime object

[snursalim]

Hi experts,

I have a custom table which already has its content in 'PRD'. I needed to add another field and change the field length of a table. After I transported my changes to PRD, my changes resulted in inconsistencies with database object with the runtime object. Which makes the table unaccessable as I tried to read table content, it resulted in a short dump.

I tried to adjust and activate the database using SE11 but the request was not executed succesfully.

I know we can just easily solve this problem by deleting the table and then recreate it. I wanted to avoid this solution as it means that we have to re-enter all the data and ask the data again from the client.

What could we possibly do to solve this problem?

Many Thanks

-Suwardi Nursalim-

[Former Member]

hi suwardi,

cvould be, taht the table is not active, after you changed a fieldlength? is the table active in the transporting system? try se14, when the table is not active. activate an adjust the table.

kindly regards,

robert

[Former Member]

hi,

After u make the required changes to the table..

check for the consistency..

if it consistent..save it.

Go to SE14 - Database Utility.Input ur table name and edit.

Here, U choose the ACTIVATE AND ADJUST DATABASE..with SAVE DATA option.

By doing this, I guess ur problem will be solved.

Regards,

Krishna Chaitanya G

[Former Member]

Hi,

How did you add a field to a ztable did you use append structure or custemising include ? check it once

more over after you do any modification you need to generate again the table maintenanxce generator

Go to SE14 - Database Utility.Input ur table name and edit.

Here, U choose the ACTIVATE AND ADJUST DATABASE..with SAVE DATA option.

with this your problem might solve

Cheers

fareed

[Former Member]

Hi Suwardi,

I am also facing the same issue.

So could you please tel me how you rectified this issue.

Thanks in advance

Dillip Kumar Sahoo

[snursalim]

Hi Dilip,

In my case, my problem is caused by:

1. I changed a field in the table previously 30 Char into let's say 20 Char. While there are data which has length more than 20 char. So what I do is, I changed back my field into 30 char, copy all the data into excel. Then I delete all the data in the database. After I've deleted it, I did the changes I'm supposed to make and reupload the data.

Hope that helps.