User Tools

Site Tools


implementation:scan:service_manager

4. Produmex Service Manager

The Produmex Service Manager can handle the Produmex Service Broker and other Produmex services. Service parameters, connection data to the database server, and the connection data to the company database/schema can also be modified on the Service Manager.

The Service Manager needs to be started in Administrator mode because it has to be able to start/stop/modify the ProdumexServiceBroker Windows service.

4.1. Set up/Modify Connection to the SAP company

1. Click on the Setup Companies button.

2. On the opening screen enter the connection data to your SAP company database/schema.

  • MSSQL
    • Server: Enter the name or IP address of the server.
    • Port: Enter the port on which the application can connect to the database server. It is usually 1433, but if you have a named instance in the SQL server, the actual port must be checked.
    • MSSQL Version: Select the MSSQL version number in the drop-down menu.
    • Language: The language of the DI API transactions can be modified in the field.
    • SQL User: Enter the SQL Server user name.
    • SQL Password: Enter the SQL Server password.

Setup companies

How to check the port number on SQL
Open the SQL Server Configuration Manager. Select the SQL Server instance and right-click on TCP/IP on the right side. Click on Properties and on the displayed form go to the bottom and check the port number.

Note: In this example there are no instances and the port is the default value of 1433.

Check port number

  • HANA
    • Server: The database server name must be added with the exact same format as it was added during the installation of the SAP Business One client.
      • Single-Database: Enter the name or the IP address of the database server to the field.
      • Multi-Database: The DATABASENAME parameter must be used: DBA@< >. Example: Server Name
    • Database Port: Enter the database port on which the application can connect to the server.
      • Single-Database: The default port is 30015.
      • Multi-Database: The default port is 30013.
    • MSSQL version: Select HANADB in the dropdown menu
    • Language: The language of the DI API transactions can be modified in the field.
    • SQL User: Enter the SQL Server user name.
    • SQL Password: Enter the SQL Server password.
    • When working on SAP B1 Cloud, add the domain username to the Domain user name field and enter the password to the Domain password field.

Setup companies

If you click Test DB Connection, the Service Manager tries to connect to the server with the given data. If the connection can be established, you will get the message Database connection test – success!

4.2. Add new database

Click on the Setup Companies button.

On the opening ‘Setup companies’ screen check the connection data. If you would like to add a database from a different database server, modify the connection parameters then click on the ‘Test DB Connection’ button to test the connection. The modification of the connection parameters does not affect the connection settings of the already added databases.

Click on the ‘+’ icon to add a new database/schema.

On the ’Database Setup’ window select the database/schema from the dropdown menu.

Enter an SBO User and its password to create the connection to the database/schema. SAP employees are used for log in the mobile device. Transactions initiated by the employees will be posted by the SAP user defined for the Service Broker. The SBO user must have the authorizations to create stock related bookings in SAP Business One (Delivery, Goods Receipt PO, Stock Transfer, etc.) The SBO user also need at least an SAP Indirect Access license type as of SBO 9.2. PL08.

Database setup

Click on the ‘Save’ button then close the window. You can close now Setup Companies and go back to the Service Manager main screen.

Now you have to assign your companies to the Produmex Service Broker and other Produmex services.

Click on the ‘Companies…’ button and select the company database/schema on the opening ‘Select Companies’ screen.

Select companies

4.3. Configure Produmex Service Broker

The Produmex Service Broker can work together with different Produmex add-ons, therefore in the Service Manager you have to configure which add-on you want to use. To do that, click on the ‘Configure…’ button or select it from the line of the Service Broker.

General tab

Service Broker service has to be restarted after changing a setting.

If you set the 'Debug writeline log' parameter to true, it will write a log about each command the Service Broker processes. Only set it to true, if Produmex support asks you to do that.

Kill time: If a Service Broker process does not finish within this time limit, it will be aborted. The setting depends on your server. If you have a quick server, set it to a small number, if you have a slow server, set it higher. The default value is 30 seconds.

'Modules to load' is the module of the add-on to which the service broker connects. It is automatically done by the module installer for you.

At the 'Port to listen on' you can set which port is used by the service broker to communicate with the clients. The default is 50231. Make sure that the port you set here is not blocked by any firewall or antivirus software.

The 'Server Discovery Enable' turns on the feature that the client can look up the running service broker server automatically. It makes setting up the clients easier.

You have to assign an administrator user to the service in the Windows Service Manager, otherwise the Service Broker cannot connect to SBO and cannot write to its log files. If the Service Broker stops right after starting it, and in the log file you have access denied errors, then the cause is that you have not assigned the administrator user to the service.

Produmex Service Configuration

Produmex Service Broker tab
On the Produmex Service Broker tab you can see the loaded modules, and you can remove/install new modules if needed.

If you see a check icon before the module name, it means it could be loaded successfully. If a problem arises, you will see error beside the module name.

Produmex Service Configuration

4.4. Start Produmex Service Broker

After you have set all settings and installed the server module, you can start the Service Broker service in the Service Manager by selecting first the service then clicking on the ‘Start’ button. If you want to stop a service, click on the ‘Stop’ button.

You can also stop or start the services from windows service manager, but you cannot change the Produmex settings there. It is recommended that you set the service to Automatic start and that you set the recovery options to Restart at Recovery in Service Properties for the service.

4.5. Start Produmex Service Broker in console mode

The Service Broker can be started from the command window as well. Only one instance can be started at the same time and the Service Broker service must be stopped. The use of the command window is recommended for debugging purposes and in production environment the use of the service is more efficient.

The Service Broker in console mode can be started by running the following .exe file in Administrator Mode: C:\Program Files (x86)\Produmex\ServiceBroker\BxServiceBroker.Console.exe

implementation/scan/service_manager.txt · Last modified: 2020/10/12 13:17 by pilinsr