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

implementation:wms:install_nl_storedprocedure [2018/01/17 15:55] (current)
csuhaa created
Line 1: Line 1:
 +==== 3.3.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”.
 +
 +This step is only necessary if you intend to use the SB1 Notification Listener.
 +  * 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 |}}
 +
 +Locate the “Produmex SboNotification Queue Code” at the end of this stored procedure (see illustration below)
 +
 +{{:​implementation:​notification_listener_stored_procedure_02.png?​nolink|}}
 +
 +Copy the “Produmex SboNotification Queue Code”.\\
 +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 |}}
 +
 +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"​).
 +
 +{{:​implementation:​notification_listener_stored_procedure_04.png?​nolink|}}
 +
 +Afterwards you need to uncomment the SP by clicking the “uncomment” button in SQL management studio.\\
 +The end result should look like this:
 +
 +{{:​implementation:​notification_listener_stored_procedure_05.png?​nolink|}}
 +
 +After these modifications. Execute the PMX_SP_TransactionNotification stored procedure.
implementation/wms/install_nl_storedprocedure.txt · Last modified: 2018/01/17 15:55 by csuhaa