Skip to Content
author's profile photo Former Member
Former Member

SAP HANA Error Code = 5098 - table does not exist(5519)

Applying SPS 7.40 - 12, SUM errors trying to lock "non-existent" tables. I believe these transparent tables are left over from our HANA Migration. The table is in HANA - schema.TABLES but, when trying to view the content, delete it or call the CHECK_TABLE_CONSISTENCY procedure we get errors.

The full error message is:

select * from SAPBWH."0BW:BIA:BI0_0Q00013902"

Could not execute 'select * from SAPBWH."0BW:BIA:BI0_0Q00013902"'

SAP DBTech JDBC: [7]: feature not supported: no result column: line 1 col 8 (at pos 7)

or

drop table SAPBWH."0BW:BIA:BI0_0Q00013902"

SAP DBTech JDBC: [2561]: distributed metadata error: Failed to get table location during table lock, TRANSACTION_ID=60 , UPDATE_TRANSACTION_ID=0 , Schema name=SAPBWH , Table name=0BW:BIA:BI0_0Q00013902 , error=table does not exist

Anyone seen this type of HANA behavior?

Cheers, Joe

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2015 at 04:46 PM

    Hi Joe

    Please review SAP Note 2133999 (Error: Could not execute 'GRANT ABAP_SYS_REPO TO _SYS_REPO during SUM DMO upgrade or migration to HANA) running repairTopology.py may resolve this error.

    Ruth

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2015 at 03:09 PM

    Hello Joe,

    we have nearly the same problem. Has SAP provided a solution?

    Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.