Q: Who is affected?
A: People running HANA on following patches SAP 9.1 PL10-13 + SAP 9.2 PL00-07 (MSSQL is not affected)
Q: What is this bug and how do it manifest itself?
A: The problem can manifest itself in many different ways but are normally happening during startup of the add-on after an upgrade. It present itself as an unexpected error in older add-on version and mention one of the following issues:
- Some SQL sentence could not execute with no explanation why
- That a transaction could not be commited
- That a record could not be added
- That a new table or field could not be added
Result is that the Boyum add-on can't be started.
Q: How do I fix the issue?
A: You will need to go to HANA Studio and update the SAP Stored procedures ("SBO_SP_TransactionNotification" and "SBO_SP_PostTransactionNotice") from NVARCHAR(20) to NVARCHAR(30) [See comment below on how to do that] + check that any customization inside the stored procedures can also handle the new length (see below). You can also read the official SAP not on the issue here: https://launchpad.support.sap.com/#/notes/2228417
Q: I've have already fix the NVARCHAR(20) to NVARCHAR(30) but I still have the issue. What to do?
A: In such a case you most likely have customization the the Stored Procedures done by consultants or other add-ons. A very common issue is that other add-ons (beas/TaskCenter/Enprise ect.) inside SAP's SPs call their own Stored Procedure. If such a stored procedure has not been updated it most likely only accept NVARCHAR(20) and the SAP's SP try to call with more than 20 they fail resulting in the error.
What you need to do in such a situation is you need to contact the people in charge of the modifications made and have them fix it (refer to this post or the SAP note listed below if they do not know what you are talking about). Boyum can't help with such modifications!
Q: Why are you more affected an not others?
A: It is related to how long add-ons User-defined Table codes are. If they are higher than 16 the issue occur. We have many tables that are affected by this compared to others and that is the main reason but all add-ons with long table-names are affected.
Q: What is done to fix this?
A: SAP know of the issue and have planned to fix this in SAP 9.2 PL06. Please know however that the fix is only for new database so all above is still relevant if you upgrade. The official SAP Note on the matter is here: https://launchpad.support.sap.com/#/notes/2228417
From our side we have made it so B1UP 2016.11 HF1 have code in it that try to autofix for people with unmodified Stored Procedures but ultimately only SAP and the Add-on providers that use the SP's can fix this.