Introduction
The article describes typical problems, their reasons, and solutions.
Enabling Logging
To enable StoreHouse 5 logging:
...
How to read the log: procedure name is DebugProc, the execution time, including the commit or rollback time, is 1.05 seconds, the connection ID is 11, the procedure was completed successfully; the signature for the search is PROCTIME.
Error Sending Data to Server Win32 = 10054
During the inactive time, the following error may appear: Error sending data to the Win32 server = 10054: An existing connection was forcibly closed by the remote host.
...
If you enable the Log network events setting, you will see a string of the type Keep-alive enabled; prot=1; ip=so-and-so; time=300000; interval=10000 or an error message for each new TCP connection in the server protocol.
Invalid Object Name
During the synchronization setup with r_keeper 7 via QUSH, the following error may occur:
...
The problem occurs because there is no data in the SQL table. Data is not transferred from r_keeper 7 to SQL due to the connection to SQL not by IP, but by name:
r_keeper | QUSH |
|
|
At the same time, checking the settings will give no errors, both in the manager station and in QUSH.
...
- Go to the SQL Sever Configuration Manager, it is located in the Start menu
- Next, go to the Protocols for SQL section
- Go to the TCP/IP protocol settings
- Select IP Addresses section and specify the port for the required IP addresses. By default, this is port 1433, but you can specify any suitable one. Be sure to specify the port at 127.0.0.1 or at the internal IP, if the server and the client are not installed on the same computer
- Click ОК. Restart the MSSQL service to apply the changes. You can restart it via Configuration Manager or Windows services.
- Now you can connect to the database by IP address. Check this through SQL Server Management Studio. If it is connected, it means that you did everything correctly.
- Reconfigure synchronization with SQL in RK7 and QUSH to IP. The problem is solved.
Offline License Is Used
When replacing the database, the following license error may appear: Offline license is used
...