Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
DAC (OBIEE) Execution plan start issue with Indices
Chandruch
Rank 1 - Community Starter
Hi All,
I am new to DAC environment, when i start execution plan it is getting failed with the following error.
Error while loading nodes.
Error while loading nodes.com.siebel.etl.database.DataSourceNotFoundException:
Error while executing :SELECT COUNT(*) AS COUNT_RESULT FROM USER_INDEXES WHERE INDEX_NAME = 'WC_LOYMEMBER_DS_U1'
However, the same SQL successfully running on target database(warehouse) when i run it manually, it sounds like the query is not running against the target database,
not sure how to fix this issue, Appreciate any help/suggestions to fix this issue.
Thanks
CC
0