Hello,

 

I am having difficulty getting CuteChat to run in a load balanced environment.  I have added in to the Web.Config on each server the multple server mode setting.

<add key="CuteChat.MultipleServerMode" value="true" />

 

When I try to load a page or enter a chat room I receive the following message:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'StateLogId', table 'Chat.dbo.CuteChatTempStateLog'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Forgot to mention I am running CuteChat 3.1.

I figured out what the problem was.  There was no identity set on the CuteChatTempStateLog table.  After turning on identity on the StateLogId field, load balancing started working properly. 

 

Just something to watch out for when setting up a load balanced environment. 

 

Greg

yes, It works after turning on identity.

it is safe to turning on the identity on StateLogId because single server don't use this table.

only web farm model will use this table to save sessions in this table.

 

Detailed step:

Step 1: Turn on identity

You can manually add identity to StateLogId column 

If you use SQL Script:

    ALTER   TABLE   CuteChatTempStateLog   DROP   COLUMN   StateLogId 
    GO
    ALTER   TABLE   CuteChatTempStateLog   ADD   StateLogId   INT   IDENTITY(1,1)