[nQSError: 38107] Not all four columns are defined for closure table

Problem: [nQSError: 38107] Not all four columns are defined for closure table

In OBIEE 11g, while dealing with Parent-Child Hierarchy, you can get the error saying,
[nQSError: 38107] Not all four columns are defined for closure table 'D51 Sales Rep Parent Child'. (HY000)

The BI Consistency Check will be fine. But when you are going to test your results in Analysis, the error report would through this error.
[nQSError: 38107] Not all four columns are defined for closure table ....

The root cause of this error is Parent-Child setting in hierarchy can't be set up properly while modifying repository in online mode.

Solution: 

• To fix this issue, make your all BI Services down.
• Open your repository in offline mode.
• Set the Parent-Child settings properly.
• Save and take your repository online.
• Test your result now.

Happy BI. ;-)