topic Re: Table activation in Application Development and Automation Discussions

Table activation

former_member195202 — Tue, 20 May 2008 10:50:22 GMT

Hi Folks,

I have created a table named ZEDH_PAR_0889. but I am not able to activate it. I deleted it and again created it. I am getting the error

*No active nametab exists for ZEDH_PAR_0889"

Here is the log display:

TABL ZEDH_PAR_0889 was not activated

Check table ZEDH_PAR_0889 (PESAS0/20.05.08/11:43)

A table called ZEDH_PAR_0889 exists in the database

No active nametab exists for ZEDH_PAR_0889

Termination due to inconsistencies

Table ZEDH_PAR_0889 (Statements could not be generated

Error number in DD_DECIDE (9)

Check on table ZEDH_PAR_0889 resulted in errors

Status of the table is "New". I ve read the other similar threads on the forum but the case was little different where someone changed the field of the table and getting error "No nametab exits"

Can anyone please help

Re: Table activation

former_member195202 — Tue, 20 May 2008 11:00:44 GMT

My problem is same as this one

but this thread has got no solution

Re: Table activation

vinod_vemuru2 — Tue, 20 May 2008 11:17:24 GMT

Hi Ravi,

Is this new table or already existing table? If it is old one then compare old and new versions n see the difference.

First check the status of check tables used in ur ztables whether all are exist and in active state. If yes then chek below things.

Probable reason could be some one created table with same name and deleted. But when they deleted it got deleted form data dictionary. But in Data base(Generally it is Oracle) it did not got dropped. Try creating new table with same fields and see what is happening. if it got activated then the above assumption will be correct. If not then let me know. If it got created then copy this new table to ur original name and activate. Before this u have to delete current table.

Thanks,

Vinod.

Edited by: Vinod Kumar Vemuru on May 20, 2008 4:49 PM

Re: Table activation

former_member195202 — Tue, 20 May 2008 11:28:20 GMT

Hi Vinod,

Thanks for reply...

I ve deleted it many times after creating. I tried to create a new one and activate it. Every time it gives the same error

"No Active Nametab exists for ztable"

The status is always new. I ve tried to created with different number of fields ( 2, 3 4...etc.) but it seems as if the name is creating the problem. you are right that the name of the table has been replicated on the database level and that's why I am unable to activate it.

I tried another ztable ...which are giving no error while activating.

I guess the name of this table has to be dropped at database level..

Re: Table activation

Former Member — Tue, 20 May 2008 11:33:24 GMT

Hi Ravi,

Try this.

In the Menu select Utilities - > Database Object -> Database utilities.

There try "Activate and Adjust database" option. If it doesn't work, try to delete database table and create database.

Thanks and Regards,

Lakshmi.

Re: Table activation

former_member195202 — Tue, 20 May 2008 13:52:53 GMT

Hi Santhanalakshmi,

This option is appearing as disabled since the table status is "New".

This option is also there in Transaction se14 but same way....it is disabled there....I guess this option would have been worked if the table was active earlier and later some changes would have been made..

But since this is new creation ( many times I ve deleted it to create and activate it again) and was never activated....so this option is not working...

Re: Table activation

Former Member — Tue, 20 May 2008 15:53:08 GMT

Hi Ravi... Check In The Version Management And u can find The table With Two Versions... And Delete The Old one... Hope This May Solve Your Problem...

Reward Points IF Helpful.

Regards,

Narin Nandivada

Re: Table activation

former_member195202 — Tue, 20 May 2008 16:54:57 GMT

Hi Narin,

I have already tried that option....did'nt work

Re: Table activation

Former Member — Mon, 29 Nov 2010 14:19:26 GMT

so what happened finally?

Re: Table activation

Former Member — Mon, 29 Nov 2010 14:26:57 GMT

Have you maintained technical settings correctly?

Also check error log long text...that may help you to resolve the issue...

Regards

Praveen

Re: Table activation

RaymondGiuseppi — Mon, 29 Nov 2010 15:21:08 GMT

Check OSS [Note 306296 - No active nametab for <table> exists|https://service.sap.com/sap/support/notes/306296] - active nametab does not exist, database table exists.

Then as suggested by the note, use an EXEC-SQL statement to drop the database table or delete it from database server and not from Sap.

Also check technical settings and the translation of data classes into actua database. (Which version of SAP, which kind of database are you using)

Regards,

Raymond

Re: Table activation

former_member193284 — Mon, 06 Dec 2010 17:44:41 GMT

Hi Ravi,,

use SE14 to adjust the table and then try activating.

thanks

Re: Table activation

Former Member — Mon, 06 Dec 2010 18:05:42 GMT

Before offering any more advice, please see the date on the OP.

Rob