Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 22nd November 2016, 21:43
Stacy Long Stacy Long is offline
Newbie
 
Join Date: Nov 2016
Posts: 2
Stacy Long is on a distinguished road
Baan: Baan IV / LN - DB: Oracle - OS: HP UX
unable to remove table reference
Baan: Other/Unknown
C/S: None/Unknown

Hi there,
My problem is with removing a table reference. I can't seem to get the system to recognize that the reference to the parent table should no longer be checked. It's a custom table listing contacts by BP/Location address. There was a combined field of BP/Contact that had a mandatory reference to tccom145 (Contacts by BP). The business decided that they wanted to allow entry to this custom table of contacts related not only to the BP in the record, but to the ship-to BPs associated with it. So, remove the table reference and add code to check the contact.

The problem is that the system still checks the reference of the combined field to tccom145. To remove this I have tried:
- changing the reference to not mandatory
- removing the reference altogether
- removing the combined field altogether
I have converted and even created runtime DD and logged out repeatedly. But I still get the "606 reference does not exist" on the combined field that no longer exists at all. So what else can I do? where is it storing this reference? I've checked the file for the table in $BSE/dict. The combined field is gone. No reference to tccom145.

Thanks,
Stacy
Reply With Quote
  #2  
Old 23rd November 2016, 13:16
mark_h's Avatar
mark_h mark_h is online now
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Did you re-configure (or create RDD) for both tables - not just the table you are removing the reference from? So the custom table and tccom145.
__________________
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
Sponsored Links
  #3  
Old 23rd November 2016, 14:42
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 566
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Hello,

Mark is right. It requires re configuring both the tables.

Vishal
Reply With Quote
  #4  
Old 24th November 2016, 21:33
Stacy Long Stacy Long is offline
Newbie
 
Join Date: Nov 2016
Posts: 2
Stacy Long is on a distinguished road
Baan: Baan IV / LN - DB: Oracle - OS: HP UX
Hi there,
Yes, thanks. Ran both convert to runtime DD and Create Runtime DD with open ranges. Still doesn't work. Even tried dropping the tccom145 table and recreating it.
Reply With Quote
  #5  
Old 27th November 2016, 00:34
mark_h's Avatar
mark_h mark_h is online now
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Have you checked your RDD files out in the unix directory? Confirm they are getting deleted and recreated? You might also need to check shared memory. I have seen these hang and not really convert. Not sure what our sysadmin does to force it to happen.
__________________
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
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
Use of "background" keyword in Baan kruyoupatel Tools Development 2 27th April 2016 07:03
Zoom Menu Return Multi Value layswan Tools Development 3 24th July 2012 09:42
zoom to correct business partner jojovalenton Tools Development 5 14th October 2009 10:26
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 14:08
copy records c_siek Tools Development 9 18th June 2004 15:43


All times are GMT +2. The time now is 15:07.


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