Skip to Content
Product Information

General problems and solutions in SAP Web IDE with respect to HDI views

In this blog post, it is explained how to solve common errors while setting up SAP Web IDE in Cloud Foundry HANA Trial Account of SAP Cloud Platform.

1. Can’t open custom view in the graphical editor.

If the XML is not formatted with line breaks, the above error appears.

Solution:

a. Open the XML of the custom view in the code editor.

b. Copy the contents.

c. Format it with line breaks using the XML formatter.

d. Add it back to the code editor.

e. Save and open the custom view in the Graphical editor.

 

2. Build option doesn’t appear.

This error may occur due to two issues.

a. Web IDE is not configured for the HDI DB project. Follow the steps mentioned in the link below to resolve the issue.

Set up the Cloud Foundry Trial Account for using SAP Web IDE

b. Even though SAP Web IDE is configured for HDI DB project, the project is not recognized.

Exported whitelisted content currently supports the cloud foundry version. You may be using a different version of SAP Web IDE.

Solution:

a.Choose File > New > Project from Template.

b. Select SAP HANA Database Application.

Provide name and complete the wizard options with default values.

c. The SAP HANA DB project that you created will appear as shown below:

d. Right-click on .hdinmaspace and choose Open Code Editor.

 

If .hdinamespace is not visible, click on View > Show Hidden Files.

 

e.Delete the value set for the name like shown below:

Build .hdinamespace file before building other files.

 

f. Copy hdbtables and sap folder from mkt_metadata (File exported from SAP Marketing system) to the src folder.

g. Build hdbtables and sap folder separately, by right-clicking on the folders and choosing Build.

h. If hdbtables build fails and looks as shown below:

 

Then expand folder hdbtables, goto M_DIME_DIMENSION table.

Right-click on M_TIME_DIMENSION and choose Open Code Editor.

Delete below keywords:

CS_LONGDATE

CS_DAYDATE

CS_TINY

CS_FIXED

The file will look like as shown below:

Now build the hdbtables and sap folder seperately.

 

In the above steps, we have seen commonly occurring errors and how to solve it.

In case you have further issues in creating custom views using SAP Web IDE, we recommend you to raise a ticket to the component CEC-MKT-EXT.

 

2 Comments
You must be Logged on to comment or reply to a post.
  • Hi Lekhak,

    Thanks for the blog it was really useful to do the initial setup and I was able to build the hdbtable folder. However I’m facing issue while I’m trying to build the SAP folder. Below is the error which system is showing me:

    Database error 591: : connection is poisoned due to transaction errors; statement was rejected (1625) [8201003] at “src/sap/hana-app/cuan/custom_seg/PR_READ_MODEL_DEF_tabletype_ot_model.hdbtabletype” (0:0) Warning: Worker 3 running the “com.sap.hana.di.tabletype” plugin has encountered an error while deploying 1 objects [8212030] Error: com.sap.hana.di.tabletype: Could not create the database object [8250005] at “src/sap/hana-app/cuan/custom_seg/PR_MODEL_DEF_DESERIALIZE_tabletype_ot_model_def.hdbtabletype” (1:6) Error: com.sap.hana.di.tabletype: Database error 7: : feature not supported: cannot create type sap.hana-app.cuan.custom_seg::PR_MODEL_DEF_DESERIALIZE/tabletype/ot_model_def with properties: line 1 col 13 (at pos 12) [8201003] at “src/sap/hana-app/cuan/custom_seg/PR_MODEL_DEF_DESERIALIZE_tabletype_ot_model_def.hdbtabletype” (1:6) Warning: Worker 11 running the “com.sap.hana.di.tabletype” plugin has encountered an error while deploying 1 objects [8212030] Warning: Worker 15 running the “com.sap.hana.di.tabletype” plugin has encountered an error while deploying 1 objects [8212030] Warning: com.sap.hana.di.calculationview: Database error 591: : connection is poisoned due to transaction errors; statement was rejected (1625) [8201003] at “src/sap/hana-app/cuan/custom_seg/gen/c_ic_contact_fcet/CA_C_IC_CONTACT_FCET.hdbcalculationview” (0:0) Error: Worker 7 running the “com.sap.hana.di.procedure” plugin has encountered an error while deploying 1 objects [8212030] Error: The build plugin operation “virtual void hdi::kernel::buildplugin::SharedLibraryBuildPlugin::deploy(const ltt::vector<ltt::smartptr_handle<hdi::buildplugin::CompileUnit> >&, hdi::buildplugin::BuildPluginEnvironmentIf&) const” has failed for the “com.sap.hana.di.procedure” build plugin [8210505] Error: Database error 591: : connection is poisoned due to transaction errors; statement was rejected (1625) [8201003]

     

    Also I tried to do the Build for individual views but it is given me error that the tables used in the view are not present in the desired path even though the hdbtables build was successful.