topic Re: Error while modifying the Ztable in Application Development and Automation Discussions

Error while modifying the Ztable

former_member213475 — Fri, 15 Nov 2013 11:51:46 GMT

I am modifying one Ztable. in that I'm changing the primary key fields as non primary key fields. simply unchecking the check boxes. For this table there is no table maintenance generator.

But I am getting the error as

Data base object for table <Ztable> is inconsistent.

Please suggest me, how to solve this issue

Thanks.

Re: Error while modifying the Ztable

RaymondGiuseppi — Fri, 15 Nov 2013 12:00:02 GMT

Did you first check for existence of duplicate records when those primary keys would be removed, that would prevent activation of the table at database level.

Regards,

Raymond

Re: Error while modifying the Ztable

Former Member — Fri, 15 Nov 2013 12:02:08 GMT

If the entries in the table are not important then delete the entries and then try to activate.

Re: Error while modifying the Ztable

former_member213475 — Fri, 15 Nov 2013 12:11:01 GMT

If I delete the entries in that table, then it is possible to do?

Thanks

Re: Error while modifying the Ztable

former_member213475 — Fri, 15 Nov 2013 12:11:56 GMT

I haven't checked. I need to confirm from my client.

Thanks

Re: Error while modifying the Ztable

Former Member — Fri, 15 Nov 2013 12:17:13 GMT

Yes, I think so.

Re: Error while modifying the Ztable

Former Member — Fri, 15 Nov 2013 12:17:54 GMT

Hi,

Yes, delete duplicate enties in table and activate. It will get activated.

If you still face any problem then you could do 'activate and adjust database' in SE14.

Best Regards,

Abirami

Re: Error while modifying the Ztable

former_member213475 — Fri, 15 Nov 2013 12:26:39 GMT

Thanks Abirami

But, with out deleting the entries, is it possible to solve this issue?

Re: Error while modifying the Ztable

Former Member — Fri, 15 Nov 2013 12:34:27 GMT

Hi,

I dont think so. You could try better by taking back up of your table data and adjust in SE14.

Till duplicate entries exists, it will not allow you to activate the table.

Best Regards,

Abirami

Re: Error while modifying the Ztable

venkat_aileni — Fri, 15 Nov 2013 18:44:39 GMT

Hi-

In your Z-Table as you have modified primary key fields to non-primary key fields. Hence there is an inconsistency in your table structure. How to overcome this error you have Activate and adjust this table in SE14.

What will happen after activating your table in SE14?

Assuming your table consists of 3 fields out of which first 2 fields are primary keys:

In below table field1 and field2 are key fields:

Field1 Field2 Field3

------------------------------

1 1 6

1 2 6

1 3 6

Now I have changed field2 as non-primary field.

Goto SE14 adjust and activate this table.

After above step if you check this table it will contain only one entry, as now field1 is the only primary key. Once you adjust your table in SE14 all these entries(other 2 records 2nd and 3rd) gets automatically deleted.

Now table will have below entry:

Field1 Field2 Field3

------------------------------

1 1 6

So be careful before adjusting your table in SE14.

Note: Deleting duplicate entries in your table will not allow you to activate your table, you have to for sure adjust your table in SE14.

-Venkat

Re: Error while modifying the Ztable

former_member213475 — Sun, 17 Nov 2013 07:08:37 GMT

Hi venkat,

Thanks for your valuable answer.

Regards,

Saran.