Symptoms
Error: "Special characters are not allowed."
Workflow Server Configuration Settings in Workspace doesn't accept the comma character for a cluster address.
Diagnoses
We are attempting to make changes to Workflow Server Configuration Settings (in Workspace) in our QA environment (and later in our Production), however we've run into an issue. We're unable to make any changes and save them. Any attempt to save is met with an error stating:
"Special characters are not allowed"
We've identified the cause as being our Server Name in the Database Settings tab. It is:
SERVERNAME,14052
The error is caused by us having a comma, which is required to specify a port.
This error is preventing us from making any changes in this menu, on any tab. We're attempting to enable the Display Worklist of Managed Users on the Advanced Settings tab, but we cannot save due to this error.
Is there a fix, a workaround or something else? If not, is there a way to enable this setting some other way (perhaps thru the database)?
Resolution
As of 4.6.8, this is a known bug. The suggested workaround is to open up the (K2 blackpearlHost ServerBinK2Server.setup) in Notepad (might have to run as administrator) and change the "Data Source" option in the following line to your address with the comma:
<Database ConnectionString="Data Source=yourserver,14052Initial Catalog=K2Integrated Security=True" />