Skip to Content
-1

Import data from development space to PROD space

Nov 10, 2017 at 03:54 AM

46

avatar image
Former Member

I developed a multi-module application in HANA 2.0 XSA with three modules hdb module, sapui5 module and node.js module in the "development" space. Then build the project to create the MTAR file and exported it to the local system directory. I deployed the MTAR into the "PROD" space successfully which created all the above mentioned three modules. In the SAP database explorer all the tables of the hdb module contain empty content. I exported the catalog objects from development space as CSV file. When I import the catalog objects into PROD hdb module I get the following error which can be seen from the attached screenshots. Kindly have a check and help on this how to import the data from development space to PROD space which will be very important to the project.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Nov 10, 2017 at 05:32 AM
0

As the error message indicates. Your user is missing the IMPORT system privilege to be able to do the import. In addition your user also needs the Insert privilege on the tables.

Please make sure that your user has the necessary privileges.

Regards,
Florian

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Can you please in detail how it can be done in step-by-step process?

0

Have you already read the documentation about security and privileges?

If not please read it, because there is everything described you need.

If yes and you still have issues, please post the issues you have.

0
Former Member

Could you please attach and send me the documentation about security and privileges.

0

Official HANA documentation - Using your search engine skills would provide the same information.

1