Welcome to the community forums for Theopenem. All responses are provided by other users that wish to help out. Theopenem will not respond to these posts. If you require more assistance than what the community can provide, we offer various paid support options.

Module replication throws errors


  • I don't know for how long this was happening. I can't get the uploaded files to replicate from SMB to TOEMS server (again). The Application.log is full of these:

    2024-02-21 13:06:58,027 [Worker #7] INFO Toems_Service.Workflows.FolderSync A Replication process is already in progress.
    

    and

    2024-02-21 13:16:34,694 [Worker #3] ERROR Toems_DataModel.RawSqlRepository You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (a.provision_status = 8 OR a.provision_status = 6 OR a.provision_status = ' at line 1
    

    The Replication job seemingly never finishes, and I have to copy the contents of the uploaded files from SMB to the only TOEMS server.


  • My problem is still occuring - still haven't found a way to cancel existing replication task and my software_uploads are not syncing to my Com Server. Even tried to move all files from old SMB server to new one. IIS_USERS have write permissions on local storage on Com Server.

    For now I'm still using this command to start Robocopy, which does work fine:

    Robocopy \\storage\toem\software_uploads O:\software_uploads /E /ZB /LOG:O:\Robocopy.log
    

  • @theopenem_admin I'm really sorry for mentioning, but I'd really like to find a way to fix this without reinstalling the whole server and clients.
    There are no "Active Replications" nor can I found a way to stop the Worker process. I tried to zip all software_uploads on TOEMS local storage, delete the contents of the folder, but it didn't help. The same if I deleted everything in that folder from SMB and local storage.