The server is running, but users cannot log in.


Error message in client

Error reading buffer. The type initializer for Systemite.lz4.Lz4 threw an exception.


Resolution

The vcruntime.dll file is missing from the client directory. Adding it should solve the error.


The server is running, but users cannot log in.


Error message from log file

INFO  sws     - InitObjects end
[15044] INFO sws - Initializing...
[15044] INFO sws - Initializing Libraries
[15044] INFO Init - File repository: E:\SystemIte\Repository
[15044] INFO Init - File repository opened.
[15044] INFO Server - Database loaded.
[15044] INFO Server - UseSSL=False
[15044] INFO Server - Connecting to port: 3003
[15044] INFO tcp - TCP listening to 3003
[15044] INFO Server - Server started.
[16316] INFO  tcp     - Connection opened from 10.251.196.175
[16316] ERROR tcp - Exception in TCPServerConnect: Unable to load lz4 library
[16316] ERROR tcp     - Exception in TCPServerDisConnect: Access violation at address 000000000088C4FE in module 'swServer64.exe'. Read of address 0000000000000088


Resolution

Update Visual C++ Redistributable for Visual Studio on the server. This is often already installed on Windows machines because many other programs also use it. If a machine is basically clean with not much installed, it may also be missing. If that is the case, you will need to install it: Download Microsoft Visual C++ Redistributable for Visual Studio 2017.


The server is running, but users cannot log in.


Error message from log file

ERROR  SWConnection.Execute> Could not load file or assembly 'Systemite.Lz4, Version=1.0.6725.25651, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.   at Systemite.SystemWeaver.TcpSubServer.TcpConnection.WritePacket(Byte[] packet, Boolean fromEventThread)
at Systemite.SystemWeaver.TcpSubServer.TcpConnection.WriteBytes(Byte[] bytes, Boolean fromEventThread) in E:\AutomatedBuild\repos\trunk\CSharp\Source\Applications\Systemite.SystemWeaver.TcpSubServer\Project\TcpConnection.cs:line 145
   at Systemite.SystemWeaver.TcpSubServer.TcpConnection.Execute() in E:\AutomatedBuild\repos\trunk\CSharp\Source\Applications\Systemite.SystemWeaver.TcpSubServer\Project\TcpConnection.cs:line 107


Resolution

The Systemite.Lz4 file is missing from the server directory. Adding it should resolve the error.


The server will not start. 


Error message

Database is invalid version: 1.XX. This server requires database version: 1.XX.


Resolution

The version of the server application is not compatible with the version of the database. Contact your SystemWeaver Administrator or support@systemite.se for assistance.


The server will not start.


Error message

Error - Only one usage of each socket address (protocol/network address/port) is normally permitted


Resolution

The port number is already in use. Enter a different port number for the server. 


The server will not start.


Error message

INFO  main    - Command thread error: Error reading Integer from pipe.

INFO  main    - Command thread stopped

INFO  main    - TCP Server stopped with error: 1


Resolution

Check to see that you have the certificate file in the same location as the server executable. Check also that the libeay32.dll and ssleay32.dll files are there as well.



The server will not start.


Error message

[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in opening server connection

ERROR Could not open database: XXXX


Resolution

The problem resides on the MS SQL database server end.  Troubleshooting should be completed there.


The server will not start.


Example error message in swServer log 

ERROR adadapter - Error: [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. 

UPDATE swAttribute SET [Value] = :Value WHERE OBJ_ID = :OBJ_ID

ERROR bcall - [247816:248][FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. 


Error message in TcpSubServer log

ERROR Main> Ending program: Pipe is broken. at System.IO.Pipes.PipeStream.WinIOError(Int32 errorCode) 


Resolution

The error resides with the ODBC driver and not the server. The cause is that an attempt was made to save too large of an amount of data to an attribute, but entirely manageable from a database perspective.


In the short term, the server will need to be restarted. 


For a long-term resolution, upgrading to Microsoft® ODBC Driver 13 for SQL Server® - Windows (https://www.microsoft.com/en-us/download/details.aspx?id=50420) or later should resolve the issue.  


After upgrade to version 13:


Starting with version 1.50.0.22998 of the swDatabaseManager tool, there is a Check max blob size button to test importing large data. To test, click the button. You do not need sole access to the database. 


Blob size is OK:


Blob size is too large to handle:



A user tries to add data to a replicated column or captured column in an MS SQL database that exceeds the allowed size.


Error message

[FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Length of LOB data (70199) to be replicated exceeds configured maximum 65536.


Resolution

The problem resides on the MS SQL database server end.  Consider adjusting the Max Text Replication Size setting.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-text-repl-size-server-configuration-option?view=sql-server-2017