Database Creation Error when creating a new WEM database using a hyphen ("-") in the database name

Database Creation Error when creating a new WEM database using a hyphen ("-") in the database name

book

Article ID: CTX228086

calendar_today

Updated On:

Description

When attempting to create a new WEM database when using a hyphen ('-') in the name, an error appears saying "Database Creation Error".

User-added image

The Citrix WEM Database Management Utility Debug Log contains the following Exception:

Exception -> CreateVuemdb.Run() : SqlDatabaseHelper.() connection Error : 102 | Incorrect syntax near '-'.


 

Resolution

2 SOLUTIONS EXIST:
  1. Do not use a hyphen ('-') in the name of the database when creating a new database via the WEM Database Management Utility.
  2. Pre-create the WEM database with a hyphen ('-') in the name and use the WEM Database Management Utility to "Create Database" using the name of the database with the hyphen

Problem Cause

WEM is unable to create a new database in SQL when the name of the database contains a hyphen ('-')