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.
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.
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:
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.
T1.”DOMNAME” = T2.”DOMNAME” AND
T1.”DOMVALUE_L” = T2.”DOMVALUE_L”
= ‘A’ AND
In the above steps, we have seen commonly occurring errors and how to solve it.
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)  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  Error: com.sap.hana.di.tabletype: Could not create the database object  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)  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  Warning: Worker 15 running the “com.sap.hana.di.tabletype” plugin has encountered an error while deploying 1 objects  Warning: com.sap.hana.di.calculationview: Database error 591: : connection is poisoned due to transaction errors; statement was rejected (1625)  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  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  Error: Database error 591: : connection is poisoned due to transaction errors; statement was rejected (1625) 
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.
Thank you very much !
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.
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.
Kindly delete the subaccount and create a new one.
thanks again. I created everything from scratch and now can build the tables.
After replacing the code in this blog, I'm still facing error for view DD07V . Please see attached screenshot.
Hello. We had the same issue with DD07V, you can try this code instead of existing one:
AS SELECT T1."DOMNAME",
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'
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?
Seems to have a lot more sytax error
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.
Thanks for your help. At least one error was addressed. ..
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.
Thanks for letting me know. Yep, the sap file still errors out but I was able to do the modeling.