Publié Mon, 22 Jan 2018 15:42:41 GMT par Grupo Terra

Hi,

When we first set up Docuware, we configured an LDAP synch routine which worked just fine. Now, it stopped working. I get the following error:

---------------------------------------------------------

1) Exception Information

     Exception Type: DocuWare.Common.Exceptions.DWException
    MessageID: DocuWare.Communication.AuthenticationServer.DataTables.InsertIntoTable
    MessageParameters: System.String[]
    MachineName: GTM-S-01034
    CreatedDateTime: 22/01/2018 10:26:27 a. m.
    AppDomainName: DWAuthenticationServer.exe
    ThreadIdentityName: 
    WindowsIdentityName: GRUPOTERRA\admin.gt
    DWUserLogLevel: Unknown
    TranslatedMessage: Error while inserting into table 'DWUserToGroup'.
Exception : Column count doesn't match value count at row 2
    Message: Error while inserting into table 'DWUserToGroup'.
Exception : Column count doesn't match value count at row 2
    TargetSite: Void CreateRows(System.Collections.Generic.IEnumerable`1[TTable])
    HResult: -2146232832

      2) Exception Information

     Exception Type: DocuWare.Common.Exceptions.DWDBException
    Sql: INSERT INTO `DWUserToGroup` (`checksum` ,`guid` ,`gid` ) VALUES (_utf8'Temp Checksum', '5eb6383f-b4cf-4bac-acf8-92224dadc8b0', ?AP_0), (_utf8'Temp Checksum', '42abd387-cbd9-4702-84d8-2b13a6ade585', ?AP_1, ?AP_2), (_utf8'Temp Checksum', 'f966e162-80b3-4953-851e-c195403ef982', ?AP_3, ?AP_4), Transaction: 13943481, Parameters  | AP_4:Int32/1 | AP_2:Int32/1 | AP_0:Int32/1 | AP_3:Int32/1440 | AP_1:Int32/1390
    MessageID: Column count doesn't match value count at row 2
    MessageParameters: NULL
    MachineName: GTM-S-01034
    CreatedDateTime: 22/01/2018 10:26:27 a. m.
    AppDomainName: DWAuthenticationServer.exe
    ThreadIdentityName: 
    WindowsIdentityName: GRUPOTERRA\admin.gt
    Additional information:
    Inner stack trace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at DocuWare.DAL.DataAccess.DataCommand.ExecuteNonQuery(IDbConnection dbConnection, IDbTransaction transaction)
   at DocuWare.DAL.DataAccess.BaseSQLBuilder.ExecuteNonQuery(String sql, Boolean longCommand, Int32 contextId)
    DWUserLogLevel: Unknown
    TranslatedMessage: Column count doesn't match value count at row 2
    Message: Column count doesn't match va

--------------------------------------------

Any idea why this is happening?

 

Thanks

 

Chris

Publié Mon, 22 Jan 2018 17:07:35 GMT par Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

You need to open a support request. It appears that the table is corrupt in some way.

 

 

Phil Robson
Senior Director Support - Americas

 

You must be signed in to post in this forum.