After migrating to a new server users are receiving a SQL error: "Error executing SQL command" when trying to scan or print into Laserfiche. When checking the event viewer the detailed log information is as follows:

An error occurred when executing an SQL query, retrieving the results of a query, or otherwise communicating with the database server. Session ID=646; Dialog ID=0; Repository="lfdata"; Function=ActivityLog::Record; Message="[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'activity_log_pk'. Cannot insert duplicate key in object 'dbo.activity_log'. The duplicate key value is (2438990)."; Statement="insert into activity_log (asn, who, event, path1, path2, uuid1, uuid2, uuid3, tocid1, tocid2, tocid3, etype, old_obj_name, new_obj_name, old_obj_id, new_obj_id, prop_name, prop_id, flags, events) values (:asn<bigint>, :who<raw[85]>, :event<int>, :path1<char[1023]>, :path2<char[1023]>, :uuid1<char[36]>, :uuid2<char[36]>, :uuid3<char[36]>, :tocid1<int>, :tocid2<int>, :tocid3<int>, :etype<int>, :old_obj_name<char[63]>, :new_obj_name<char[63]>, :old_obj_id<int>, :new_obj_id<int>, :prop_name<char[63]>, :prop_id<int>, :flags<int>, :events<int>)"; SQL Variable=""; SQL State="23000".

This error appears for multiple different keys as well. I'm not entirely sure what next steps would be in this scenario. I've looped in a few different technicians but none seem to have any knowledge about this error message.

Laserfiche: Server 10.4.3 build 115

SQL: Server 2017 full - Database is running in compatibility level SQL Server 2008. I could not install an older version of SQL due to the database in the previous environment running sql 2017 as well.