Differences

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

--- cobi.wms:installation_guides [2022/05/02 13:14] – tkammer
+++ cobi.wms:installation_guides [2025/02/19 14:29] (current) – thuth
@@ Line 1: / Line 1: @@
-====== Step-by-step implementation guides ======
+====== Installation Guides ======
 The steps you need to follow for implementing COBI.wms depend on the type of your SAP Business One installation.  Follow the steps under the section that describes your environment.
-===== On-premises or private cloud, MS SQL Server, SBO 9.3 or earlier =====
-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.
-  - 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:
-    - 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
 ===== On-premises or private cloud, with Service Layer =====
@@ Line 19: / Line 9: @@
   - Create the **[[Management Database]]**
     - Create the database itself by copy-pasting the correct creation script into //SQL Server Management Studio// or //HANA Studio//
-    - Import licenses by using the appropriate ''INSERT'' statement from the Management Database documentation
+    - Add SAP Business One connections by using the appropriate ''INSERT'' statement from the Management Database
-    - Add SAP Business One connections by using the appropriate ''INSERT'' statement from the Management Database documentation
+    - 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.
+  - 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 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
 ===== Public cloud =====
@@ Line 40: / Line 42: @@
 If you are using SAP Business One from a public cloud (SAP-hosted or partner-hosted) then first of all, **your cloud provider must make Service Layer accessible**.  Talk to your provider for details about this.
+Additionally, to make all features of COBI.wms available and for better performance, the app needs to create a number of SQL Queries over Service Layer.  This requires **SAP Business One Version 10 FP2011** or newer.  Also, you either need a superuser to create the SQL Queries, or a user with the permission **Modify SQL Queries in Service Layer** which is only available starting with **FP2108**.  Please see the section **Creating SQL Queries** below for more details.
 ==== Configuring the app ====
@@ Line 57: / Line 61: @@
 When connecting to a cloud deployment of SAP Business One, COBI.wms cannot establish a direct database connection and instead has to request all data over Service Layer.  To improve the functionality and performance of these data requests, the app can create a number of SQL Queries while logging in to a company database.
-This is done by checking **"Update SQL queries"** in the login screen, above the login button.  (It will create them if they were not created yet, otherwise update them to the newest version.)
+This is done by checking **Update SQL Queries** in the login screen, below the login button, before logging in.  (This will create the Queries if they were not created yet, and update them to the newest version if they were already created but not up-to-date, so it's recommended to do this once for every new version of COBI.wms.)
-For this SQL Query creation/update to work correctly, the SAP user you've entered for the connection settings in step 3 in the previous section has to be either a superuser, or have the permission **"Modify SQL Queries in Service Layer"** under the "General" category.  This permission is only available since **SAP Business One Version 10 FP2108**.  In older versions, you must use a superuser.
+For this SQL Query creation/update to work correctly, the SAP user you've entered for the connection settings (see step 3 of the previous section) has to be either a superuser, or have the permission **Modify SQL Queries in Service Layer** under the "General" category.  This permission is only available since **SAP Business One Version 10 FP2108**.  In older versions, you must use a superuser.
 ===== All types of installation =====
@@ Line 70: / 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.