This article includes some known errors that can occur. In general, prior to restarting the SystemWeaver server application as a means of resolving a reported problem:
- Open the Task Manager on the server machine.
- Find the swDBServer.exe and check if there is some activity on it.
- If there is activity, the server is still running, it is likely handling a high load of operations. If the CPU is active, we recommend letting it run. It will become responsive again to users once it is finished.
- The server is running, but users cannot log in.
- The server will not start.
- A user tries to add data that exceeds the allowed size.
- We recently upgraded SystemWeaver and the server will not start.
- User is trying to run the Statistics Report in swArchitect.
- User is trying to open an item structure.
- I am trying to start a SystemWeaver server against an MS SQL database, but it won't start.
- Users are unable to connect.
- I am trying to start a swTestServer against a SQLite database, but it won't start.
- I have started a swTestServer with SSL encryption turned on (UseSSL=True), but users cannot log in.
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.
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
You may need to update Visual C++ Redistributable for Visual Studio on the server machine. 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 be missing. If that is the case, you will need to install it: Microsoft Visual C++ Redistributable for Visual Studio 2017 or later. Alternatively, confirm that the user is not missing any files in their client directory, e.g., vcruntime140.dll, liblz4.dll.
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
ERROR sws - DB Integrity error
Resolution
The error may be an indication that the data in the database contains orphaned parts and/attributes that do not have an owner. This must be cleaned up before the server can be started. Contact support@systemweaver.com for more information.
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.
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.
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.
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.
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 that exceeds the allowed size.
Applicable to MS SQL Server only.
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.
We recently upgraded SystemWeaver and the server will not start.
Error message
Method not found: '!!0[] System.Array.Empty()'
Resolution
Check to be sure .NET Framework 4.7 or later is installed on the server machine. If not, installing it should resolve the issue.
User is trying to run the Statistics Report in swArchitect.
Error message
ERROR main - Access violation at address 0000000000F7CBD6 in module 'swTestServer.exe'. Read of address 0000000000000010
[0000000000F7CBD6] swServerDataSerializer.TServerDataSerializer.SerializeAttributeWithoutOwner (Line 945, "swServerDataSerializer.pas" + 16) + $F
Resolution
The root cause is a data problem with an attribute. Contact support@systemite.se for troubleshooting assistance, and provide the complete stack trace error. Note that the data error will also cause slave servers to be unable to load all data upfront.
User is trying to open an item structure.
Error message
Exception message: Handle does not refer to an entity.
Stack list, generated 2020-05-28 19:19:55
(01F6C7D8){swExplorer.exe} [0236D7D8] swClientAPI.Error (Line 5059, "swClientAPI.pas" + 2) + $B
(01F73EAB){swExplorer.exe} [02374EAB] swClientAPI.TswClientBroker.GetEntity (Line 6803, "swClientAPI.pas" + 9) + $B
(01FA1C9C){swExplorer.exe} [023A2C9C] swClientAPI.TswGroup.InitGroupMembers (Line 18057, "swClientAPI.pas" + 15) + $1A
(01FA1069){swExplorer.exe} [023A2069] swClientAPI.TswGroup.CheckGroupMembers (Line 17850, "swClientAPI.pas" + 5) + $5
Resolution
The root cause is a data problem in a user group. A fix is available for version R33 and later. Contact support@systemite.se for instructions on how to use the swDatabaseManager to remove invalid group member(s).
I am trying to start a SystemWeaver server against an MS SQL database, but it won't start.
Error message
ERROR sws - [FireDAC][Phys][ODBC][Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'META_INFO'.
Resolution
The cause is likely that the internal database that the SystemWeaver server uses has not been created yet. See Creating the Internal Database (for non-SQLite databases).
Users are unable to connect.
Error message
Unable to connect to server. Socket Error # 10054
Resolution
The problem resides external from SystemWeaver. This is a Windows error that can be caused by many reasons, e.g., an incorrect firewall configuration.
I am trying to start a swTestServer against a SQLite database, but it won't start.
Error message
ERROR sws - Could not open database: E:\Data\DB.sqlite [FireDAC][Phys][SQLite] ERROR: Cipher: DB is not encrypted
Resolution
Confirm that the DatabasePassword and DatabasePasswordEncrypted entries in the swServer.ini are null as these are not required for SQLite databases.
I have started a swTestServer with SSL encryption turned on (UseSSL=True), but users cannot log in.
Error message
The client and server cannot communicate, because they do not possess a common algorithm at System.Net.SSPIWrapper.AcquireCredentialsHandle(SSPIInterface SecModule, String package, CredentialUse intent, SecureCredential scc)
Resolution
If running IIS Crypto, check if your current settings are compatible with .NET Framework.