Symptom
The following error occurs while adding a service type, Delivery or A/R Invoice document, in the SAP HANA environment when the G/L account is missing at the line level:
[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;1299 no data found "TESTDB_LIVE"."SBO_SP_TRANSACTIONNOTIFICATION": line 794 col 4 (at pos 32888) "TESTDB_LIVE"."HUB_SP_TRANSACTIONNOTIFICATION_DOC": line 23 col 1 (at pos 740)
Reproducing the issue
Prerequisites
You are using Intercompany Integration Solution version 55.0 or lower.
SAP Business One is running on SAP HANA.
Scenario
A "No data found" error occurs when adding the service type, Delivery or A/R Invoice, in the HANA environment. The following are the steps to reproduce the issue:
1. Create a Service Type Delivery or A/R Invoice.
2. Leave the G/L Account field empty at the document line level.
3. Attempt to add the document.
4. Observe that the system throws the General error;1299 – No Data Found error referencing SBO_SP_TRANSACTIONNOTIFICATION and HUB_SP_TRANSACTIONNOTIFICATION_DOC.
Expected Result
The service type delivery or A/R invoice document is successfully added without any error.
Actual Result
The document cannot be added, and the system throws a HANA database error (General error;1299 – No Data Found) triggered from the transaction notification stored procedure.
Solution
The issue described above has been fixed in the Intercompany integration solution version 56 for SAP Business One and higher versions.
Product
Product or Product Version
B1 INTERCOMPANY INTEGRATION
SAP B1 10.0 FOR SAP HANA
SAP B1 9.3 FOR SAP HANA
This document refers to :
WDF 2560001 - Overview Note for Intercompany Integration Solution Version 56 for SAP Business One