SAP HANA Restore single schema Displaying Error

[Former Member]

Recently We did an Upgrade of SAP Hana from PL04 to PL12. After that we were able to take full backups & single schema using Export command in Sap Hana Studio. We were able to test by restoring the full backup as well as single schema backup using Import command. But now for the past week we were not able

to restore the single schema from the backup, It fails with the Error attached along with this query.

Kindly help us in sorting the issue?

Error while Importing.txt.zip

[Former Member]

Also check this link

Work around for importing HANA delta LOB data fail | SCN

[Former Member]

Hi Suresh,

              I have already gone through the above link & tried to execute the query given in that forum. In some schemas its running & in some schemas in which I;m having problem its not running. It throws the sql syntax error.

Attached is the text document which contains the query which I executed & the result it gives.

Kindly help us in sorting the sql syntax error.

Thanks.

Query & Result.txt.zip

[Former Member]

Hi Raj,

I got the same error when refreshing a schema in Rev 69 PL3 and after we upgrade the database to Rev 82 it's resolved.

Also try taking the export and dump again and re import.

Thanks

Suresh