Number
|
Severity
|
Text and Explanation
|
|---|
11201
|
16
|
A remote table definition must be defined before the `existing' option is used (object `%.*s').
Explanation: Use sp_helpobjectdef to compare
the table name on the remote server with the remote table name
mapped to the table in your command. If the remote table does not
exist, first create the table on the remote server or use create
table.
|
11202
|
16
|
Unable to create table `%.*s' because it has no remote storage location defined. Creation of local user tables is allowed only in the master and tempdb databases.
Explanation: Define the remote storage location using sp_addobjectdef,
then rerun this command.
|
11203
|
16
|
The command ’%s’ is not legal for objects of this type. External definition: %.*s
Explanation: Adaptive Server cannot perform the requested action. Rewrite
your command using a valid object, or contact the Object Owner
if the remote object should not be defined as type rpc.
|
11204
|
15
|
There is an error in the syntax of the object definition `%.*s'.
Explanation: Command failed. Check syntax and semantics of your object
definition and rewrite the command.
|
11205
|
16
|
Datatype `%s' is unsupported for server `%.*s'.
Explanation: The datatype is not supported by the server where the remote
object is located. Rewrite the command using a valid datatype.
|
11206
|
16
|
Unable to connect to server `%.*s'.
Explanation: Refer to the writeup “Unable to Access Remote Server” in
Appendix A “Troubleshooting” of the Component
Integration Services User's Guide.
|
11207
|
10
|
Warning, table definition does not contain all columns found in remote object `%.*s'; (defined: %d found: %d)
Explanation: This is an informational message. Contact the Object Owner
about the warning issued in this message.
|
11208
|
16
|
No column named `%.*s' found in remote object `%.*s'.
Explanation: If the syntax is correct, refer to the writeup “Problem
Retrieving Data From Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11209
|
16
|
Column type mismatch in remote object `%.*s' for column `%.*s'; (defined: %d found: %d).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11210
|
16
|
Column length mismatch in remote object `%.*s' for column `%.*s'; (defined %d found: %d).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshootin ” of
the Component Integration Services User's Guide.
|
11211
|
16
|
Handling of null values in remote object `%.*s' for column `%.*s' differs from that defined; (defined: `%s' found: `%s').
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11212
|
16
|
Identity attribute mismatch for column `%.*s'; (defined: `%s' found: `%s').
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11213
|
16
|
Column count mismatch in remote object `%.*s'; (defined: %d found %d).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11214
|
16
|
Remote object `%.*s' does not exist.
Explanation: If the syntax is correct, refer to the writeup “Unable
to Access Remote Object” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11215
|
16
|
Remote object `%.*s' not uniquely identified; %d objects with the same name and owner were found.
Explanation: The remote server contains more than one object with the name
specified by sp_addobjectdef. Use sp_dropobjectdef to
drop the object, and reenter the object definition with an owner
name or database name to further qualify the remote object.
|
11216
|
16
|
Internal Ct-Lib/Cs-Lib error %d: `%.*s'.
Explanation: Command failed due to an internal Adaptive Server problem.
Report the error to your System Administrator.
|
11217
|
10
|
Entered passthru mode to server `%.*s'.
Explanation: This is an informational message. No action is required.
|
11218
|
10
|
Exited passthru mode from server `%.*s'.
Explanation: This is an informational message. No action is required.
|
11219
|
17
|
Cannot open a connection to site `%.*s' because there are no free remote descriptors (RDES). Increase the configuration parameter for user connections and reboot the server.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
11220
|
16
|
Parameter cannot be NULL.
Explanation: Adaptive Server could not perform the requested action. Rewrite
the command with an entry for the parameter.
|
11221
|
16
|
No external login for suserid %d, server name `%.*s'.
Explanation: The remote server cannot be accessed with your login. Have
the Database Owner or System Administrator set up your external
login using sp_addexternlogin.
|
11222
|
12
|
Parameter %d must be datatype CHAR or VARCHAR.
Explanation: Command failed. Specify an object of the correct type.
|
11223
|
17
|
Insufficient memory is available to allocate structures needed to access a remote site.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
11224
|
16
|
Cannot open a connection to site `%.*s' because it does not have PASSTHRU or RPC capabilities.
Explanation: Use sp_helpobjectdef to verify
the object is mapped to a remote server. If the server is remote,
have the System Administrator reconfigure it to allow passthrough
connections.
|
11225
|
16
|
Server class has not been defined for `%.*s'.
Explanation: No server class has been defined for the remote server. Use sp_helpserver to
check the server definition, and have your System Administrator
correct the entry.
|
11226
|
16
|
Server class (%d) for server `%.*s' is not supported.
Explanation: An invalid server class has been defined for the remote server.
Use sp_helpserver to check the server
definition, and have your System Administrator correct the entry.
|
11227
|
16
|
Statement `%s' is unsupported by `%.*s'.
Explanation: The SQL statement uses a datatype or syntax that is not supported
by the server class of the server where the remote object resides.
Rewrite the command using correct syntax or a valid datatype.
|
11228
|
18
|
Remote text/image data length less than expected for column `%.*s'.
Explanation: Command failed due to internal Adaptive Server problem. Report
the error to your System Administrator.
|
11229
|
16
|
Unable to commit transaction on remote server %.*s.
Explanation: During a transaction involving multiple servers, the local
server was unable to broadcast a commit request to a remote server.
Work done locally as part of the transaction will be rolled back.
|
11230
|
16
|
Unable to prepare transaction on remote server %.*s.
Explanation: During a transaction involving multiple servers, the local
server was unable to broadcast a prepare request to a remote server.
A rollback request has been sent to all remote servers involved
in the transaction. Work done locally as part of the transaction
will be rolled back.
|
11231
|
16
|
Unable to rollback transaction on remote server %.*s.
Explanation: During a transaction involving multiple servers, the local
server was unable to broadcast a rollback request to a remote server.
Work done locally as part of the transaction will be rolled back.
|
11232
|
18
|
Unable to access cursor process status structure (PSS); update cannot be completed.
Explanation: Command failed due to internal Adaptive Server problem.
Report the error to your System Administrator.
|
11233
|
16
|
Column mismatch in remote object `%.*s' for column `%.*s'; (column must be defined with length >= 10 or as DATETIME).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide
|
11234
|
16
|
Column mismatch in remote object `%.*s' for column `%.*s'; (column must be defined with length >= 8 or as DATETIME).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11235
|
16
|
Column mismatch in remote object `%.*s' for column `%.*s'; (column must be defined with length >= 26 or as DATETIME).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11236
|
16
|
Update or `complex INSERT' of non-NULL TEXT/IMAGE data is unsupported by server `%.*s'. Use WRITETEXT instead.
Explanation: Adaptive Server could not perform the requested action. Modify
your command as shown in the error message.
|
11237
|
16
|
TEXT/IMAGE value too long for INSERT/UPDATE on server `%.*s'. Use WRITETEXT instead.
Explanation: Adaptive Server could not perform the requested action. Modify
your command as shown in the error message.
|
11238
|
16
|
Complex INSERT of TEXT/IMAGE data is not supported. Use WRITETEXT instead.
Explanation: Adaptive Server could not perform the requested action. Modify
your command as shown in the error message.
|
11242
|
10
|
Component Integration Services recovery started.
Explanation: This is an informational message. No action is required.
|
11243
|
10
|
Component Integration Services recovery complete.
Explanation: This is an informational message. No action is required.
|
11244
|
10
|
Deallocating text/image data for external object `%.*s'.
Explanation: This is an informational message. No action is required.
|
11245
|
10
|
Checking external objects.
Explanation: This is an informational message. No action is required.
|
11246
|
16
|
Precision or scale mismatch in remote object `%.*s' for column `%.*s'; (defined: %d,%d found: %d,%d).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11247
|
16
|
Scale mismatch in remote object `%.*s' for column `%.*s'; (defined: %d found: %d).
Explanation: Refer to the writeup “Problem Retrieving Data From
Remote Objects” in Appendix A “Troubleshooting” of
the Component Integration Services User's Guide.
|
11248
|
14
|
Remote server `%.*s' is currently configured as read only.
Explanation: You do not have permission to execute this command. Contact
the System Administrator to change permissions.
|
11249
|
10
|
Executing Partial Query Remotely
Explanation: This is an informational message generated by showplan.
No action is required.
|
11250
|
10
|
EXISTS TABLE: Executing Query Remotely
Explanation: This is an informational message generated by showplan.
No action is required.
|
11251
|
10
|
Dynamic Update
Explanation: This is an informational message generated by showplan.
No action is required.
|
11252
|
10
|
Select for Update
Explanation: This is an informational message generated by showplan.
No action is required.
|
11253
|
10
|
Dynamic Delete
Explanation: This is an informational message generated by showplan.
No action is required.
|
11254
|
10
|
Select for Delete
Explanation: This is an informational message generated by showplan.
No action is required.
|
11255
|
10
|
Remote Cursor Operation
Explanation: This is an informational message generated by showplan.
No action is required.
|
11256
|
10
|
%.*s
Explanation: This is an informational message generated by showplan.
No action is required.
|
11257
|
10
|
%.*s
Explanation: This is an informational message generated by showplan.
No action is required.
|
11258
|
11
|
No column with column id `%d' found in local table.
Explanation: Check the local table for the column not found and re-enter
the command with the correct name.
|
11259
|
10
|
Warning, no mapping for remote column named `%.*s' in local object `%.*s'.
Explanation: This is an informational message. Contact the Object Owner
about the warning issued in this message.
|
11263
|
10
|
Server Name: %.*s
Explanation: This is an informational message generated by showplan.
No action is required.
|
11264
|
10
|
Text of generated SQL:
Explanation: This is an informational message generated by showplan.
No action is required.
|
11265
|
10
|
Executing Query Remotely
Explanation: This is an informational message generated by showplan.
No action is required.
|
11266
|
16
|
The sp_columns result set returned by the remote server is incomplete. Each row must contain at least %d columns, but only %d are present.
Explanation: Command failed due to remote server problem. Report the error
to your System Administrator.
|
11267
|
16
|
Unable to create table '%.*s' on remote server; this server not configured for heterogeneous data access.
Explanation: Command failed. Contact your System Administrator to install
the Extended Enterprise Option of Adaptive Server Enterprise prior
to accessing remote servers that are not server class sql_server.
|
11268
|
16
|
Unable to insert into a text/image column because the table does not contain a unique index.
Explanation: Command failed. The table must have a unique index to execute
a select...into or insert...select command,
since the table has text or image columns and is owned by a server
of class direct_connect or sds.
|
11269
|
16
|
The optimizer could not find a unique index which it could use to retrieve the resulting timestamp value
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
11270
|
16
|
Column '%.*s' does not allow NULL. Any column defined as a parameter column for RPC tables must allow NULL. A parameter column is a column whose name begins with an underscore.
Explanation: Adaptive Server could not perform the requested action. Rewrite
the command and specify NULL in the parameter column definition.
|
11271
|
16
|
Column '%.*s' must precede all parameter columns. A parameter column is a column whose name begins with an underscore.
Explanation: Adaptive Server could not perform the requested action. Rewrite
the command and put result column definitions before parameter
column definitions-all column names that begin with an underscore
must appear at the end of the list.
|
11272
|
16
|
Action requested is not valid for remote tables (%.*s).
Explanation: Command failed due to invalid request. You cannot enter this
command using proxy tables (the command can only be used with local
tables).
|
11273
|
10
|
Encounter %d conversion errors during processing of external statistics; some rows have been ignored.
Explanation: update statistics cannot generate complete
statistics because the proxy table has columns with datatypes or
widths that are different from the corresponding column at the
remote location.
|
11277
|
16
|
Operating system error %d: ’%.*s’.
Explanation: Command failed. Check query syntax and semantics.
|
11278
|
16
|
The file at the specified path is not a directory (%.*s).
Explanation: Command failed. Check query syntax and semantics.
|
11279
|
16
|
Only the file name can be changed, and it is not included in the SET list.
Explanation: Command failed. Check query syntax and semantics.
|
11280
|
16
|
The pathname length must be 255 bytes or less.
Explanation: Command failed. Check query syntax and semantics.
|
11281
|
16
|
Cannot enable full-text search services because there is no license available.
Explanation: Command failed. Check your CIS configuration.
|
11282
|
16
|
Cannot create the file (%.*s). A file with the same name already exists.
Explanation: Command failed. Check query syntax and semantics.
|
11283
|
16
|
External file access is not enabled or not licensed.
Explanation: Command failed. Check your CIS configuration.
|
11284
|
16
|
The target of a ’select into existing table’ statement must be a proxy table.
Explanation: Command failed. Check query syntax and semantics.
|
