Skip to Content
avatar image
Former Member

Unable to find custom tables in HANA after upgrade

Hi All,

we have created custom tables in HANA Studio and after upgrade we don't see these tables in HANA.

Does custom tables get's deleted after upgrade or this is because of System restart?

Is there any guide or blog post which details the behaviour of custom tables in HANA.

Regards,

Raj

Message was edited by: Tom Flanagan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 14, 2015 at 05:26 AM

    Hello Raj,

    Have you taken a consistent Data Area and Log Area Backup prior to your upgrade but after the creation of Custom Tables. If so then I think you refresh your Upgraded DB with that old backup.

    Because in Hana DB, you can not recover a Target DB of lower version w.r.t a backup of higher version but you can recover a Target DB of higher version with a backup of lower version...

    Best Regards,

    Sourav Brahma

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Sourav,

      Thanks for your reply.

      yes, we do have backups of both data and log files.

      I would like to know why/how does these custom tables get deleted[I am unsure whether restart of HANA or Upgrading HANA deletes them]

      Regards,

      Raj

  • Jan 14, 2015 at 05:17 PM

    Hello,

    it is not normal that customer tables get deleted (at least to my knowledge ;-D) as part of database upgrade...

    can you maybe provide more details? what was revision before upgrade, what revision you upgraded to, what tables are we talking about - which schema was used, were these tables manually created by some user or they belong to BW or ERP schema, etc...

    are you absolutely sure they were deleted? maybe you just do not have access anymore...

    Tomas

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      I do not know what exactly happened but yes - deleting schema will delete also tables in that schema (as you cannot have tables without schema) and deleting user with cascade option will also delete his schema - so if this happened then you might have your explanation...

      Tomas