Differences

This shows you the differences between two versions of the page.

--- bw2:call_bizweaver_from_sql [2020/12/15 11:46]
akoehler [Procedure Variables]
+++ bw2:call_bizweaver_from_sql [2024/09/09 13:41] (current)
dlee [Calling Bizweaver from SAP Business One]
@@ Line 1: / Line 1: @@
-====== Calling Bizweaver from SAP Business One ======
+====== Calling Bizweaver from SQL ======
 <WRAP center round important>
 Some special program code, provided by Third Wave Business Systems, is required for this functionality to work.  Configuration of the special code is described **//[[bw2:sqlws_config|here]]//**.  This is a technical process and should not be attempted by anyone not familiar with T-SQL stored procedures. Contact TWBS support if you need assistance.
 </WRAP>
+<WRAP center round important>There are limitations associated with executing workflows via the Bizweaver web service.
+) There is an upper limit on the number of HTTPS calls that can be made at which point SQL OLE gets blocked.
+) With SQL CLR the SAP commit waits until the BW workflow is complete and often, the user cannot wait that long.
+To overcome these limitations use the direct communication method described here: [[bw2:bizweaver_trigger|Executing Workflows from SAP Business One Using Direct Communication]]
+</WRAP>
 The call to the Bizweaver web service is initiated from the standard SAP Business One Stored Procedure **SBO_SP_PostTransactionNotice**.  The following SQL statements illustrate what needs to be added to the procedure.

Wiki