User Tools

Site Tools


implementation:wms:install_nl_storedprocedure

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
implementation:wms:install_nl_storedprocedure [2019/11/05 15:15]
vise
implementation:wms:install_nl_storedprocedure [2020/01/17 14:41] (current)
vise
Line 1: Line 1:
 ==== 3.4.3. Enable the Notification Listener stored procedure ==== ==== 3.4.3. Enable the Notification Listener stored procedure ====
  
-This step is only necessary if you intend to use the SB1 Notification Listener.+Note: If the SB1 Notification Listener ​is not installed, continue with section [[implementation:​wms:​install_registeraddon|3.5. Register the Produmex add-on]].
  
-After the Notification Listener ​configuration is doneyou need to enable ​the stored procedures in the stored procedure of SAP named “PMX_TransactionNotification”.+After configuring ​the SB1 Notification Listener, the stored procedures ​must be enabled ​in the “PMX_TransactionNotification” ​SAP stored procedure as follows.
  
 1. Open the SQL Server Management Studio and connect to your database server. 1. Open the SQL Server Management Studio and connect to your database server.
Line 13: Line 13:
 4. Locate the dbo.PMX_SP_TransactionNotificationQueue stored procedure, right-click it and select //​Modify//​. ​ 4. Locate the dbo.PMX_SP_TransactionNotificationQueue stored procedure, right-click it and select //​Modify//​. ​
  
-{{ :​implementation:​install:​installguide:​notification_listener_stored_procedure_01.png?​nolink |}}+{{ :​implementation:​install:​installguide:​notification_listener_stored_procedure_01.png?​nolink |Enable the Notification Listener stored procedure}}
  
-5. Locate the //Produmex SboNotification Queue Code// at the end of this stored procedure (see illustration below)+5. Locate the //Produmex SboNotification Queue Code// at the end of this stored procedure (see illustration below).
  
-{{:​implementation:​notification_listener_stored_procedure_02.png?​nolink|}}+{{:​implementation:​notification_listener_stored_procedure_02.png?​nolink|Enable the Notification Listener stored procedure}}
  
 6. Copy the //Produmex SboNotification Queue Code//.\\ 6. Copy the //Produmex SboNotification Queue Code//.\\
  
-This code should now be pasted in the “dbo.PMX_SP_TransactionNotification” stored procedurein the **Company database**. ​+This code should now be pasted in the “dbo.PMX_SP_TransactionNotification” stored procedure in the **Company database** ​as follows.
  
 7. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select ''​Modify''​. 7. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select ''​Modify''​.
  
-{{ :​implementation:​install:​installguide:​notification_listener_stored_procedure_03.png?​nolink |}}+{{ :​implementation:​install:​installguide:​notification_listener_stored_procedure_03.png?​nolink |Enable the Notification Listener stored procedure}}
  
 8. Paste the “Produmex SboNotification Queue Code” at the end of it, right after the code you have copied for the Produmex Addon stored procedure (see 3.3.1. Enable the standard PMX stored procedure). 8. Paste the “Produmex SboNotification Queue Code” at the end of it, right after the code you have copied for the Produmex Addon stored procedure (see 3.3.1. Enable the standard PMX stored procedure).
  
-{{:​implementation:​notification_listener_stored_procedure_04.png?​nolink|}}+{{:​implementation:​notification_listener_stored_procedure_04.png?​nolink|Enable the Notification Listener stored procedure}}
  
-9. Uncomment the SP by clicking the ''​Uncomment''​ button in SQL management studio.\\ +9. Uncomment the SP by clicking the ''​Uncomment''​ button in SQL Management Studio.\\ 
-The end result should look like this:+The result should look like this:
  
-{{:​implementation:​notification_listener_stored_procedure_05.png?​nolink|}}+{{:​implementation:​notification_listener_stored_procedure_05.png?​nolink|Enable the Notification Listener stored procedure}}
  
 10. Execute the PMX_SP_TransactionNotification stored procedure. 10. Execute the PMX_SP_TransactionNotification stored procedure.
implementation/wms/install_nl_storedprocedure.1572966954.txt.gz · Last modified: 2019/11/05 15:15 by vise