Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
11%
> 2000 GB
24%
Total votes: 79

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 2nd December 2019, 09:12
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 649
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Red face Delete run-time table definition
Baan: Infor ERP 10.4
C/S: Server

Hello Everyone,

Usually, we follow the following process for deleting table definition:

1.Delete a table by using the Database Management->Miscellennous->Delete Tables session (ttadv4231m000) for all the companies
2.Delete table definition using Application Development->Domains and Tables->Table definitions session (ttadv4520m000).

One thing I have noticed is even after deleting table definition, the runtime table def file for the table remains in {BSE}\Dict folder.

Can anybody guide, if there is any process in Baan / ERPLN by which we can delete this runtime file or manually delete it?

Thanks
Vishal
Reply With Quote
Sponsored Links
  #2  
Old 2nd December 2019, 15:39
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,382
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Did you try to crdd for the table or package range to see if that deleted it?
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 2nd December 2019, 20:39
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,110
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Quote:
One thing I have noticed is even after deleting table definition, the runtime table def file for the table remains in {BSE}\Dict folder.

Can anybody guide, if there is any process in Baan / ERPLN by which we can delete this runtime file or manually delete it?
The CRDD Sessions (ttadv5210m000, ttadv5215m000) query the Tools Table Definitions (ttadv420) and then generate the Dictionary files. When you delete the Definitions there is no more information to generate the dict files.

The ideal recommendation is to Expire the Tables and execute the runtimes, so the dict files are marked ".expi"
Attached Images
File Type: jpg Expired-Table-dict.JPG (88.2 KB, 4 views)
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
get rid of table definition in DD spartacus Tools Administration & Installation 4 12th October 2011 13:58
cannot delete customized VRC in table definition Elrodyn Tools Administration & Installation 0 8th August 2009 17:57
table definition not found mraguthu Tools Administration & Installation 2 8th October 2004 23:53
Problem in delete record in table rabbeneg Tools Development 4 31st December 2002 20:54


All times are GMT +2. The time now is 18:51.


©2001-2018 - Baanboard.com - Baanforums.com