Rebuilding Component Interface's Structure

We have added custom pages to components like JOB_DATA and PERSONAL_DATA to track organization specific data associated to those transactions.  I consider these types of customization as high value as they tend to meet the business needs without much maintenance.  But one of the maintenance cost is rebuilding the component interfaces that are built off of these two components, often when you add a custom page to the component you will need to also modify the delivered component interface's structure.  Simply search for objects that related to your modified component and start opening the component interfaces, if you get this error message then you should rebuild the CI's structure.

Simply open the CI and search for the Red 'X' over the Collection that needs to be rebuilt.

In the image above you can see that the COLL_JOB_USF needs to be fixed, to correct this delete the Collection and re-add it back to the CI.  Then you will need to re-label all the Properties to "PROP_" or "KEYPROP" and the Collection to "COLL_".  The Collection is of just one item so just key that manually, however the Properties can be a whole bunch of items.  In this example I had 125 to key, use the sql below to update all the properties to 'PROP_'.

UPDATE PSBCITEM SET BCITEMNAME = 'PROP_'||BCITEMNAME  WHERE   bcname = ':1' AND BCITEMPARENT = ':2';

:1 = CI_JOB_DATA

:2 = COLL_JOB_USF

Then add the 'KEY' to the KEY fields in the Collection.