Home

	Expand Search

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

Create Utilities Errors (continued)

Error 12818

Error 12818

Severity

16

Error message text

Cannot create an object of this type in system-created proxy database.

Explanation

Adaptive Server's High Availability (HA) feature allows two nodes in a cluster to take over each other's workload in the event of a failure. The server that fails is called the primary, and the server that takes over the workload is the secondary. Movement of data access services from a failed primary server to a companion secondary server is known as failover.

In the HA architecture, the secondary companion is configured with proxy databases which act as placeholders; in the event of failover, proxy databases are dropped and replaced with databases mounted and recovered from the primary server.

Error 12818 is raised when you attempt to execute certain Data Definition Language (DDL) commands in a proxy database, including:

• create/drop procedure

• create/drop view

• create/drop trigger

These commands are not available in a proxy database, which is a system database reserved solely for HA use in the event of failover.

Action

No action is needed. User objects should not be placed in a proxy database.

For details about the DDL commands supported in primary and secondary servers in an HA environment, see Using Sybase Failover in a High Availability System.

Versions in which this error is raised

12.0 and later