on 10-21-2015 11:47 AM
Hello,
For no particular reason I cannot access anymore the public synonym 'VIEW_COLUMNS' with any user. (even with SYSTEM)
All other synonyms remain accessible.
Here the errors I get:
select * from PUBLIC.VIEW_COLUMNS;
11:37:17 (SQL Editor) Could not execute 'select * from PUBLIC.VIEW_COLUMNS' Error: (dberror) 259 - invalid table name: Could not find table/view VIEW_COLUMNS in schema PUBLIC: line 1 col 22 (at pos 22)
But the following queries return appropriate values:
select * from SYS.VIEW_COLUMNS; -- is Ok
select * from "PUBLIC"."SYNONYMS" where synonym_name = 'VIEW_COLUMNS';
Others synonyms are still accessible:
select * from PUBLIC.VIEWS; -- is OK
select * from PUBLIC.USERS; -- is OK
When trying to recreate the synonym :
CREATE PUBLIC SYNONYM VIEW_COLUMNS FOR "SYS"."VIEW_COLUMNS"
11:49:39 (SQL Editor) Could not execute 'CREATE PUBLIC SYNONYM VIEW_COLUMNS FOR "SYS"."VIEW_COLUMNS"' Error: (dberror) 330 - cannot use duplicate synonym name: VIEW_COLUMNS: line 1 col 22 (at pos 22)
I cannot access the admin console from hana studio because of this error too.
I deleted all custom config files and restart but the error persists.
What is happening?!
Thank you
This was a HANA internal issue, that occure rarely but fixed in latests versions. Thank you for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
in my case it was an hana studio update issue !
kind regards
Ali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you check whether there are other objects with the same name present in the system?
Maybe a private synonym?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.