WDF 2000005 - Unable to upgrade the SAP Intercompany between PL27 and PL34 to Walldorf Intercompany on SAP HANA

WDF 2000005 - Unable to upgrade the SAP Intercompany between PL27 and PL34 to Walldorf Intercompany on SAP HANA

Symptom

While upgrading the SAP integration solutions PL27 (or up to PL34) to Walldorf Intercompany and IntegrationHub version 41 (or up to the latest version) for HANA, the following error occurs:

IntegrationSoluitons Add-on failed to update the database.


OR

Error: Error Code:-1116 Error Description :[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;328 invalid name of function or procedure: no procedure with name SBO_SP_TRANSACTIONNOTIFICATION found: line 1 col 35 (at pos 34)

OR

User :manager, Method :UpdateSAPNotificationProcedureForHana, Error Message :Specified argument was out of the range of valid values.


Reproducing the issue
Prerequisites:

You are using the SAP integration solutions PL27 (or up to PL34) for HANA.

Scenario:

Unable to upgrade the SAP integration solutions PL27 (or up to PL34) add-on to Walldorf Intercompany and IntegrationHub for HANA.

Expected Result:

SAP integration solutions is upgraded successfully to Walldorf Intercompany and IntegrationHub.

Actual Result:

Fails to upgrade SAP integration solutions add-on.


Solution

Following are the steps to be followed in order to fix the issue:

1. Take the backup of all the databases (all participant companies, Landscape, SBO-Common and B1if) in the Intercompany solution landscape.
2. Take the backup of procedure SBO_SP_TRANSACTIONNOTIFICATION in case any custom code is written (other than Intercompany code).
3. Open the SAP Business One with "Run as Administrator"
4. Register and Install the "Walldorf Intercompany and IntegrationHub" Version add-on which is compatible with the installed SAP version.
5. While upgrading, if the add-on gives any of the following errors:

IntegrationSoluitons Add-on failed to update the database.

OR

Error: Error Code:-1116 Error Description :[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;328 invalid name of function or procedure: no procedure with name SBO_SP_TRANSACTIONNOTIFICATION found: line 1 col 35 (at pos 34)

OR

User :manager, Method :UpdateSAPNotificationProcedureForHana, Error Message :Specified argument was out of the range of valid values.

6. Check the SBO_SP_TRANSACTIONNOTIFICATION in the database.
7. If the SBO_SP_TRANSACTIONNOTIFICATION is not available then execute the SBO_SP_TRANSACTIONNOTIFICATION SQL script attached to this note in the affected company database.
8. Verify the SBO_SP_TRANSACTIONNOTIFICATION in the database again, it should be available now.
9. Start the "Walldorf Intercompany and IntegrationHub" version add-on, the add-on should connect successfully.
10. Verify the add-on log file, there should be no error.
11. Verify the installed add-on version and installation date in UDT "CTX_CONF" e.g. for Walldorf add-on version 47, values should be like-> SQL Version - 34.1, Version Transaction Count - 47.0, Installation Date - "2/17/2023 4:58:29 PM".
12. Verify the existence of the UDT "CTX_USERINFO". Also, it should contain more than zero (0) records.
13. After connecting the add-on, create or update any sample item or business partner master data in SAP Business One company.

Note: Any custom code in the SBO_SP_TRANSACTIONNOTIFICATION should be appended manually after the Waldorf solution's code.

Product
Product or Product Version
B1 INTERCOMPANY INTEGRATION
SAP B1 10.0 FOR SAP HANA
SAP B1 9.3 FOR SAP HANA