Bug in HANA Schema Export using the Web-based Development Workbench?

[gregorw]

Hello SAP HANA Experts,

I'm currently following the tutorial Continuous Integration (CI) Best Practices with SAP: SAP HANA Extended Application Services (XS), cl... to setup CI for the SAP Event Registration app. To have a real integration test I would like to export the production DB schema SITREG and import it into the QA HANA DB. In the past I did that already manually by using the Catalog view of the Web-based Development Workbench. In the past I was able to export the complete schema in one go. But with the current Versions of HANA I have access to:

1.00.122.04.1478575636 (on HCP Trial)
1.00.122.02.1473345179 (on HCP Factory)
2.00.000.00.1479874437 (HANA Express Edition)

Only the first found object ist exported. I've debugged the behaviour by starting in the net.xsjs file which I call in the browser using:

/sap/hana/ide/common/remote/server/net.xsjs?action=exportObject&schemaName=SITREG&objectName=*&includingData=true&includingDependencies=true&parallelThreads=2&columnFormat=BINARY&fileName=SITREG

This xsjs script is calling /sap/hana/ide/common/plugin/catalogsystem/server/common/remote.xsjslib and there the checkObjectExport method. In this method the existence of objects to be exported is checked. But unfortunately instead of the objectName * that was submitted by the user only the first result is returned.

When I replace the line:

result.objectExport = "\"" + sSchemaName + "\".\"" + sObjectName + "\"";

by

result.objectExport = "\"" + sSchemaName + "\".\"" + inputObject.objectName + "\"";

the problem is fixed. And I get a full export.

Perhaps others can confirm this behaviour and I will file a bug using SAP Support.

Best regards
Gregor

[pfefferf]

Hi Gegor,

had a look on the issue you described and debugged the coding too.

I can confirm the same behavior you described and from my point of view this is a bug. The coding in function checkObjectExport should only check if the object to be exported (either a single one or the whole content of a schema) exists. But in case a full export should be done the first found object name is returned instead of the "*". So only that object is exported and not all. I would open a ticket for that.

The catalog export functionality with the latest SAP HANA Tools for Eclipse is not affected.

Regards,
Florian

[gregorw]

Hi Florian,

thank you for your check. Today I've filed the issue 144719 / 2017. Let's hope it get's fixed soon.

Best regards
Gregor