abr
12
Issue with invalid or corrupted repository joins
Symptom:
The following error message is displayed:
[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46043] Internal error: No matching table for expr D_OPER_UNIT_XL.OPER_UNIT_SID, File .\Src\SQOSPSimplifyJoin.cpp, line 118.
Cause:
This symptom is associated with corrupted physical layer join relationships. The best way to test for a root cause is to isolate the dimention and fact combination that result on this error message.
Resolution:
Once the fact and dimension table relationship that is corrupted is isolated proceed to delete this physical join and the associated logical join. Once both physical and logical joins have been deleted proceed to recreate them and perform regression testing for your solution.
If you find this post useful please or Share our site!
Symptom:
The following error message is displayed:
[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46043] Internal error: No matching table for expr D_OPER_UNIT_XL.OPER_UNIT_SID, File .\Src\SQOSPSimplifyJoin.cpp, line 118.
