Error message when you try to upgrade Groove Enterprise Management Server (EMS) 2.x to Groove EMS 3.X: "Line 1:Incorrect Syntax near <character>" (922159)
The information in this article applies to:
- Groove Enterprise Management Server 3.0
- Groove Enterprise Management Server 3.1
SYMPTOMSWhen you try to upgrade Groove Enterprise Management Server (EMS) 2.x to Groove EMS 3.X, the upgrade fails. Additionally, you may receive the following error message: [Microsoft][ODBC SQL ServerDriver][SQL Server]Line 1:Incorrect Syntax near 'character' Note Character is a placeholder for the specific noncompliant character or characters that are used. CAUSEThis issue occurs when the Groove EMS 3.x database has a name that starts with a number (for example, "1815upgrade"). RESOLUTIONTo resolve this issue, make sure that the database name complies with the rules that are defined for identifier names in databases that use a compatibility level of 80. These rules are as follows: - The first character must be one of the following characters:
- A letter that is defined by the Unicode Standard 2.0
- One of the following symbols: _ @ #
Note The latter two symbols have special meanings when they are located at the start of an identifier.
- Subsequent characters can be any of the following characters:
- Letters that are defined by the Unicode Standard 2.0
- Decimal numbers from either Basic Latin or other national scripts
- The following symbols: $ _ @ #
- The identifier must not be a Transact-SQL reserved word. Microsoft SQL Server reserves both the uppercase and lowercase versions of reserved words.
- Embedded spaces or other special characters must not be included.
| Modification Type: | Major | Last Reviewed: | 7/6/2006 |
|---|
| Keywords: | kbtshoot kbExpertiseInter KB922159 kbAudKnowledgeWorker kbAudITPRO |
|---|
|