Stacy Long
22nd November 2016, 22:43
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

mark_h
23rd November 2016, 14:16
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.

VishalMistry
23rd November 2016, 15:42
Hello,

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

Vishal

Stacy Long
24th November 2016, 22:33
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.

mark_h
27th November 2016, 01:34
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.