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.

 

3. DD07V build is failing.

Copy paste below code inside DD07v and build.

VIEW “hdbtables::DD07V”
(“DOMNAME”,
“VALPOS”,
“DDLANGUAGE”,
“DOMVALUE_L”,
“DOMVALUE_H”,
“DDTEXT”,
“DOMVAL_LD”,
“DOMVAL_HD”,
“APPVAL”)
AS SELECT
T1.”DOMNAME”,
T1.”VALPOS”,
T2.”DDLANGUAGE”,
T1.”DOMVALUE_L”,
T1.”DOMVALUE_H”,
T2.”DDTEXT”,
T2.”DOMVAL_LD”,
T2.”DOMVAL_HD”,
T1.”APPVAL”
FROM
“hdbtables::DD07L” T1,
“hdbtables::DD07T” T2
WHERE
T1.”DOMNAME” = T2.”DOMNAME” AND
T1.”DOMVALUE_L” = T2.”DOMVALUE_L”
AND
T1.”AS4LOCAL”
= ‘A’ AND
T2.”AS4LOCAL”
= ‘A’
;

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.

 

7 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.

  • Hello Lekhak,

    thanks for all blogs related to this topic. It really helps a lot. Unfortunately I’m now stuck with an error during the build of the tables:

    Could not create the ‘MKTMetadata’ instance of the ‘hana’ service type for the ‘hdi_db’ resource. CF-NotAuthorized(10003): You are not authorized to perform the requested action

    Provision fail since one of the provision tasks finished with error.

    After the MKTMetadata there are some more information like my S-User and so but I think this is not relevant for this error (at least I hope).

    I rechecked all blogs over and over again and tried also to find something with the error but all suggestions I tried / checked and they do not help. So I checked the entitlements, services and so on.

    I hope you can help me with that.

     

     

    • Hi Arndt,

       

      This looks like the sub-account is expired and the new sub-account has an authorization problem.
      In settings try to set the user name and password of cloud foundry it should solve.
      Kindly let us know if the solution is not working.

       

      Regards,

      Lekhak Patil