xflow throws error CMS0010-failed to create or join the chatroom

Document ID : KB000122176
Last Modified Date : 30/11/2018
Show Technical Document Details
Issue:
Migration to SDM 17.1.01. (xFlow  (collaboration and search server))
Installation run without any error.
Logon to xFlow; type/Chat @contatname* in the ticket command line the error message:

CMS0010 - failed to create or join the chatroom 

is displayed.

The OpenFire.log show the error  "NSLOOKUP timeout". 
Environment:
Window 2016.
MS-SQ 2012
SDM 17.1   Advanced Availablility but also classic.
xFlow
Cause:
missing table: ofmucservice 
Resolution:
add missing table: ofmucservice 

CMS0010 - failed to create or join the chatroom 
and for the error message recorded in the log "NSLOOKUP timeout". 
With the missing table ofmucservice and server entry missed,