PM82800: IMPORTING FROM POSTGRESQL DATABASE DOES NOT WORK

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