ERROR

Error executing stored procedure: db2gse

Last Published: April 25, 2020

Error Message

Trying to delete a view results in the following error -

"Error executing stored procedure: db2gse gse_unregist_layerSDE_Database
Error: 0
00000
ODBC Error: 00000
Database Error: -11
Error Message: GSE0011E Spatial Extender could not disable or unregister object "".
SQLSTATE=00000
msg_code: -11"

Cause

This is a known issue with spatial extender.

Solution or Workaround

To delete a view, the you must be the db2 admin user and issue the following command:

db2 delete from db2gse.gse_layer where layer_table ='<view-name>'

Click on the link below for more information and a fixpack that is available through IBM technical support.

    Article ID:000004580

    Software:
    • ArcMap 8 x
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic