Thursday, March 21, 2013

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


We get the below Error Message in a Parent Child Settings. 
BI consistency check will be fine. But in the Analysis, when we select the hierarchy, the report would throw this: 


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



This is mainly because Parent Child settings in the hierarchy can't be set up properly when 
the BI Server is Online. 

TO FIX

  •          Switch the server to OFFLINE mode 
  •          Implement the Parent - Child settings 
  •  Save and switch the RPD to ONLINE mode. 


This would fix the issue.  :)

No comments:

Post a Comment