Client is attempting to synchronize Forms. The user authentication is set to use LFDS. When Client runs the synchronization, only the last completed time is updated. It doesn't indicate whether its a success or failure.

The reason I think it's failing is because the 'Forms Group' which all users belong to isn't showing up in Forms. And some its still showing users that are full named license users as invalid. These users are all members of the Forms Group.

Here is the log event:

Log Name:      Laserfiche-Forms-App/Admin
Source:        Laserfiche-Forms-App
Date:          10/30/2019 3:44:16 PM
Event ID:      10502
Task Category: UnexpectedErrorErrorAdmin
Level:         Error
Keywords:      Session0,Session1,Session2,Session3
User:          SYSTEM
Computer:      xxx.xx.local
Description:
An unexpected error has occurred. [LFF502-UnexpectedError]

Details:
URL: 
Error: UnexpectedError
Date: 10/30/2019 3:44:16 PM (Mountain Standard Time)
HTTP Status Code: 500
Business Process ID: 0
Business Process Name: 

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: An unexpected error has occurred. [LFF502-UnexpectedError]


Inner exception: System.Data.SqlClient.SqlException
Message: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Laserfiche.Forms.CommonUtils.FormsUserSyncer.RetrieveLfdsUsers(ILfdsHelper lfdsHelper, cf_tenants defaultTenant, UserSyncReport syncReport)
   at Laserfiche.Forms.CommonUtils.FormsUserSyncer.RetriveLaserficheAccounts(IEntityContext appContext, DateTime currentTime, Int32 expiryLen, String primaryEmailAddress, RetrieveAccountType retrieveType, UserSyncReport syncReport, Boolean forceSyncAll)


Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Laserfiche-Forms-App" Guid="{98141CA4-660B-51C6-66B4-EC37F5B2FD87}" />
    <EventID>10502</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>55032</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000f00000000000</Keywords>
    <TimeCreated SystemTime="2019-10-30T21:44:16.493140800Z" />
    <EventRecordID>153558</EventRecordID>
    <Correlation />
    <Execution ProcessID="4404" ThreadID="4684" />
    <Channel>Laserfiche-Forms-App/Admin</Channel>
    <Computer>xxx.xx.local</Computer>
    <Security UserID="S-1-5-18" />
  </System>
  <EventData>
    <Data Name="message">An unexpected error has occurred. [LFF502-UnexpectedError]

Details:
URL: 
Error: UnexpectedError
Date: 10/30/2019 3:44:16 PM (Mountain Standard Time)
HTTP Status Code: 500
Business Process ID: 0
Business Process Name: 

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: An unexpected error has occurred. [LFF502-UnexpectedError]


Inner exception: System.Data.SqlClient.SqlException
Message: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Laserfiche.Forms.CommonUtils.FormsUserSyncer.RetrieveLfdsUsers(ILfdsHelper lfdsHelper, cf_tenants defaultTenant, UserSyncReport syncReport)
   at Laserfiche.Forms.CommonUtils.FormsUserSyncer.RetriveLaserficheAccounts(IEntityContext appContext, DateTime currentTime, Int32 expiryLen, String primaryEmailAddress, RetrieveAccountType retrieveType, UserSyncReport syncReport, Boolean forceSyncAll)

</Data>
  </EventData>
</Event>

Below is the corresponding event viewr log.