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

Next revision
Previous revision
implementation:wms:install_nl_storedprocedure [2018/01/17 15:55]
csuhaa created
implementation:wms:install_nl_storedprocedure [2020/01/17 14:41] (current)
vise
Line 1: Line 1:
-==== 3.3.3. Enable the Notification Listener stored procedure ====+==== 3.4.3. Enable the Notification Listener stored procedure ====
  
-After the Notification Listener ​configuration ​is done you need to enable ​the stored procedures in the stored procedure of SAP named “PMX_TransactionNotification”.+Note: If the SB1 Notification Listener is not installed, continue with section [[implementation:​wms:​install_registeraddon|3.5. Register ​the Produmex add-on]].
  
-This step is only necessary if you intend to use the SB1 Notification Listener+After configuring ​the SB1 Notification Listenerthe stored procedures must be enabled in the “PMX_TransactionNotification” SAP stored procedure ​as follows.
-  * To do this open “SQL Server Management Studio” and connect to your database server. +
-  * Expand ​the “Databases” folder and locate the **PMX database** (not the Company database) to which you want to apply the Produmex Add-on. +
-  * Open this database directory and open the “Programmability\Stored Procedures” subdirectory. +
-  * Locate the “dbo.PMX_SP_TransactionNotificationQueue” stored procedure, right-click it and select “Modify”+
  
-{{ :​implementation:​install:​installguide:​notification_listener_stored_procedure_01.png?nolink |}}+1. Open the SQL Server Management Studio and connect to your database server.
  
-Locate ​the “Produmex SboNotification Queue Code” at the end of this stored procedure (see illustration below)+2. Expand ​the //​Databases//​ folder and locate ​the company database to which you want to apply the Produmex Add-on.
  
-{{:​implementation:​notification_listener_stored_procedure_02.png?​nolink|}}+3. Open this database directory and open the Programmability / Stored Procedures subdirectory.
  
-Copy the “Produmex SboNotification Queue Code”.\\ +4. Locate ​the dbo.PMX_SP_TransactionNotificationQueue ​stored procedure, ​right-click it and select //Modify//
-This code should now be pasted in the “PMX_SP_TransactionNotification” ​stored procedure, ​in the **Company database**Modify this stored procedure in the same way you modified the PMX_SP_TransactionNotificationQueue+
  
-{{ :​implementation:​install:​installguide:​notification_listener_stored_procedure_03.png?nolink |}}+{{ :​implementation:​install:​installguide:​notification_listener_stored_procedure_01.png?nolink |Enable the Notification Listener stored procedure}}
  
-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 "​Enable the standard PMX stored procedure"​).+5. Locate ​the //Produmex SboNotification Queue Code// at the end of this stored procedure (see illustration below).
  
-{{:​implementation:​notification_listener_stored_procedure_04.png?​nolink|}}+{{:​implementation:​notification_listener_stored_procedure_02.png?​nolink|Enable the Notification Listener stored procedure}}
  
-Afterwards you need to uncomment the SP by clicking ​the “uncomment” button in SQL management studio.\\ +6. Copy the //Produmex SboNotification Queue Code//.\\
-The end result should look like this:+
  
-{{:​implementation:​notification_listener_stored_procedure_05.png?​nolink|}}+This code should now be pasted in the “dbo.PMX_SP_TransactionNotification” stored procedure in the **Company database** as follows.
  
-After these modifications. Execute the PMX_SP_TransactionNotification stored procedure.+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 |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). 
 + 
 +{{:​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.\\ 
 +The result should look like this: 
 + 
 +{{:​implementation:​notification_listener_stored_procedure_05.png?​nolink|Enable the Notification Listener stored procedure}} 
 + 
 +10. Execute the PMX_SP_TransactionNotification stored procedure.
implementation/wms/install_nl_storedprocedure.1516204523.txt.gz · Last modified: 2018/01/17 15:55 by csuhaa