PM71226: Extracting data from DB2 and saving as a CSV file fails with ERRORCODE=-4476

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Abstract:
    
    Attempts to extract data from DB2 and save as CSV fails with
    ERRORCODE=-4476 when using IBM Rational Application Developer
    v8.5.
    
    Problem:
    
    When connecting to DB2 10.1 database (default SAMPLE database)
    from data perspective, and right click one of the table ? Data ?
    Extract ? save as csv, it will fail with error below.
    
    If connecting to same database from Rational Application
    Developer v8.0.4 and follow the same steps, the error doesn't
    occur and the data is saved as CSV as expected.
    
    !ENTRY org.eclipse.datatools.sqltools.data.core 4 0 2012-07-12
    11:33:41.803
    !MESSAGE [jcc][10103][10941][4.8.86] Method executeQuery cannot
    be used for update. ERRORCODE=-4476, SQLSTATE=null
    !STACK 0
    com.ibm.db2.jcc.am.SqlException: [jcc][10103][10941][4.8.86]
    Method executeQuery cannot be used for update. ERRORCODE=-4476,
    SQLSTATE=null
    
    Local fix:
    
    There is no known workaround at this time
    

Local fix

Problem summary

  • After connecting to a DB2 database in the Data Source Explorer.
    Right Click on the table > Data > Extract > Save as csv. This
    action will fail with "Method executeQuery cannot be used for
    update. ERRORCODE=-4476"
    

Problem conclusion

  • In some cases the query used to read the table text from the
    catalog is not generated properly causing the query to fail.
    
    The fix for this APAR is included in Rational Application
    Developer v8.5.1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM71226

  • Reported component name

    RATL APP DEV WI

  • Reported component ID

    5724J1901

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-20

  • Closed date

    2012-12-17

  • Last modified date

    2012-12-17

  • 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

    RATL APP DEV WI

  • Fixed component ID

    5724J1901

Applicable component levels

  • R851 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Application Developer for WebSphere Software

Software version:

8.5

Reference #:

PM71226

Modified date:

2012-12-17

Translate my page

Machine Translation

Content navigation