Stored procedure is not installed for datastore [x] - SAP HANA

To troubleshoot the installation error "Stored procedure is not installed for datastore [x]" message please follow the steps below one by one.

Step 1) Check procedure installation - manual

If you have done a manual installation of the stored procedure your SBO_SP_PostTransactionNotice should contain the BOY_CLOUD modification:

If it does not, please follow the steps in: https://boyumsolutions.zendesk.com/knowledge/articles/27843496706333/

Step 2) Check procedure installation - add-on installation

If you installed the Cloud Apps add-on your procedure should contain the add-on modification:

If it does not, please run the add-on in the database or follow the steps in: https://boyumsolutions.zendesk.com/knowledge/articles/27843496706333/ for a manual installation.

Step 3) Do not install using both add-on and manually

If your stored procedure contains both the manually installed code and the add-on code:

Then please remove the manually installed code so that only the add-on code is left (The code above).

Step 4) Make sure "Enable Transaction Notification" is enabled in the client

Step 5) Make sure you have no entries in CTNS

The CTNS table contains a black list of some SBO events that are not sent to the transaction notification procedures, and it could explain why some events are not sent to Cloud Apps. More information about it: https://boyumsolutions.zendesk.com/knowledge/articles/25925299275037/.

Step 6) Manual steps to verify that stored procedure code is working

Boyum Cloud Apps verifies that the procedure is working by adding a record to a specific table. This is reacted to by the stored procedure modification and it writes a record to our config table. You can test this manually by doing the following:

1) Open the user-defined table BOY_CLOUD_NOTI_TYPE using the SAP client:

Insert the record BOYCLOUD_TEST_STOREDPROCEDURE as shown in the screenshot. Press update.
If the modification is working the "BOYCLOUD_TEST_STOREDPROCEDURE" should get removed immediately after you press update.

If it is not removed please double-check the previous steps (procedure installation). If the record is removed open BOY_CLOUD_CONFIG and verify that you have a record called "SP_PTN".

The "SP_PTN" record is what the installation step is looking for when checking that the procedure is installed correctly. If the record SP_PTN exists please continue with the installation at app.boyumcloud.com.