Messaging Installer Completed With Errors

Problem: When upgrading to a newer software level, you are informed of errors.

“***Error!!! Error!!!***
The Messaging installer completed with the following errors. These errors will have to 
be addressed before the services become functional.
Please refer to documentation for recovery process.
Database upgrade failed."

Explanation: This error happens when the messaging server database upgrade does not complete. The most likely reason for this is that the messaging server database had some lingering connections to a table while the upgrade was running. You can get more detailed information from the trace file located in SUP_HOME\Servers\UnwiredServer\Logs\DBUpgrader .

If you find this syntax error in the DBUpgraderTrace.log, you need to configure the cache database (CDB) with the database option quoted_identifier='ON' for all database users:

20120918T234644.977|ERROR: Syntax error near 'ENCRYPTED' on line 19
20120918T234644.980|-- Caught unexpected exception: Error creating database schema
20120918T234644.981|Got global error [Error creating database schema]

Solution:

Skip this step if you did not find the syntax error in DBUpgraderTrace.log, otherwise configure the cache database (CDB) with the database option quoted_identifier='ON' for all database users.
1. Use the dbisql tool.
2. Run this SQL statement:
```
set option quoted_identifier = 'ON'
```
Stop all Unwired Server Unwired Server services in all the application nodes.
Restart the database services in the data tier node. This is to make sure the Messaging Database has no open connections.
From the primary server node, open a Windows command window and navigate to SUP_HOME\Servers\MessagingServer\Bin.
Run the command dbupgrader –v current and make sure no error messages are displayed.
Start the Unwired Server Unwired Server service in the application node and verify it can start.