Trouble Shooting - [39008]Logical dimension table TABLE_X has a source TABLE_X_SOURCE that does not join to any fact source.

1. 在UI上发现错误错误：

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14026] Unable to navigate requested expression: xxxxxxx. Please fix the metadata consistency warnings. (HY000)

 

2. 检查Consistency Warnings

发现有个错误时有时无

Waring: [39008]Logical dimension table TABLE_X has a source TABLE_X_SOURCE that does not join to any fact source.

查网络，发现网络上的方法不能解决问题。后来发现Fact table的主键设置错误，更改后解决问题。

 

3. 解决方法

结合别人和自己的发现，应该检查以下几点 (因为部分资料来自老外，所以都以英文为准)：

1) a physical join between the Logical Table Soources (LTS)
exist
2) a business model join exists between the logical tables
3) most over looked, your aggregation content on the content tab
of theose LTSs must be properly set, both in the Dimension table
and the fact table. This is the real important piece, and the
most overlooked. It is what the BI Server really uses to
determine granulairty of tables sources. if there are no
matches, then you will get that error.

4) If above steps can not help, pls check your Fact table's key. Make sure you have set the correct key. (Either correct key or no key is ok.)

 

4. 总结

这个错误会有很多原因。而因为key设错这个原因更为隐秘，因为设错key不会100%出错。只会偶尔出错，临时的解决方法可以用重启BI Server。