HI everyone.
I have a problem when I try to update my rows from my Admin Tool.
The error says that there is a error executing SQL instruction and ORA-00942 the table or view does not exist.
Has anyone experienced these problems ? Please help.
If the user is not the owner, then as Gianni mentioned, have you checked the fully qualified table name in connection pool setting? Or if not, are you using public synonyms?
I never talked about privileges, but fully qualified name which is: schema.tablename vs tablename (without the schema).
An option in the connection pool which by default isn't checked (it's a checkbox) and you must enable to make it works.
That's a simple SQL thing: you can't expect the database scans all the schemas you have some privileges to find out if by mistake there is an object with a matching name, also because ... what happen if same name in 2 schemas?
That's why there is that checkbox which, IMHO, must always be enabled because it doesn't cost anything but prevent so many issues ....
Gianni Ceresa
Thank you for your help again.
I already checked the checkbox "checkbox to use fully qualified names" and I still have the same error, BUT as I said befeore, the user that I am using is not the owner of the table so, if I connect to source through sqlplus with this user I have to use schema.table_name to be able to see the data, so I created a synonym for a table to validate if it works and it does. BUT I think that it is not the best solution. Do I have to create synosyms for every table when I use another user who is not owner of table??
Hi,
Can you try giving the "SELECT" privilege to user used in connection pool ?
GRANT SELECT ON owner.table TO user;
3057520 wrote:so I created a synonym for a table to validate if it works and it does. BUT I think that it is not the best solution. Do I have to create synosyms for every table when I use another user who is not owner of table??
Why did you create a synonym?
It's useless, when checking the "fully qualified name" checkbox OBIEE uses the schema.table_name syntax in all the queries, so not a problem if your connection pool uses a different user, it will just works.
Get rid of the synonym, do not start having weird things like that in your database or you will end up with a messy DB you will not manage to keep clean and with errors because using the wrong object at some point.
Just to know: what is your DB? Oracle but which version?
Silly question, did you confirm that the db you are connecting to, using sqlplus and the one in the admin tool connection pool are the same?
Thank you Gianni Ceresa.
I created a new RPD and checked the "fully qualified name" checkbox and finally it works perfectly without synonyms.
FYI, my db source is Oracle 11g (11.2.0.4).
THANK YOU!! USEFUL SUPPORT.
Best regards,
Hello Oracle Analytics Community, We are investigating a dashboard compatibility issue between Oracle Analytics Server (OAS) 7.6 and OAS 7.0. Some dashboards originally created in Oracle BI 12c can be opened in OAS 7.6 but fail to open after being archived and imported into OAS 7.0. During our investigation, we found the…
Hi all, We’re running into an issue with an on-premises Oracle Analytics Server 2026 integrated with Active Directory and hoping someone has seen this or knows if a patch is available. Environment: Oracle Analytics Server 2026 (on-premises) WebLogic 14.1.2.0.0, JDK 21, Oracle Linux DB-backed catalog (Oracle DB, BIPLATFORM…
We have a requirement Creating a Bar graph using Cost Center Tree hierarchy as prompt/filter. Created a Bar Graph using Cost Center Tree Hierarchy as a prompt. When I'm selecting values through selection steps from Cost Center Tree Hierarchy, the Bar Graph not refreshing as the selected values are not passing to Graph…
I have 2 tabs on the workbook that use the same dataset. I would rather not use 2 different datasets. Can I code an expression filter or something to remove those records?
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4