Skip to Content

Could not find table/view VIEW_COLUMNS in schema PUBLIC

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

view_columns.png (9.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 15, 2016 at 09:26 AM

    This was a HANA internal issue, that occure rarely but fixed in latests versions. Thank you for your help.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 01:57 AM

    Can you check whether there are other objects with the same name present in the system?

    Maybe a private synonym?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2016 at 07:34 AM

    HI,

    in my case it was an hana studio update issue ! 😊

    kind regards

    Ali

    Add comment
    10|10000 characters needed characters exceeded