User Tools

Site Tools


cobi.wms:installation_guides

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
cobi.wms:installation_guides [2023/04/05 06:11] tkammercobi.wms:installation_guides [2025/02/19 14:29] (current) thuth
Line 12: Line 12:
     - Import licenses by using the appropriate ''INSERT'' statement from the Management Database documentationdocumentation     - Import licenses by using the appropriate ''INSERT'' statement from the Management Database documentationdocumentation
   - (For HANA: Install and start the **[[HANA Proxy]]**)   - (For HANA: Install and start the **[[HANA Proxy]]**)
-  - Install COBI.wms from the Google Play Store on an Android device that can access the SAP Business One server 
   - Make sure that the TCP ports for direct DB queries and Service Layer are not blocked   - Make sure that the TCP ports for direct DB queries and Service Layer are not blocked
     - MS SQL Server: 1433     - MS SQL Server: 1433
     - HANA Proxy: 30075     - HANA Proxy: 30075
     - Service Layer: 50000 (https) or 50001 (http)     - Service Layer: 50000 (https) or 50001 (http)
-  - (optional) Use **{{cobiwms-config.html}}** to generate a Settings QR Code +  - Install COBI.wms from the Google Play Store on an Android device that can access the SAP Business One server 
-  - Open COBI.wms on the Android device and scan the Settings QR Code (or enter the settings manually)+  - (optional) Use **{{cobiwms-config.html}}** to generate a Settings QR Code to scan with the app 
 +  - Open COBI.wms on the Android device and scan the Settings QR Code or enter the settings manually
   - Click Connect and take note of the device ID on the right side of the screen below the Login button   - Click Connect and take note of the device ID on the right side of the screen below the Login button
-  - Assign a license to that device ID (see Management Database documentation again+  - Assign a license to that device ID (see [[Management_database#license_management | License Management]]
-  - Log in to COBI.wms with an empty username/password and make a test booking +  - Log in to COBI.wms and make a test booking 
-  - (optional) Create COBI.wms users in the Management Database +  - (optional) Create COBI.wms users in the Management Database (see [[management_database#cobiwms_users | COBI.wms Users]]) 
-  - (optional) Disable all modules for all devices and enable them for users instead to force user login+  - (optional) Disable all modules for all devices and enable them for users instead to force user login (see [[management_database#permission_management | Permission Management]])
  
 ===== (SBO 9.3 or earlier only) On-premises or private cloud, MS SQL Server ===== ===== (SBO 9.3 or earlier only) On-premises or private cloud, MS SQL Server =====
 +
 +**Warning: The use of Integration Framework with COBI.wms is deprecated and highly discouraged for new installations.  Most new COBI.wms features are only available when using Service Layer.**
  
 If you have an **on-premises or private cloud** installation of SAP Business One **Version 9.3 or older**, based on Microsoft **SQL Server** then please refer to the following steps.  Note that the **Integration Framework** must be installed already. If you have an **on-premises or private cloud** installation of SAP Business One **Version 9.3 or older**, based on Microsoft **SQL Server** then please refer to the following steps.  Note that the **Integration Framework** must be installed already.
Line 31: Line 33:
   - Import the **[[B1i Scenario Package]]**   - Import the **[[B1i Scenario Package]]**
     - Afterwards, copy the **Trigger** URL as described in the linked page and temporarily save it somewhere     - Afterwards, copy the **Trigger** URL as described in the linked page and temporarily save it somewhere
-  - Follow all the steps of the following section (on-prem with Service Layer), with the following differences:+  - Follow all the steps of the previous section (on-prem with Service Layer), with the following differences:
     - Use the Trigger URL for the ''APIURL'' field of the SAP Business One company connection added to the Management Database     - Use the Trigger URL for the ''APIURL'' field of the SAP Business One company connection added to the Management Database
     - Make sure that TCP Port 8080 for Integration Framework is opened on the server     - Make sure that TCP Port 8080 for Integration Framework is opened on the server
Line 72: Line 74:
   * **[[Print Settings]]**: See here for connecting to ZPL-based label printers.   * **[[Print Settings]]**: See here for connecting to ZPL-based label printers.
   * **[[Label Templates]]**: See here for a guide on designing COBI.wms label templates.   * **[[Label Templates]]**: See here for a guide on designing COBI.wms label templates.
 +
 +===== FAQ =====
 +==== SQL Server Port Issue: ==== 
 +When connecting to the SQL Server, you may encounter issues that are often related to firewall restrictions or SQL Server configuration problems.
 +
 +**Explanation:**  
 +The issue is typically due to one of the following reasons:\\
 +  - **Firewall Blockage:** The SQL port (commonly port 1433) might not be open between the COBI.wms device and the SAP Server. \\
 +  - **Server Configuration:** The SQL Server might be configured to disallow TCP/IP connections.
 +
 +**Steps to Diagnose and Resolve:**
 +
 +1. **Check Port Accessibility:**
 +   - From any Windows client on the same network as the COBI.wms device, open a PowerShell console.
 +   - Execute the following command (replace `<SAP_Server_IP>` with the actual IP address of your SAP Server)
 +PowerShell:
 +     Test-NetConnection <SAP_Server_IP> -Port 1433
 +     
 +     Expected Output:  
 +     The PowerShell output should show `TcpTestSucceeded : True`.  
 + If it shows **False**, the port is likely blocked by the firewall.
 +   
 +2. **Verify SQL Server Configuration:**
 +   - If the port is accessible (i.e., `TcpTestSucceeded` is True) but the connection still fails, the SQL Server might be blocking TCP/IP connections.
 +   - On the server running the SAP MSSQL Server, open **SQL Server Configuration Manager**.
 +   - Navigate to **SQL Server Network Configuration** → **Protocols for [InstanceName]**  
 +     (Note: The instance name may correspond to your SAP system, e.g., "SAP").
 +   - **Ensure that TCP/IP is enabled.**
 +
 +3. **Using a Dynamic TCP/IP Port (if necessary):**
 +   - If problems persist, consider connecting via the dynamic TCP/IP port:
 +     - In **SQL Server Configuration Manager**, double-click on **TCP/IP**.
 +     - Go to the **IP Addresses** tab and locate the dynamic port setting.
 +     - Enter the dynamic port number in COBI.wms under the "Optional Fields: DB-Portnummer" (DB Port Number).
 +     - Make sure the dynamic port is also allowed through the firewall.  
 +       You can verify this by running the PowerShell command again, substituting port 1433 with the dynamic port number.
 +
 +**Customer Confirmation:**  
 +One customer confirmed that switching to the dynamic port resolved their connection issues.
 +
cobi.wms/installation_guides.1680667900.txt.gz · Last modified: 2023/04/05 06:11 by tkammer

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki