This section contains additional writeups for Adaptive Server Enterprise Create Utility errors.
16
Cannot create an object of this type in system-created proxy database.
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.
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.
12.0 and later
