Differences

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

--- cobi.wms:installation_guides [2023/04/05 06:11] – tkammer
+++ cobi.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
   - (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
     - MS SQL Server: 1433
     - HANA Proxy: 30075
     - 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
-  - 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 =====
+**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.
@@ Line 31: / Line 33: @@
   - Import the **[[B1i Scenario Package]]**
     - 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
     - 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.
   * **[[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:**
+. **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.
+. **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.**
+. **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.