I am trying to implement Maintenance Management and using DMT to prep for the addition of this module. When adding a warehouse with the warehouse template via DMT, I get the error below. I cannot find enough definition in either the error or the data dictionary to determine which table.field is causing the error.
Error:
WarehouseCode MAINT ForeignKeyConstraint LRWarehseEntityGLC requires the child key values (, MAINT) to exist in the parent table.
Does anyone have that little mystic wisdom on this reference to ‘LRWarehseEntityGLC’ that might break this free? I looked thru the EntityGLC table and the Data Dictionary and a couple of other sources to get a better idea of what is missing. I think I understand it conceptually but cannot determine the right location of the missing piece.
I drafted this yesterday and did not post. I still have the question about the LRWarehseEntityGLC reference but it also appears that at some point the DMT might have partially entered the warehouse I was trying to create… but failed to complete the transaction?? When attempting to hand enter thru Warehouse Maintenance, it says the “Warehouse belongs to another site”. No sites list the warehouse and a BAQ of the warehouse table nor any other related table lists this warehouse ID. Anyone got any ideas how to find and fix this situation short of dumping the DB and starting over again? I still have no idea why this happened either, the warehouse template is very straight forward and I am using the minimum fields required according to the template and the ‘Required’ button in the DMT (yes I know she (DMT) lies to me about this all the time, but hey, what can I say, I love her