Product Information
Exporting Whitelisted Content and Importing it to SAP Web IDE (Cloud Foundry account)
Disclaimer: The information is not up to date.
With SAP Marketing Cloud you are able to import own SAP HANA Views by using the SAP Fiori App “Add Custom View”.
This blog post will tell you steps you need to carry out to build the HANA Calculation Views.
On opening the “Add Custom Views” application, you are informed that HANA views would be migrated to HANA 2.0. Post-migration, you can only import views that are modelled using HANA 2.0 Modeller ( SAP Web IDE)
In this blog post, you can see how to export all whitelisted content and how to import it to SAP Web IDE.
Part 1: Export HANA 2.0 Whitelisted Content
With SAP Marketing Cloud you can export all whitelisted content by using the Export All option in the Add Custom Views application (This option is available after upgrade to HANA 2.0 version).
Exporting will take some time as all whitelisted content along with their dependencies, all uploaded custom views, whitelisted Tables, CBO Tables are exported.
At the end of the process, MKT_Metadata.zip file is downloaded to your local system.
Part 2: Import the Whitelisted HANA Calculation Views with Dependencies in SAP Web IDE
For details on setting up the Cloud Foundry Trial Account using SAP Web IDE refer:
Exporting Whitelisted Content and Importing it to SAP Web IDE (Cloud Foundry account)
a. Import the downloaded zip into your workspace by choosing Import > File or Project.
The imported file looks like the below screenshot:
b. Right-click on the folder hdbtables.Choose Build > Build Selected Files to build downloaded hdbtables.
Once the build is successful, you can see the message below:
c. To build the downloaded HANA 2.0 views, right-click on the folder sap. Choose Build > Build Selected Files.
Once the build is successful, you can see the message below:
To create new custom views and import it back to SAP Marketing Cloud, refer
Hi Lekhak Patil
like your Blog Series! 🙂
I wanted to export the content from our test tenant. But do you know how long it might usually take to export the Whitelisted Content?
I tried to export but nothing happens. It only shows "Please wait while the content is being exported..." The system remains in that status for hours.
Do you think I have to open an incident for that?
BR Tobias
Nice... shortly after I asked you, the export was completed (after I waited the whole night :-D). So you can forget what I said 😐
Hi,
I have a problem when trying to build the hdbtables folder.
Below is the error log. Does anyone have an idea how to fix this?
.....
13:46:26 (HDB) Precompiling "src/sap/hana-app/prodreco/samples/CA_INTERACTION_INTEREST.hdbcalculationview"... ok (0s 2ms) Precompiling "src/sap/hana-app/prodreco/samples/CA_OFFER_BY_LOCATION_RUNTIME_PF.hdbcalculationview"... ok (0s 3ms) Precompiling "src/sap/hana-app/prodreco/internal/CA_D_CUAN_PRODUCT_VARIANT_TO_BASE_MAP_GENERIC.hdbcalculationview"... ok (0s 4ms) Precompiling "src/sap/hana-app/prodreco/samples/CA_TG_MEMBER_ID_IC_KEY_PF.hdbcalculationview"... ok (0s 2ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/topn/CA_GET_TOPN_CURRENT_CAT.hdbcalculationview"... ok (0s 6ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/topn/CA_DYN_TOP_N_CURRENT_CAT_GENERATE_MODEL.hdbcalculationview"... ok (0s 8ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/mostrecent/CA_RECO_GENERATE_RECENT_USER_ITEM.hdbcalculationview"... ok (0s 13ms) Precompiling "src/sap/hana-app/prodreco/algorithm/postfiltering/basketremoval/CA_FILTER_SOLD_ITEMS_INTERACTIONS.hdbcalculationview"... ok (0s 13ms)
13:46:26 (HDB) Precompiling "src/sap/hana-app/prodreco/algorithm/query/offers/CA_RECO_ELIGIBLE_OFFERS_LEADING_PRODUCT_CATEGORY.hdbcalculationview"... ok (0s 12ms) Precompiling "src/sap/hana-app/prodreco/algorithm/association/apriori/modelgeneration/CA_GENERATE_ASSOC_SQL_TRX_ITEM.hdbcalculationview"... ok (0s 14ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/topn/CA_GET_TOPN_PARENT_CAT.hdbcalculationview"... ok (0s 8ms) Error: Precompiling... failed [8212133] Error: Calculating dependencies... failed [8212108] Make failed (25 errors, 0 warnings): tried to deploy 292 files, undeploy 0 files, redeploy 0 dependent files Error: Making... failed [8211605] Error: Starting make in the container "RENAULTMKT_HDI_DB_1" with 292 files to deploy, 0 files to undeploy... failed [8214168]
13:46:26 (HDB) Deployment to container RENAULTMKT_HDI_DB_1 failed - error: HDI make failed [depId].
13:46:26 (HDB) Error: HDI make failed
13:46:26 (HDB) (6s 44ms)
13:46:26 (HDB) Deployment failed with exit code: 1
13:46:26 (HDB) STRUCTURED LOG CHECKSUM 108d0660be8bfe0b5fdbee8f24a07605250cf3954f3e36ab9b8a5f3caa0d1268
13:46:26 (HDB) STRUCTURED LOG SIZE1401584
13:46:26 (HDB) SENDING STRUCTURED LOG
13:46:26 (HDB) Ended because of error: Deployment failed with exit code: 1
13:46:26 (HDB) Build command failed : Please check the Problem view for more information.: hdi-build operation failed: Deployment failed with exit code: 1
13:46:26 (HDB) Build of /RenaultMKT/db failed due to The "task for hdb build" process finished with code 1.
Thanks,
Andrej
Hi Andrej,
are you trying to do the build for the hdbtables folder? Because it looks more like creating the Calculation Views.
Has the build of hdbtables before been successful?
BR Tobias
Hi,
Thank you for your information.
I tried to do you steps exactly but I received this error
....
10:44:46 AM (import) Import request sent
10:44:57 AM (import) Import request completed successfully
10:56:06 AM (Executor) The “task for hdb build” process started.
10:56:06 AM (Executor) Started the “task for hdb build” provision.
10:56:17 AM (Provision) Service provisioning for module: “/db”
10:56:17 AM (Provision) Could not create the ‘MKTMetadata-hdidb-S0018316080-work5mGFZedNQHVaPB7j’ instance of the ‘hana’ service type for the ‘hdi_db’ resource.
CF-ServiceBrokerRequestRejected(10001): Service broker error: Service broker hana-broker failed with: Can not create service instance
‘MKTMetadata-hdidb-S0018316080-work5mGFZedNQHVaPB7j’: There is no database available. Ensure that you have a database available in space ‘Dev’ within organization ‘3bc071cdtrial’.
10:56:17 AM (Provision) Provision fail since one of the provision tasks finished with error.
10:56:17 AM (Executor) The “task for hdb build” provision finished with an error: Provision failed. See console for more details.
10:56:17 AM (HDB) Build of /MKT_Metadata/db failed due to Provision failed. See console for more details..
....
When I read the error I think "of course there are no steps to create a database in this tutorial, but is it necessary? The WEB IDE in the Import step "create" the database?".
So I have a question:
Do we need a previous database creation, to build a table or views?
Thanks in advance,
Sael Guerra
Hi Sael,
Looks like the cloud foundry trial account is not configured properly.
In entitlements make sure that you added only two items:
1.SAP HANA Schemas and Containers Trial
2.Web ide trial
and nothing else.
For details on setting up the Cloud Foundry Trial Account using SAP Web IDE refer:
Exporting Whitelisted Content and Importing it to SAP Web IDE (Cloud Foundry account)
Regards,
Lekhak Patil
Hi Patil,
Thank you, I have the two you mentioned, and another as you can see in the following image:
Should I remove the other "entitlements"?.
Thanks in advance,
Sael Guerra
Yes
Hi Lekhak,
I followed the guide for setting up the trial account and
I only have one subaccount "trial" with the two entitlements
- SAP HANA Schemas & HDI Containers Trial
- SAP Web IDE for SAP HANA Development
However, I am facing the error "You have exceeded the total routes for your organization's quota" when trying to build the hdbtables. Any idea how to solve the error?
Thanks and best regards
Ilonka Plesnivy
I found the solution on
https://blogs.sap.com/2020/05/22/create-hana-2.0-custom-view-in-sap-web-ide-using-cloud-foundry-hana-trial-account-part-1/
and Halley Rozario feedback dated August 21,2020 to delete the plan hdi-shared in the service SAP HANA Schemas &HDI Containers (Entitlements).
By now also most of the steps described in the blog Trial Account setup are done automatically. So all the more valid input from Halley to delete the above entry.
Hi Ilonka,
Good to know that you have got the solution and it is working.
Kindly follow the below blog for setting up a trial account next time, if required.
https://blogs.sap.com/2020/10/21/cloud-foundry-hana-trial-account-setup-for-creating-hdi-custom-views-in-sap-web-ide/
Regards,
Lekhak Patil
Hi Lekhak,
that was the block I followed. However, by now most of the steps described in the block (create sub account, space, entitlements) are done automatically when initiating the trial. (But still great to have your block and the step-by-step description.) Above all, all entitlements are assigned. In my first attempt, I deleted them except the two mentioned in your block and got the above error when importing the export from SMC and running the built.
So I started from scratch again, meaning I deleted my trial account and initiated it anew. Now I got another error in the built and the solution was the one indicated above.
So maybe, you want to recheck and - if reproducible - update your block. (Tobias Schneider had a similar issue and also for him the solution worked as well.)
Best regards
Ilonka
I'm having the same issue ... still working to fix it .
Hi Filippo,
could you fix it in the end on your side?
So as it seems a need this hdi-container.
Hi Lekhak,
I followed your blog in a very detail manner, but still running in following issue: "You have exceeded the total routes for your organization's quota."
As it seems Ilonka Schmidt had the same issue, but on our side it does not solve the issue to delete the plan hdi-shared within Entitlements.
Any idea how to solve this issue?
I have deleted the whole subaccount already twice and built everything up from scratch.
Kind regards,
Daniel
Hi Daniel,
did you only delete the plan "HDI-shared" in SAP HANA Schemas & HDI Containers. You also have SAP HANA Schemas & HDI Containers Trial. There, you should keep it.
Best regards
Ilonka
Hi IIonka,
thank you for the update. Within trial I kept it and now it worked. As it seems someone on an overall/global layer deleted it, but there I do not have access.
But finally I have received "build ... completed successfully" and I can jump to next steps to create custom views.
Thank you for your help.
Kind regards,
Daniel
Hi Lekhak Patil ,
When i create a trial account and subaccount via Wizard, I am getting error while i try to build hdbtables folder like below;
3:46:26 (HDB) Ended because of error: Deployment failed with exit code: 1
13:46:26 (HDB) Build command failed : Please check the Problem view for more information.: hdi-build operation failed: Deployment failed with exit code: 1
13:46:26 (HDB) Build of /MKTMetadata/db failed due to The "task for hdb build" process finished with code
I got referenced to start my setup with trial account via CX Works link
Is it mandatory to apply the steps to create a custom calculation view via this link or enough with this link
Alternatively, when i create a subaccount to click on "Create Subaccount" and just enable only "SAP HANA Schemas & HDI Containers Trial" and "SAP Web IDE for SAP HANA Development" entitlements, it raiases an error for memory quota limit.
I am looking for your comments,
Thanks in advance,
Hi Lekhak Patil ,
great blog!
Unfortunately since SAP will not continue to support Web IDE, this recipe does not work anymore.
Can you create the same story with the Business Application Studio, too?
This would be of great help.
Regards
Christian
aaaah, that's why...
Indeed on part 1 of this blog on https://blogs.sap.com/2020/08/05/exporting-whitelisted-content-and-importing-it-to-sap-web-ide-cloud-foundry-account/# I had commented that I got stuck.
Then I read this comment, and then found https://sapui5.hana.ondemand.com/docs/topics/34bfb4531a974bf7be15f5937c7899d8.html#/topic/6bbad66475d040f39df6fbbaabe6f40f.html that indeed the web IDE isn't available anymore...
So I'd like to know how we can now build our custom views for SAP Marketing Cloud too!
Hi Joyca Vervinckt,
the only way I mange to do this now is using the Web IDE in HANA Express.
Regards
Christian
Thanks for that info Christian Holzer . I just checked how to get that HANA Express. But it seems like I need a Linux virtual machine for that :s
It took a while, but I was able to make it work with Business Application Studio.
In short, I followed this guide:
https://developers.sap.com/tutorials/hana-trial-advanced-analytics.html
but during Step 6, choose "Import" instead of "Clone from Git". Import the file that you export from SAP Marketing Cloud there.
Then continue with step 7, until 7.4
on step 7.5, don't deploy the top node immediately. For that step, the hint on https://www.sap.com/cxworks/article/453913143/how_to_model_custom_sap_hana_views_for_sap_marketing_cloud_in_your_browser is important: "build the hdbtables folder always before...".
There might be an error about a version range, then just click the update button and try again.
Now, after deploying the hdbtables, I don't seem to be able to deploy the rest of the sap objects though.
However, I am able to create new custom views (right click on a folder, select New File, then manually name the file something.hdbcalculationview), build the views, and download the .hdbcalculationview file which can be renamed to an .xml file and then imported in SMC. Only tried a very simple custom view now, but it worked. Now I can get started to build the more complex one that I actually need.
Hi Joyca Vervinckt,
correct. I use Oracle VirtualBox VM for this.
This works without any issue.