PM78032: USING IBM SPSS STATISTICS 21.0 TO IMPORT A TABLE FROM POSTGRESQL THAT IS IN THE "PUBLIC" SCHEMA WILL FAIL WITH AN ERROR.

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 are using IBM SPSS Statistics 21.0 to import data from a
    PostgreSQL database using ODBC.  The table you wish to import is
    in the PostgreSQL "public" schema.  In the Statistics Database
    Wizard, you connect successfully to the database, select the
    desired table in the "Available Tables" area and try to bring it
    over to the "Retreive Fields in this order" area.  You receive
    the following error in a pop-up dialog:
    
    Table 'postgres.public.<tablename>' has no columns and will not
    be shown.
    [OK]
    
    You know the table in question is properly constructed and
    populated, and in fact importing the same exact table worked
    fine in an earlier version of IBM SPSS Statistics.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users importing PostGreSQL database                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You are using IBM SPSS Statistics 21.0 to import data from a *
    * PostgreSQL database using ODBC.  The table you wish to       *
    * import is                                                    *
    * in the PostgreSQL "public" schema.  In the Statistics        *
    * Database                                                     *
    * Wizard, you connect successfully to the database, select the *
    * desired table in the "Available Tables" area and try to      *
    * bring it                                                     *
    * over to the "Retreive Fields in this order" area.  You       *
    * receive                                                      *
    * the following error in a pop-up dialog:                      *
    *                                                              *
    * Table 'postgres.public.<tablename>' has no columns and will  *
    * not                                                          *
    * be shown.                                                    *
    * [OK]                                                         *
    *                                                              *
    * You know the table in question is properly constructed and   *
    * populated, and in fact importing the same exact table worked *
    * fine in an earlier version of IBM SPSS Statistics.           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue has been addressed in IBM SPSS Statistics 21      *
    * FixPack 1                                                    *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in IBM SPSS Statistics 21 FixPack
    1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM78032

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    L00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-28

  • Closed date

    2013-03-19

  • Last modified date

    2013-03-19

  • 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 STATISTICS

  • Fixed component ID

    5725A54ST

Applicable component levels

  • RL00 PSN

       UP

  • RL00 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

21.0

Reference #:

PM78032

Modified date:

2013-03-19

Translate my page

Machine Translation

Content navigation