Skip to end of metadata
Go to start of metadata

Problem

The Jiwa BI model won't load and the re-load scripts report an error

One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will be cut by setting one or more tables as loosely coupled."

Solution

The error indicates that there are duplicate references in the data.  Usually this is found amongst the categories.  For example, check that all inventory category labels are unique. Check that the contents of each inventory category are unique.  E.g. 'Default category' for category 1 and 'Default category' for category 2 should be renamed to 'Default category 1' and 'Default category 2' respectively.  Repeat for debtors

In addition, make sure the category labels between debtors and inventory are unique.  'Category 1' in debtors and 'Category 1' in inventory will cause a loop.  Re-name them to 'Debtors Category 1' and 'Inventory Category 1'.  Or, as per the demo data 'Market' and 'Product Type'.