can't import schema

[Former Member]

Dears,

i can't import schema with rename option it is shows below error :

SAP DBTech JDBC: [2048]: column store error: table import failed:  [30151] Object not found in the import directory;object=schema_name :OPRC_trackingen

[Former Member · Accepted solution]

Dear ,

- locate to your exported schema directory (under which should have 2 folders export and index)

- search for files with name finalize.sql (33 files in all)

find -type f -name 'final*'

- delete files with name finalize.sql

find -type f -name 'final*' -delete

- delete below saved_configuration.cfg (33 files in all) under index/ name the database

rm ./OO/OOCR/saved_configuration.cfg

rm ./OP/OPRC/saved_configuration.cfg

rm ./MD/MDR1/saved_configuration.cfg

rm ./BG/BGT3/saved_configuration.cfg

rm ./BG/BGT1/saved_configuration.cfg

rm ./OM/OMDR/saved_configuration.cfg

rm ./OD/ODIM/saved_configuration.cfg

rm ./JD/JDT1/saved_configuration.cfg

rm ./OC/OCR1/saved_configuration.cfg

rm ./OI/OITM/saved_configuration.cfg

rm ./IN/INV1/saved_configuration.cfg

rm ./IN/INV12/saved_configuration.cfg

rm ./RI/RIN12/saved_configuration.cfg

rm ./RI/RIN1/saved_configuration.cfg

rm ./OO/OOPR/saved_configuration.cfg

rm ./OP/OPR1/saved_configuration.cfg

rm ./OP/OPRJ/saved_configuration.cfg

rm ./OA/OADM/saved_configuration.cfg

rm ./OA/OACT/saved_configuration.cfg

rm ./OR/ORIN/saved_configuration.cfg

rm ./OF/OFPR/saved_configuration.cfg

rm ./OW/OWHS/saved_configuration.cfg

rm ./OC/OCRD/saved_configuration.cfg

rm ./OC/OCSI/saved_configuration.cfg

rm ./OC/OCSV/saved_configuration.cfg

rm ./CS/CSV1/saved_configuration.cfg

rm ./CS/CSI12/saved_configuration.cfg

rm ./CS/CSV12/saved_configuration.cfg

rm ./CS/CSI1/saved_configuration.cfg

rm ./OB/OBPL/saved_configuration.cfg

rm ./OI/OINV/saved_configuration.cfg

rm ./CI/CINF/saved_configuration.cfg

rm ./OL/OLCT/saved_configuration.cfg

- import schema again, it should be successful

- initialize the schema in Admin Console then

Kind regards,

Mohammad Homsi

[former_member349215]

This message was moderated.

[Former Member]

Hi,

     I tried the procedure above but still got the same error regarding the import.

Regards,

Lester

[Former Member]

Dear lester ,

Kindly can show me the exact error

Best Regards,

Homsi

[Former Member]

Hi Homsi,

Here is the exact error after doing the provided procedure.

SAP DBTech JDBC: [2048]: column store error: table import failed:  [30151] Object not found in the import directory;object=schema_name :OPRC_trackingen

Regards,

Lester

[jacobo_agami]

Hello we had the same issue and we have been able to solve it following the note 2114106

http://service.sap.com/sap/support/notes/2114106

You just need to run the attached script

Regards

Jacobo

[jacobo_agami]

Hello

Iam facing the same issue, have you been able to solve it?

Regards

Jacobo

[Former Member]

Dear ,

- locate to your exported schema directory (under which should have 2 folders export and index)

- search for files with name finalize.sql (33 files in all)

find -type f -name 'final*'

- delete files with name finalize.sql

find -type f -name 'final*' -delete

- delete below saved_configuration.cfg (33 files in all) under index/ name the database

rm ./OO/OOCR/saved_configuration.cfg

rm ./OP/OPRC/saved_configuration.cfg

rm ./MD/MDR1/saved_configuration.cfg

rm ./BG/BGT3/saved_configuration.cfg

rm ./BG/BGT1/saved_configuration.cfg

rm ./OM/OMDR/saved_configuration.cfg

rm ./OD/ODIM/saved_configuration.cfg

rm ./JD/JDT1/saved_configuration.cfg

rm ./OC/OCR1/saved_configuration.cfg

rm ./OI/OITM/saved_configuration.cfg

rm ./IN/INV1/saved_configuration.cfg

rm ./IN/INV12/saved_configuration.cfg

rm ./RI/RIN12/saved_configuration.cfg

rm ./RI/RIN1/saved_configuration.cfg

rm ./OO/OOPR/saved_configuration.cfg

rm ./OP/OPR1/saved_configuration.cfg

rm ./OP/OPRJ/saved_configuration.cfg

rm ./OA/OADM/saved_configuration.cfg

rm ./OA/OACT/saved_configuration.cfg

rm ./OR/ORIN/saved_configuration.cfg

rm ./OF/OFPR/saved_configuration.cfg

rm ./OW/OWHS/saved_configuration.cfg

rm ./OC/OCRD/saved_configuration.cfg

rm ./OC/OCSI/saved_configuration.cfg

rm ./OC/OCSV/saved_configuration.cfg

rm ./CS/CSV1/saved_configuration.cfg

rm ./CS/CSI12/saved_configuration.cfg

rm ./CS/CSV12/saved_configuration.cfg

rm ./CS/CSI1/saved_configuration.cfg

rm ./OB/OBPL/saved_configuration.cfg

rm ./OI/OINV/saved_configuration.cfg

rm ./CI/CINF/saved_configuration.cfg

rm ./OL/OLCT/saved_configuration.cfg

- import schema again, it should be successful

- initialize the schema in Admin Console then

Kind regards,

Mohammad Homsi

[lbreddemann]

So? Looks like the object is missing from the import directory although it is supposed to be there.

You may want to check what files are available.

- Lars