IBM Support

IC79793: ESRI ARCGIS APPLICATION FAILS WITH WITH GSE0219 ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a user without DATAACCESS authority runs an application
    that calls the st_register_spatial_column stored procedure, it
    fails with with the error "GSE0219 an EXECUTE IMMEDIATE
    statement failed. SQL0551N "userid" does not have the required
    authorization or privilege to perform operation "UPDATE" on
    object "DB2GSE.GSE_GEOMETRY_COLUMNS".
    

Local fix

  • Grant UPDATE permission on the table DB2GSE.GSE_GEOMETRY_COLUMS
    to PUBLIC
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Any users of Esri ArcGIS software after upgrading to V9.7    *
    * fixpack 5                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When a user without DATAACCESS authority runs an application *
    * that calls the st_register_spatial_column stored procedure,  *
    * it                                                           *
    * fails with with the error "GSE0219 an EXECUTE IMMEDIATE      *
    * statement failed. SQL0551N "userid" does not have the        *
    * required                                                     *
    * authorization or privilege to perform operation "UPDATE" on  *
    * object "DB2GSE.GSE_GEOMETRY_COLUMNS".                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply DB2 V9.7 fixpack 6                                     *
    ****************************************************************
    

Problem conclusion

  • Apply DB2 V9.7 fixpack 6
    

Temporary fix

  • Grant UPDATE permission on the table DB2GSE.GSE_GEOMETRY_COLUMS
    to PUBLIC
    

Comments

APAR Information

  • APAR number

    IC79793

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-14

  • Closed date

    2012-06-04

  • Last modified date

    2012-06-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC79793

Modified date: 04 June 2012