Exalytics: Running "Summary Advisor" In Administration Tool Fails With 'Check Database Specific Features Table. Must Be Able To Push At Least A Single Table Reference To A Remote Database'

Asset ID:	1-72-1663518.1
Update Date:	2016-10-13
Keywords:

Solution Type Problem Resolution Sure

Solution 1663518.1 : Exalytics: Running "Summary Advisor" In Administration Tool Fails With 'Check Database Specific Features Table. Must Be Able To Push At Least A Single Table Reference To A Remote Database'

Applies to:

Oracle Exalytics Software - Version 1.0.0.0.0 and later
Exalytics In-Memory Machine X3-4 - Version All Versions and later
Exalytics In-Memory Machine X2-4 - Version All Versions and later
Business Intelligence Server Administrator - Version 11.1.1.6.2 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.2 and later
Information in this document applies to any platform.

Symptoms

You have intergrated Times Ten 11.2.2.4.5 with OBIEE 11.1.1.6.2. However, while executing "Summary Advisor" it fails with the below error:

[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 42016] Check database specific features table. Must be able to push at least a single table reference to a remote database
[nQSError: 98009]Execution of Summary statistics data retrieval query failed:

Err

Cause

Cause of this issue has been identified and verified as

<Bug 18597346> - EXALYTICS:ERROR WHEN EXECUTE "SUMMARY ADVISOR" IN ADMIN TOOL [NQSERROR: 42016]

Solution

To fix this issue, Increase the value of MAX_TABLES_IN_SELECT for Tracking database in the Features tab in repository (RPD).

References

<BUG:18597346> - EXALYTICS:ERROR WHEN EXECUTE "SUMMARY ADVISOR" IN ADMIN TOOL [NQSERROR: 42016]

Attachments

This solution has no attachment