topic No database table exists for table in Application Development and Automation Discussions

No database table exists for table

former_member125931 — Wed, 05 Nov 2008 11:58:50 GMT

HI All,

We created a Ztable and used in two of reports these reports woking fine in PRD,few days back we assigned authorization group and functional group to these table now this table throwing eeror in QAS as well as PRD like No database table exists for table ZXXX,client dont want the data in this table so we deleted this table and created with same name to QAS still same error we are unbale to findout the problem.pls any on help me out..

Re: No database table exists for table

Former Member — Wed, 05 Nov 2008 12:10:07 GMT

Hi Sree,

Did you transport the request to QAS and PRD on which you have deleted the ZTABLE.

You need to transport it to QAS and PRD.

Thanks,

Chidanand

Re: No database table exists for table

Former Member — Wed, 05 Nov 2008 12:36:18 GMT

Hi,

Where r u getting this error?

Are u sure that this deleted table is not used anywhere?

Rhea.

Re: No database table exists for table

matt — Wed, 05 Nov 2008 12:43:19 GMT

How did you delete the table and recreate it?

Go into SE14, and recreate the table.

matt

Re: No database table exists for table

former_member156446 — Wed, 05 Nov 2008 13:17:17 GMT

Hi Sree

As an when you make any small change to Ztable you need to adjust the database table.... which will trigger a sequence of step in back end SQL or Oracle.

se11 > ztable >utilities> database utilities> activate and adjust

Re: No database table exists for table

former_member125931 — Thu, 06 Nov 2008 04:18:49 GMT

Thanks alot I resolved my self.

Re: No database table exists for table

former_member273995 — Wed, 09 Jul 2014 06:38:47 GMT

I am getting the same error, please let me know how you resolved it?

Re: No database table exists for table

anil_neegineni — Tue, 02 Dec 2014 23:24:55 GMT

Hi Srinivas,

I am also facing similar kind of issue, can you please let me know your approach towards resolving the issue without deleting the existing data from the table.

Thanks in advance.

Best Regards,

Anil Neegineni