GSE1000-1999
| GSE Message ID | Message | Explanation | User Response |
|---|---|---|---|
|
GSE1000N |
The spatial operation operation-name failed under user id user-id. |
You requested this operation under a user id that does not hold the privilege or authority to perform the operation. |
Consult the Spatial documentation to find out what the required authorization for the operation is. msgcode: -1000 sqlstate: 38S50 |
|
GSE1001N |
The specified value, value, is not valid for the argument-name argument. |
The value value that you entered for argument argument-name was incorrect or misspelled. |
Consult the Spatial documentation to find out what value or range of values you need to specify. msgcode: -1001 sqlstate: 38S51 |
|
GSE1002N |
A required argument, argument-name, was not specified. |
The requested operation cannot be completed successfully because an argument that it requires was not specified. |
Specify argument argument-name with the value that you want; then request the operation again. msgcode: -1002 sqlstate: 38S52 |
|
GSE1003N |
The spatial column, schema-name.table-name.column-name, could not be registered with the spatial reference system srs-name because it is already registered with another spatial reference system. |
A spatial reference system is already registered with the spatial column. It cannot be registered again unless it is unregistered first. |
Either unregister the spatial column and then register it with the spatial reference system you want or do not attempt to register it again. msgcode: -1003 sqlstate: 38S53 |
|
GSE1004N |
The specified geocoder, geocoder-name, is already registered. |
This geocoder is already registered. It cannot be registered again unless it is unregistered first. |
Register the geocoder with a unique name, or unregister the existing geocoder first and then try the operation again. msgcode: -1004 sqlstate: 38S54 |
|
GSE1005N |
Geocoding has already been set up for the spatial column named schema-name.table-name.column-name. |
Geocoding has already been set up for this column. Geocoding cannot be set up again unless the current setup is removed first. |
Remove the existing geocoding setup, or choose a column for which geocoding is already set up. msgcode: -1005 sqlstate: 38S55 |
|
GSE1006N |
The spatial column schema-name.table-name.column-name is not registered. |
This spatial column was not registered with a spatial reference system. Therefore, it cannot be unregistered. |
Specify a spatial column that is already registered, or do not attempt to unregister the column. msgcode: -1006 sqlstate: 38S56 |
|
GSE1007N |
The specified geocoder geocoder-name is not registered. |
A geocoder named geocoder-name has not been registered. Therefore, it cannot be unregistered. |
Specify a geocoder that is already registered, or do not attempt to unregister the geocoder. msgcode: -1007 sqlstate: 38S57 |
|
GSE1008N |
A geocoder whose numeric identifier is geocoder-id is not registered. |
A geocoder whose numeric identifier is geocoder-id is not registered. It cannot be unregistered. |
Specify a geocoder that is already registered, or do not attempt to unregister the geocoder. msgcode: -1008 sqlstate: 38S58 |
|
GSE1009N |
A table named schema-name.table-name does not exist. |
The requested operation cannot be completed successfully because the table schema-name.table-name does not exist. |
Specify a valid table name and retry the operation. msgcode: -1009 sqlstate: 38S59 |
|
GSE1010N |
A spatial column named schema-name.table-name.column-name does not exist. |
The requested operation cannot be completed successfully because schema-name.table-name.column-name does not identify an existing column. |
Specify a valid spatial column name and retry the operation. msgcode: -1010 sqlstate: 38S5A |
|
GSE1011N |
A data type named schema-name.type-name does not exist. |
The requested operation cannot be completed successfully because a data type schema-name.type-name does not exist. |
Specify a valid data type name and retry the operation. msgcode: -1011 sqlstate: 38S5B |
|
GSE1012N |
The database has not been enabled for spatial operations. |
The requested operation cannot be completed successfully because the database has not been enabled for spatial operations and, therefore, a spatial catalog has not been created. |
Enable the database for spatial operations. msgcode: -1012 sqlstate: 38S5C |
|
GSE1013N |
The database is already enabled for spatial operations. |
The database is already enabled for spatial operations. It cannot be enabled again. |
Verify that the database has been enabled as you expected. If necessary, disable the database. msgcode: -1013 sqlstate: 38S5D |
|
GSE1014N |
The spatial operation was unable to register a column named schema-name.table-name.column-name because it is not a spatial column. |
Either this column does not have a spatial data type, or it does not belong to a local table. |
Define a spatial data type for column schema-name.table-name.column-name, or specify a column with a spatial data type as declared type. msgcode: -1014 sqlstate: 38S5E |
|
GSE1015N |
A spatial reference system named srs-name does not exist. |
The requested operation cannot be completed successfully because a spatial reference system with the name srs-name does not exist. |
Specify an existing spatial reference system and retry the operation. msgcode: -1015 sqlstate: 38S5F |
|
GSE1016N |
A spatial reference system whose numeric identifier is srs-id does not exist. |
The requested operation could not be completed successfully because a spatial reference system with the specified numeric identifier srs-id does not exist. |
Specify an existing spatial reference system identifier and retry the operation. msgcode: -1016 sqlstate: 38S5G |
|
GSE1017N |
A coordinate system named coordsys-name already exists. |
A coordinate system named coordsys-name already exists. Another coordinate system with the same name cannot be created. |
Specify a unique name for the new coordinate system. msgcode: -1017 sqlstate: 38S5H |
|
GSE1018N |
A coordinate system named coordsys-name does not exist. |
The requested operation cannot be completed successfully because a coordinate system with the name coordsys-name does not exist. |
Specify the name of an existing coordinate system. msgcode: -1018 sqlstate: 38S5I |
|
GSE1019N |
No values of the spatial coordinate system coordsys-name are specified. |
You attempted to alter the coordinate system coordsys-name, but did not specify any new values. |
Specify at least one new value for the coordinate system. msgcode: -1019 sqlstate: 38S5J |
|
GSE1020N |
A spatial reference system named srs-name already exists. |
A spatial reference system named srs-name already exists. Another spatial reference system with the same name cannot be created. |
Specify a unique name for the spatial reference system to be created and retry the operation. msgcode: -1020 sqlstate: 38S5K |
|
GSE1021N |
A spatial reference system named srs-name does not exist. |
The requested operation cannot be completed successfully because a spatial reference system with the name srs-name does not exist. |
Specify a name of an existing spatial reference system and retry the operation. msgcode: -1021 sqlstate: 38S5L |
|
GSE1022N |
A spatial reference system whose numeric identifier is srs-id does not exist. |
The requested operation cannot be completed successfully because a spatial reference system with the numeric identifier srs-id does not exist. |
Specify an existing numeric identifier for the spatial reference system. msgcode: -1022 sqlstate: 38S5M |
|
GSE1023N |
A coordinate system whose numeric identifier is coordsys-id does not exist. |
The requested operation cannot be completed successfully because a coordinate system with the numeric identifier coordsys-id does not exist. |
Specify an existing numeric identifier for the coordinate system and retry the operation. msgcode: -1023 sqlstate: 38S5N |
|
GSE1024N |
No values of the spatial reference system srs-name are specified. |
You attempted to alter the spatial reference system srs-name, but did not specify any new values. |
Specify at least one new value for the spatial reference system and then try the operation again. msgcode: -1024 sqlstate: 38S5O |
|
GSE1025N |
A geocoder whose function name is schema-name.function-name could not be found in the database. |
The requested operation cannot be completed successfully because the operation could not locate a function named schema-name.function-name for the geocoder. |
Specify a geocoder with an existing function name or create the function, then try the operation again. msgcode: -1025 sqlstate: 38S5P |
|
GSE1026N |
The specified number of default parameter values (number1 values), does not match with the number of default parameter values (number2 values) that the specified geocoder requires. |
The specified geocoder could not be registered because you did not specify the complete list for all the parameter values that the geocoder requires. |
Correct the number of default parameter values. Specify a default value for each of the parameters of the geocoder or specify a null value for the default parameter values. msgcode: -1026 sqlstate: 38S5Q |
|
GSE1027N |
The specified number of parameter description values (number1 values) does not match with the number of parameter description values (number2 values) that the specified geocoder requires. |
The specified geocoder could not be registered because you did not specify the complete list for all the parameter description values that the geocoder requires. |
Specify a description for each of the parameters of the geocoder, or specify a null value for the parameter descriptions. msgcode: -1027 sqlstate: 38S5R |
|
GSE1028N |
A geocoder named geocoder-name does not exist. |
The requested operation cannot be completed successfully because a geocoder with the name geocoder-name does not exist. |
Specify an existing geocoder name or register the geocoder with the name that you specified and then try the operation again. msgcode: -1028 sqlstate: 38S5S |
|
GSE1029N |
Geocoding has not been set up for a column named schema-name.table-name.column-name. |
The requested operation cannot be completed successfully because geocoding has not been set up for the column named schema-name.table-name.column-name. |
Set up geocoding for the specified column, or correct the table schema, table name, and column name. msgcode: -1029 sqlstate: 38S5T |
|
GSE1030N |
Auto-geocoding is enabled for column schema-name.table-name.column-name and the geocoding setup cannot be removed. |
Auto-geocoding have been enabled for the column named schema-name.table-name.column-name. Therefore, the geocoding setup for this column cannot be removed. |
Disable auto-geocoding for the column. msgcode: -1030 sqlstate: 38S5U |
|
GSE1031N |
Auto-geocoding for a column named schema-name.table-name.column-name is not enabled. |
Auto-geocoding has not been enabled for column schema-name.table-name.column-name. Therefore, auto-geocoding cannot be disabled for this column. |
Specify a correct column name on which auto-geocoding is enabled. msgcode: -1031 sqlstate: 38S5V |
|
GSE1032N |
Auto-geocoding for a column named schema-name.table-name.column-name is already enabled. |
Auto-geocoding has already been enabled for the column named schema-name.table-name.column-name. Auto-geocoding cannot be enabled again for this column unless it is disabled first. |
Specify a correct name for a column for which (1) auto_geocoding is not enabled and (2) geocoding is set up. msgcode: -1032 sqlstate: 38S5W |
|
GSE1033N |
A geocoder whose numeric identifier is geocoder-id does not exist. |
The requested operation cannot be completed successfully because a geocoder with the numeric identifier geocoder-id does not exist. |
Specify an existing numeric identifier for the geocoder, or register a geocoder with numeric identifier geocoder-id. msgcode: -1033 sqlstate: 38S5X |
|
GSE1034N |
The parameters passed to the stored procedure do not include a parameter parameter-name. |
The SQLDA that was passed to the stored procedure is too small. It does not contain an entry for parameter parameter-name. |
Correct the parameters that are being passed to the stored procedure. msgcode: -1034 sqlstate: 38S5Y |
|
GSE1035N |
The parameter-name parameter, which is being passed to the stored procedure, has an incorrect data type. |
The data type for parameter parameter-name that is passed to the stored procedure is not correct. |
Correct the parameters that are being passed to the stored procedure. msgcode: -1035 sqlstate: 38S5Z |
|
GSE1036W |
The operation was successful. But values of certain database manager and database configuration parameters should be increased. |
The operation was successful, but spatial operations need more database and database manager resources. These resources can be obtained by increasing the values of certain database manager and database configuration parameters. |
Some configuration parameters should be increased. For example, for the database configuration, check the APPLHEAPSZ parameter. Refer to the Spatial documentation for more details. msgcode: +1036 sqlstate: 38S60 |
|
GSE1037N |
The definition of the specified coordinate system named coordsys-name is invalid. |
A coordinate system named coordsys-name cannot be created because the definition given for it is invalid. |
Specify a correct definition for the coordinate system. The function ST_EqualCoordsys can be used to verify the definition by comparing the coordinate system with itself. msgcode: -1037 sqlstate: 38S61 |
|
GSE1038N |
The WHERE clause specified for the geocoder named geocoder-name is invalid. When the spatial operation attempted to verify the clause, it encountered SQL error sql-error. |
The geocoding that you requested cannot be completed successfully because the where clause that determines which rows are to be geocoded is invalid. |
Specify a syntactically correct WHERE clause. msgcode: -1038 sqlstate: 38S62 |
|
GSE1039N |
A coordinate system identified by the specified identifier organization-coordsys-id in combination with the specified organization organization already exists. |
Your request to create a coordinate system could not be met because the combination of identifiers that you specified for the coordinate system (the name of the organization that defined the system and a number that this organization assigned to it) was not unique. Either these two values must be unique in combination, or they must be null. |
Specify a unique set of values for organization and organization-coordsys-id, or choose null values for both. msgcode: -1039 sqlstate: 38S63 |
|
GSE1040N |
A spatial reference system with the numeric identifier srs-id already exists. |
Your request to create a spatial reference system could not be met because the numeric identifier srs-id that you assigned to it already identifies another spatial reference system. A spatial reference system's identifier must be unique. |
Specify a unique numeric identifier for the spatial reference system. msgcode: -1040 sqlstate: 38S64 |
|
GSE1041N |
A coordinate system with the numeric identifier coordsys-id already exists. |
Your request to create a coordinate system could not be met because the numeric identifier coordsys-id that you assigned to it already identifies another spatial coordinate system. A spatial coordinate system's identifier must be unique. |
Specify a unique value coordsys-id for the coordinate system. msgcode: -1041 sqlstate: 38S65 |
|
GSE1042N |
A geocoder with the numeric identifier geocoder-id already exists. |
Your request to register a geocoder could not be met because the numeric identifier for the geocoder geocoder-id already identifies another geocoder. A geocoder's identifier must be unique. |
Specify a unique value for the numeric geocoder identifier. msgcode: -1042 sqlstate: 38S66 |
|
GSE1043N |
The specified grid index schema-name.index-name already exists. |
This index already exists. It must be dropped before an index with the same name can be created. |
Specify a name for the index that does not yet exist, or drop the existing index and retry the operation. msgcode: -1043 sqlstate: 38S67 |
|
GSE1044N |
The specified coordinate system coordsys-name cannot be dropped because an existing spatial reference system is based on this coordinate system. |
At least one spatial reference system exists that is based on the specified coordinate system coordsys-name. The coordinate system cannot be dropped. |
Drop all spatial reference systems that are based on the specified coordinate system. Then try to drop the coordinate system again. msgcode: -1044 sqlstate: 38S68 |
|
GSE1045N |
The specified spatial reference system srs-name cannot be dropped because a spatial column is registered with this spatial reference system. |
At least one spatial column exists that is associated with the specified spatial reference system srs-name. The spatial reference system cannot be dropped. |
Unregister all spatial columns that are associated with the specified spatial reference system. Then try to drop the spatial reference system again. msgcode: -1045 sqlstate: 38S69 |
|
GSE1046N |
The specified geocoder geocoder-name cannot be unregistered because it is used in a geocoding setup. |
At least one geocoding setup exists that uses the specified geocoder geocoder-name. The geocoder cannot be unregistered. |
Remove all geocoding setups that use the specified geocoder. Then try to unregister the geocoder again. msgcode: -1046 sqlstate: 38S6A |
|
GSE1047N |
Geocoder parameter validation failed. SQLERROR = sql-error. |
Validation of the geocoder parameters failed. The database returned sql-error. Geocoder parameters may have been specified when the geocoder was registered, during geocoding setup or both. |
Use the information in sql-error to determine which parameter is invalid. Correct the value and resubmit your request. msgcode: -1047 sqlstate: 38S6B |
|
GSE1048N |
The spatial reference system with numeric identifier srs-id is a predefined geodetic spatial reference system and cannot be altered. |
The spatial reference system was not altered. Spatial reference systems with numeric identifiers in the range 2000000000 to 2000000317 are predefined geodetic spatial reference systems and cannot be altered. |
Do not attempt to alter this spatial reference system. If a geodetic spatial reference system with a different definition is needed, you can create a new geodetic spatial reference system with the numeric identifier in the range 2000000318 to 2000001000. msgcode: -1048 sqlstate: 38SP3 |
|
GSE1049N |
The spatial reference system with numeric identifier srs-id is a predefined geodetic spatial reference system and cannot be dropped. |
The spatial reference system was not altered. Spatial reference systems with numeric identifiers in the range 2000000000 to 2000000317 are predefined geodetic spatial reference systems and cannot be dropped. |
Do not attempt to drop this spatial reference system. If a geodetic spatial reference system with a different definition is needed, you can create a new geodetic spatial reference system with the numeric identifier in the range 2000000318 to 2000001000. msgcode: -1049 sqlstate: 38SP4 |
|
GSE1050N |
The spatial column, schema-name.table-name.column-name, could not be registered. Reasoncode: reason_code. |
The geometry column cannot be registered with the spatial reference system due to one of the following reasons:
|
msgcode: -1050 sqlstate: 38SP5 |