Server Error Messages 11100 - 11199

Number

Severity

Text and Explanation

11101

16

Cannot grant the role '%.*s' because it contains role '%.*s' which is mutually exclusive with role '%.*s' which is possessed by grantee '%.*s'. Remove the exclusivity and try again. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11102

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at activation or membership level with role '%.*s' (contained by role '%.*s' which is the grantee role or the ancestor role of grantee). Remove the exclusivity and try again.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11103

16

Cannot grant the roles '%.*s' and '%.*s' because they are mutually exclusive at activation or membership level. Remove the exclusivity and try again. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11104

16

Cannot grant the role '%.*s' to role '%.*s' because it will result in cycle.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11105

16

No such user/role '%.*s' exists. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11106

16

Failed to grant role '%.*s' to grantee '%.*s' because failed to expand the role to be granted. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11107

10

All the roles specified to be granted in the grant role statement have already been granted to grantee '%.*s'. 

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

11108

10

The result of the REVOKE ROLE command will take effect once the user logs out and then logs in again. 

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

11109

14

You must have SSO authorization to grant/revoke user defined roles. 

Explanation: You do not have permission to execute this command. Have the object owner or a user with the needed role run this command.

11110

14

You must be in the master database to GRANT/REVOKE ROLE. Contact the System Administrator (SA) if you do not have permission to run USE master. 

Explanation: You do not have permission to execute this command. Have the object owner or a user with the needed role run this command.

11111

16

No such role '%.*s' exists.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11112

16

You must have SSO authorization to create User Defined Roles.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11113

16

You must be in the master database to run CREATE ROLE command. Contact the System  Administrator (SA) if you do not have permission to run USE master. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11114

16

A role with name '%.*s' already exists in this server.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11115

16

The role '%.*s' was not dropped because it still has privilege granted to it. Use the 'WITH OVERRIDE' option to drop it. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11116

16

Cannot drop role '%.*s' because it does not exist in this server.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11117

16

You must have SSO authorization to drop User Defined Roles. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11118

16

You must be in the master database to run DROP ROLE command. Contact the System Administrator (SA) if you do not have permission to run USE master. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11119

16

The role '%.*s' was not dropped because it is one of the system roles.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11120

16

You must have SSO authorization to use ALTER ROLE to define roles exclusivity.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11121

16

You must be in the master database to run ALTER ROLE. Contact the System Administrator (SA) if you do not have permission to run USE master. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11122

16

Cannot drop the '%.*s' exclusivity between role '%.*s' and '%.*s' since it does not exist in this server. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11123

16

Operation failed because the user '%.*s' has been granted both role '%.*s' and role '%.*s'. Revoke one of the roles from the user and rerun this command. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11124

16

Operation failed because role '%.*s' has been granted both role '%.*s' and role ' %.*s'. Revoke one of the granted roles from role '%.*s' and rerun this command.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11125

10

 Warning: User '%.*s' (process ID '%d') has both roles '%.*s' and '%.*s' enabled. This violates the '%.*s' exclusivity just added. Terminate the user's process to remove the violation.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. (Not raised in 11.9.2)

11126

16

Cannot add the '%.*s' exclusivity between role '%.*s' and role '%.*s' because it already exists for this server. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11127

16

The role named as '%.*s' does not exist for this server. Check the name and resubmit the ALTER ROLE command  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11131

16

Failed to expand the role with srid '%d' because this exceeds the maximum role limit of '%d'. Please revoke/disable roles you don't require and then rerun your command. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11132

16

SQL Server failed to execute the built-in function %s because it failed to expand the role '%.*s'.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11133

16

%s: unknown option: '%.*s'. Use either '%s' or '%s' as an option value.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11134

16

You already have the role '%.*s' active.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11136

16

You have reached the limit on the number of roles you can enable per session. Increase the value of the configuration parameter 'max roles enabled per user' and rerun your command.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11137

18

Failed to add the role '%.*s' into the current database catalogs.  

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator.

11138

16

Failed to create role '%.*s', because this exceeds the maximum number roles limit  of '%d'. Please delete roles you don't need and rerun your command. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11141

16

Password required to set role '%.*s' on.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11142

16

You specified the wrong password for enabling role '%.*s'. Try again with the correct password.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11143

16

The password specified in CREATE/ALTER ROLE command is too short. The minimum length of passwords is %d characters. Try again with a password that is %d or more characters in length.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11145

16

Command failed because no password exists for role '%.*s'.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11146

16

Password already exists for role '%.*s'. Drop the existing password and then add the new password.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11148

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at activation or membership level with role '%.*s' (which is the ancestor of role '%.*s' in the hierarchy). Remove the exclusivity and try again. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11149

16

Operation failed. Role '%.*s' is contained by/contains role '%.*s'. Revoke the granted role from role '%.*s' or '%.*s' and rerun the command.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11150

16

Operation failed. Role '%.*s' is mutually exclusive at membership or activation level with role '%.*s'. Remove the exclusivity and try again. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11151

16

Cannot grant the role '%.*s' because it is mutually exclusive with role '%.*s' which is possessed by grantee '%.*s'. Remove the exclusivity and try again. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11152

16

Operation failed. Role '%.*s' is mutually exclusive at activation or membership level with role '%.*s' (contained by role '%.*s' which is the grantee role or the ancestor role of grantee). Remove the exclusivity and try again. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11153

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at membership or activation level with role '%.*s'. Remove the exclusivity and try again.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11154

16

Operation failed. Role '%.*s' has not been granted to role '%.*s'.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11155

16

Operation failed. Role '%.*s' has not been granted to user '%.*s'.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11156

16

Operation failed. Role '%.*s' is mutually exclusive at activation or membership level with role '%.*s' (which is the ancestor of role '%.*s' in the hierarchy). Remove the exclusivity and try again. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11157

16

Operation failed. Role '%.*s' is mutually exclusive at membership level with role  '%.*s' (which along with role '%.*s' has been granted to user '%.*s'). Remove the exclusivity and try again.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11158

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at membership level with role '%.*s' (which along with role '%.*s' has been granted to user '%.*s'). Remove the exclusivity and try again.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11159

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at activation or membership level with role '%.*s' (contained by role '%.*s'). Remove the exclusivity and try again.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11160

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at activation or membership level with role '%.*s'. Remove the exclusivity and try again.  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11161

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at activation level with role '%.*s' (contained by role '%.*s', which has already been enabled).  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11162

16

Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at activation level with role '%.*s' (which has already been enabled).  

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11165

16

A user or group with the name '%.*s' already exists in this Server. 

Explanation: Informational: A role name has to be unique across the entire database.

11166

16

User '%.*s' is currently logged in. The revocation of roles from users that are currently logged in is not allowed. 

Explanation: The revocation of roles from users that are currently logged in is not allowed as these users may already have activated the roles being revoked in their current login session.

11167

16

The role 'sybase_ts_role' cannot be granted to other roles. 

Explanation: sybase_ts_role is not meant for general or widespread use. Only the SA or another responsible user should use it, or permit its use, in limited situations and only as recommended by Sybase.

11168

16

The role ’%.*s’ does not have a password. The value you specified for minimum password length will be used when a password is added to the role. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11169

16

All overrides for the ’%.*s’ option have been removed.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11170

16

Invalid value specified for ’%.*s’ attribute. Try again with a valid value. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11171

16

The specified password does not have any numeric characters. New passwords must have at least one numeric character. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11172

14

The role ’%.*s’ is locked. Contact a user with System Security Officer(SSO) role. 

Explanation: You do not have permission to execute this command. Have the object owner or a user with the needed role run this command.

11173

16

Your password will expire in %.*s days.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11174

16

Operation failed because it could not be performed on both companions. Retry later. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

11175

16

Operation failed because the limit for maximum number of roles that can be synchronized on companions is ’%d’. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.