Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Enhancements

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th May 2003, 04:40
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Check Table's Data Dictionary

We have had many issues with the bdbreconfig and I guess we customize heavily. We have code migrations every weekend and a Table/Domain migrations every 2 weeks.

Among the major issues with the bdbreconfig is that the actual change did not happen on the tables in certain companies. And we used to use some fake changes on the table to trick (also posted on the board here) the create/convert runtime sessions to make it work.

The session Check Table - ttaad4232m000 gives us only a top view of the problems with the 506-tables do not exists, 512-corrupted DD, 2017-wrong database login/password etc.

Hence, we developed this tool which checks the BaaN and Oracle Data Dictionaries across all the company in all the databases and gives a report.

It will be nice if there are any verification tools in the standard tools to do this process for Oracle/Informix, DB2 etc.
Attached Files
File Type: doc check-table-dd.doc (136.5 KB, 156 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
  #2  
Old 15th May 2003, 09:56
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
Maybe not relevant, but if you do a lot of inserts/deletes on ttadv500-505, ttaad400. Do you also reorganize these tables every once in a while? This to avoid RDD problems due to index problems on these tables...
__________________
Also read Luke 24:4-8
Reply With Quote
Sponsored Links
  #3  
Old 15th May 2003, 10:08
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Yes we do... and we have many cases with support for issues with the bdbreconfig. For more info, you might just search at the support site on the cases logged for Reger-5.2 Version. Its a lot improved/enhanced and stable for now, but we still face issues ocassionally, due to developers making the table/domain/index changes or with the binary itself. We are now so proactive that we take a hot backup of OS and database before code migrations and if anything fails we can restore the whole environment in few hours without badly exceeding our sunday downtime period. This has been one of our proactive monitoring tools.
__________________
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
  #4  
Old 15th May 2003, 17:49
sikima's Avatar
sikima sikima is offline
Junior Member
 
Join Date: Oct 2002
Location: Toronto
Posts: 26
sikima is on a distinguished road
Baan: 1.0 - LN - DB: Oracle, SQL Server - OS: Unix, Windows
It could be a problem with shared memory and NT. I have had a similar problem and I have removed VRC devp from shared memory. Also, after that I have Create Runtime DD. If you want quick solution, you can remove specific table from shared memory.
Reply With Quote
  #5  
Old 16th May 2003, 08:35
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
Our experience is that even when shared mem is cleared, sometimes still the old file comes up. This is (was our analysis) due to OS file caching. Also the OS cache seems not to refresh when a file is new on disk.
__________________
Also read Luke 24:4-8
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
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 06:38
What does Reorganize Tables do when you check Data and Indexex Joy Conner Tools Administration & Installation 3 13th August 2004 23:32


All times are GMT +2. The time now is 17:27.


©2001-2017 - Baanboard.com - Baanforums.com