Channels Agent Client Options dialog issue

An issue has been identified for Moxie Channels customers who are licensed for Email only (not Chat).  

Agents may not be able to save any options from the Agent Client Options dialog or the dialog box may not close when attempting to save any options changes. This issue is due to a Chat feature added in versions 9.3 and 9.4 that was expecting a certain property to exist in the database.

Adding this property manually to the database will resolve issue until a product fix is made in a future release.   

Important Notes:

  1. The SQL statement below will update the property table for any agent that has attempted to save options.

  2. If agents are added after this statement is executed, you must rerun the statement after these agents attempt to save options.

  3. All agents with the issue must be logged off while running the SQL statements.

  4. Channels services do not need to be stopped to run the SQL statement. However, stopping Channel Service will guarantee all agents are logged off.

The following SQL statement will add a required property ('MultipleChatEntry' = TRUE) to the UserProperties  table in the main Channels database for all accounts that ever logged in and attempted to change any Options.

 

The follow SQL statement will change your production database.  This should be executed by a qualified database administrator.

On main database, for the UserProperties  table:

DECLARE @ID INT DECLARE ownerid CURSOR FOR SELECT DISTINCT ownerID
                                  FROM          UserProperties
                                 WHERE      ownerID NOT IN
                                                    (SELECT     ownerID
                                                      FROM          UserProperties
                                                      WHERE      PropName = 'MultipleChatEntry') OPEN ownerid FETCH next
FROM         ownerid
INTO            @ID WHILE @@FETCH_STATUS = 0 BEGIN
                          INSERT     
                           INTO            UserProperties
VALUES     (@ID, 0, 'MultipleChatEntry', 'TRUE') FETCH NEXT
FROM         ownerid
INTO            @ID END CLOSE ownerid DEALLOCATE ownerID 

This should add an entry for each user account (shown as OwnerID in the table) called 'MultipleChatEntry' with the value set to TRUE.

If you have additional questions, please contact our Support team at 877-373-7848 (option 2) or via email at Support@gomoxie.com.