PM82800: IMPORTING FROM POSTGRESQL DATABASE DOES NOT WORK

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • You work with IBM SPSS Statistics 20.0.0.2 Server installed on a
    Linux RedHat server. You work in distributed mode (Windows
    
    client connected to the server) and would like to import data
    from a database into SPSS Statistics. The database you use is
    
    PostGreSQL for Linux.
    However, the GET DATA syntax does not work. You will get errors
    as on the example below:
    
    > Warning. Command name: GET DATA
    > SQLExecDirect failed: [520] [ODBC PostgreSQL Wire Protocol
    driver] [PostgreSQL] ERROR: column "var00001" does not exist
    
    (Position 8; parse_expr.c File, Line 760; Routine
    transformColumnRef;)
    CACHE.
    EXECUTE.
    
    This issue was reported to IBM SPSS Development for
    investigation.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users working with PostGreSQL database                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You work with IBM SPSS Statistics 20.0.0.2 Server installed  *
    * on a                                                         *
    * Linux RedHat server. You work in distributed mode (Windows   *
    * client connected to the server) and would like to import     *
    * data                                                         *
    * from a database into SPSS Statistics. The database you use   *
    * is                                                           *
    *                                                              *
    * PostGreSQL for Linux.                                        *
    * However, the GET DATA syntax does not work. You will get     *
    * errors                                                       *
    * as on the example below:                                     *
    *                                                              *
    * > Warning. Command name: GET DATA                            *
    * > SQLExecDirect failed: [520] [ODBC PostgreSQL Wire Protocol *
    * driver] [PostgreSQL] ERROR: column "var00001" does not exist *
    *                                                              *
    * (Position 8; parse_expr.c File, Line 760; Routine            *
    * transformColumnRef;)                                         *
    * CACHE.                                                       *
    * EXECUTE.                                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue has been addressed in Statistics 21 Fix Pack 1.   *
    * Please upgrade to this version.                              *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in Statistics 21 Fix Pack 1.
    Please upgrade to this version.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM82800

  • Reported component name

    SPSS STATS SVR

  • Reported component ID

    5725A56SS

  • Reported release

    J00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-14

  • Closed date

    2013-03-15

  • Last modified date

    2013-03-15

  • 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

    SPSS STATS SVR

  • Fixed component ID

    5725A56SS

Applicable component levels

  • RL00 PSN

       UP

  • RL00 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Statistics
Statistics Server

Software version:

19.0

Reference #:

PM82800

Modified date:

2013-03-15

Translate my page

Machine Translation

Content navigation