PM82798: ADD NEW FIELDS TO AN EXISTING TABLE IN A POSTGRESQL DATABASE DOESN'T 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 export data
    from SPSS to an existing database table. The database you use is
    PostGreSQL for Linux.
    However, the SAVE TRANSLATE syntax does not work. You will get
    errors as on the example below:
    
    > Error # 6492
    > The ODBC subsystem showed an error that prevents Execution
    SAVE TRANSLATE ODBC application.
    > Executing this command stops.
    > [520] [ODBC PostgreSQL Wire Protocol driver] [PostgreSQL]
    ERROR: syntax error at or near "(" (position 30; scan.l File,
    Line 1001; Routine scanner_yyerror ;).
    
    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 export     *
    * data                                                         *
    * from SPSS to an existing database table. The database you    *
    * use is                                                       *
    * PostGreSQL for Linux.                                        *
    * However, the SAVE TRANSLATE syntax does not work. You will   *
    * get                                                          *
    * errors as on the example below:                              *
    *                                                              *
    * > Error # 6492                                               *
    * > The ODBC subsystem showed an error that prevents Execution *
    * SAVE TRANSLATE ODBC application.                             *
    * > Executing this command stops.                              *
    * > [520] [ODBC PostgreSQL Wire Protocol driver] [PostgreSQL]  *
    * ERROR: syntax error at or near "(" (position 30; scan.l      *
    * File,                                                        *
    * Line 1001; Routine scanner_yyerror ;).                       *
    ****************************************************************
    * 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

    PM82798

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    K00

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

  • Fixed component ID

    5725A54ST

Applicable component levels

  • RL00 PSN

       UP

  • RL00 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

20.0

Reference #:

PM82798

Modified date:

2013-03-15

Translate my page

Machine Translation

Content navigation