PI12847: UNABLE TO MODIFY EXISTING SQL SERVER DATABASE TABLE USING STATISTICS CLIENT 22.

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

  • Using IBM SPSS Statistics Client 22, an end-user is able to
    create new tables in an existing SQL Server database without
    problems. Problem occurs when attempting to modify an existing
    table using the following options in the File > Export to
    Database wizard:
    * Replace values in existing fields
    * Add new fields to an existing table
    * Append new records to an existing table
    * Drop an existing table and create a new table of the same name
    
    After selecting a table to modify, SPSS Statistics returns the
    following message:
    "The selected table <name of table> contains no fields. Select a
    different table"
    
    Using the 'sa' administrator account of SQL Server also produces
    this problem. This should rule out database permissions as a
    root cause of this problem.
    
    Attempting to do the same procedure in Statistics 21 FP2 is
    successful. This is using Stats 21 FP2 and ODBC SDAP 7.1. This
    should rule out the ODBC driver as the root cause.
    
    IBM SPSS Statistics 22 should behave in the same manner as
    previous versions and allow an end-user to modify an existing
    database table.
    

Local fix

  • This issue has been reported to the IBM SPSS Statistics
    development team and will be addressed in the next Fix Pack.
    Please refer to the Fix Pack schedule at
    http://www.ibm.com/support/docview.wss?uid=swg21599157 for
    information on upcoming Fix Packs.
    
    At this stage, the only available workaround is to create new
    tables when exporting your updated data. Then use a DROP TABLE
    command to delete the table containing the previous version of
    your data.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This affects all users of IBM SPSS Statistics                *
    * reading/writing to a SQL Server relational database.         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * UNABLE TO MODIFY EXISTING SQL SERVER DATABASE TABLE USING    *
    * STATISTICS CLIENT 22.                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM SPSS Statistics 23 in order to resolve *
    * this problem.                                                *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in IBM SPSS Statistics 23 and the
    next Fix Pack of IBM SPSS Statistics 22.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI12847

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    M00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-03-02

  • Closed date

    2015-03-09

  • Last modified date

    2015-03-09

  • 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

  • RM00 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

22.0

Reference #:

PI12847

Modified date:

2015-03-09

Translate my page

Machine Translation

Content navigation