PM98152: SDAP 7.1 SENDING WRONG CREDENTIALS TO ORACLE 11G WHEN DATA SOURCE IS ENCRYPTED WITH ORACLE ADVANCED SECURITY

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 have configured both Oracle 11.g instance, encrypting the
    data with Oracle Advanced Security.  You have configured the
    SPSS Statistics Server and Data Access Pack 7.1 for use with
    Oracle and encrypted data.  When you try to connect to this
    datasource, you receive an error ORA-01017 Invalid
    username/password; login denied.  Upon inspecting your Oracle
    Server side logs you see that the SPSS Data Access Pack 7.1 is
    supplying the user credentials for the Linux user  of Statistics
    Server and not the Oracle user credentials supllied in the
    odbc.ini or in the Database wizard.
    

Local fix

  • This issue will be addressed in a  future release
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of the SPSS Data Access Pack 7.1, prior to 2014-08-18  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SDAP 7.1 SENDING WRONG CREDENTIALS TO ORACLE 11G WHEN DATA   *
    * SOURCE IS ENCRYPTED WITH ORACLE ADVANCED SECURITY            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to the latest version of the SPSS Data Access Pack    *
    ****************************************************************
    

Problem conclusion

  • Update to the latest version of the SPSS Data Access Pack
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM98152

  • Reported component name

    SPSS STATS SVR

  • Reported component ID

    5725A56SS

  • Reported release

    L00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-30

  • Closed date

    2014-09-17

  • Last modified date

    2014-09-17

  • 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

  • RM00 PSN

       UP

  • RM00 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics
Statistics Server

Software version:

21.0

Reference #:

PM98152

Modified date:

2014-09-17

Translate my page

Machine Translation

Content navigation