on 01-06-2015 11:17 AM
Hello,
I have used IMPORT "SBODB1"."*" .... REPLACE SCHEMA SBODB2.
Then I deleted SBODB1. Everything worked fine.
Two month later, I tried to update from SBO 9.1 PL03 to PL04. The update failed.
I tried to restore the database manually with
IMPORT "SBODB2"."*" AS BINARY FROM '/usr/sap/NDB/HDB00/backup/data' and I get an error
SAP DBTech JDBC: [2048]: column store error: table import failed: [30151] Object not found in the import directory;object=SBODB1:ETL_Sen
The error is pointing to the old SCHEMA.
I searched in the export folders and found several finalize.sql and saved_configuration.cfg using the schema name SBODB1.
For example creating trigger to ODIM to the old SCHEMA.
[I tried to rename in the export folder all old SCHEMA to the new SCHEMA, only got another error message
SAP DBTech JDBC: [2048]: column store error: table import failed: [30151] Object not found in the import directory;object=SBODB2:OOCR_trackingen]
Now, I am not able to use the database in PL4. No restore. A new update failes, because the database in in an in the middle status.
I tried also to restore on another HANA box. Same. I created in SBO a new schema SBODB1 in hope, but this does not help either.
[all with HANA V74.3]
Thank you
Regards
Ingo Neufert
Hi Ingo,
Please review note 1981315 - HANA import fails with error "not found in the import directory".
Best regards,
Duncan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ingo,
There is also note 2051378 - Cannot import schemas into SAP HANA Revision 74 due to lob container reference error, a slightly different problem but it might be helpful.
Did you delete an object without using the cascade option? If you did that, it is possible that something was left behind and the import is failing because of the reference to the deleted object. Does the referenced object have a sql file? If you delete that sql file does the import succeed?
You should review note 2027458 - Collective Consulting Note for HANA-Related Topics of SAP Business One, version for SAP H... in case there is solution to your problem that I missed.
Best regards,
Duncan
Thank you all for your help.
I was not able to restore this database. We created this database again from scretch.
Next time I will check the Export, if there are wrong Schema properties.
The source database was upgraded from 9.0 PL01 (beta).... to 91.Pl04 perhaps the error is related to an older problem.
Thanks again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Additionally I changed all saved_configuration.cfg (6 files) to the new SCHEMA Name, but I get the same error.
Could not execute 'IMPORT "SBODB2"."*" AS BINARY FROM ...' in 978 ms 326 µs .
SAP DBTech JDBC: [2048]: column store error: table import failed: [30151] Object not found in the import directory;object=SBODB1:ETL_Sen
Hi,
Not sure attached SAP note is related to your issue:
2051378 - Cannot import schemas into SAP HANA Revision 74 due to lob
container reference error
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I do not think that the problem is related to the note.
For example the file ./import/OO/OOPR/finalize.sql shows:
CREATE TRIGGER "SBODB1"."OOPR_delete_trigger" AFTER DELETE ON "SBODB1"."OOPR" REFERENCING OLD ROW CROW FOR EACH ROW
BEGIN INSERT INTO "SBODB1"."OOPR_tracking" VALUES("SBODB1".ETL_S.NEXTVAL, 'D', Current_TimeStamp, :crow."OpprId"); END
This code creted from the backup of EXPORT "SBODB2"."*" should use the SBODB2 instead.
Regards
Ingo
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.