on 01-13-2015 5:47 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Raj,
I see you are using uper/lower case names - can you please run this query instead?
SELECT * FROM SYS.OBJECTS WHERE UPPER(OBJECT_NAME)='FISCAL_DATE'
Do you have create statement you used while you were creating this table?
Also - do you have some other system where you did same (for example quality or production which was not yet upgraded) - can you run that select statement there as well?
Tomas
Hello,
system restart should not delete any tables - that would be seen as defect...
is QA from "before upgrade"? or it was upgraded and table was gone...
can you share the what was returned on QA system? (schema, etc.)
last but not least - can you search SAP HANA log files for occurence of table name?
Tomas
Dev is upgraded and QA is not.
I can't see custom table in DEV. I have used the query to see the table in QA and below is the output
I can see the table in existing schema of QA System. Developer has created a custom table in a schema 'X' and this 'X' is replicating tables from ECC. If the replication is stopped does this deletes custom tables?
I am not sure how to check logs for specific table name, can you please guide me in this.
Regards,
Raj
Hello,
actually I was interested in schema name - but from the fact you made it black I assume it is not standard schema which might be intended for different purpose (like schema SYSTEM, etc.) - it is your own custom schema..
what about other tables in this schema - were ALL tables from this schema deleted? does this schema exist? or was the associated user deleted? reason is that if user was deleted with cascade option then it will also delete his schema and all tables there...
regarding replication - are you using SLT? it is some time since I was working with SLT but back then when you stopped replication it did not delete table - it only stopped updating it...
Tomas
Yes Thomas, we use SLT to replicate tables from ECC to HANA.
When a configuration is created using SLT it creates a schema name and user with schema name in HANA.
Developer has created custom table in this schema.
Does deleting the user and schema deletes the custom tables too? these custom tables are created on Disk right?
Correct me If I am wrong.
Regards,
Raj
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.