Skip to Content
Product Information
Author's profile photo Lekhak Patil

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.

 

Assigned tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo GOVINDA PARATE
      GOVINDA PARATE

      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.

      Author's profile photo Patrick Thaler
      Patrick Thaler

      Thank you very much ! 

      Author's profile photo Daniela Arndt
      Daniela Arndt

      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.

       

       

      Author's profile photo Lekhak Patil
      Lekhak Patil
      Blog Post Author

      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

      Author's profile photo Daniela Arndt
      Daniela Arndt

      Many thanks for the reply. Unfortunately it doesn't resolve the problem. The account usage was already extended before and the password in the cloud foundry is set.

      Best regards,

      Daniela Arndt

      Author's profile photo Lekhak Patil
      Lekhak Patil
      Blog Post Author

      Kindly delete the subaccount and create a new one.

      Author's profile photo Daniela Arndt
      Daniela Arndt

      Hi Lekhak,

      thanks again. I created everything from scratch and now can build the tables.

      Author's profile photo Shu Wang
      Shu Wang

      After replacing the code in this blog, I'm still facing error for view DD07V . Please see attached screenshot.

      Author's profile photo Ekaterina Ponorets
      Ekaterina Ponorets

      Hello. We had the same issue with DD07V, you can try this code instead of existing one:

      VIEW "hdbtables::DD07V"
      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'
      ;

      Author's profile photo Shu Wang
      Shu Wang

      Thanks a lot. after replacing the files, the first build was successful. However, I encoutnered error during the sap build.Did you facing the same issue previously?

       

      Author's profile photo Shu Wang
      Shu Wang

      Seems to have a lot more sytax error

      Author's profile photo Ekaterina Ponorets
      Ekaterina Ponorets

      WebIDE_errors

      WebIDE_errors

      Author's profile photo Ekaterina Ponorets
      Ekaterina Ponorets

      It was the first error we have faced during hdbtables bulding. We fixed it with the help of SAP Global Support. But there are more errors we have not fixed yet.

      Author's profile photo Shu Wang
      Shu Wang

      Thanks for your help. At least one error was addressed. ..

      Author's profile photo Ekaterina Ponorets
      Ekaterina Ponorets

      By the way, you don't have to spend time fixing all the errors. it is enough to build the database objects that you plan to use for development.

      Author's profile photo Shu Wang
      Shu Wang

      Thanks for letting me know. Yep, the sap file still errors out but I was able to do the modeling.