Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute.

Received Response
424
Views
2
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead

Hi , I am using OBIEE 12.2.1.2.0

I got this error when i try to make an analysis in OBIEE,

I went through my RPD all the connections are good, I am able to view data from physical layer,

i set  PERF_PREFER_INTERNAL_STITCH_JOIN to Yes

Still the same message.

Has anyone encountered the same issue?

Kr, Matija

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Does the user in the connection pool have access to the table in question? Can you connect directly to the data source and run the same query that is run in OBIEE? If you can, does it run without an error?

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    Hi, sry for raising this as a topic,  it was my mistake Disabled was ticked on my business model.

    Kr, Matija