IBM Support

JR59307: BEQUEATH CONNECTION ON PHYSICAL STANDBY IS RETURNING FALSE ERROR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • IIDR reports an "Error executing sql statement(ALTER SESSION
    SET NLS_LANGUAGE = 'AMERICAN') from physical standby (result =
    0)"
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * NONE                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Stack:                                                       *
    * 132663    2018-03-15 12:39:22.613    SHAREDSCRAPE LOG        *
    * READER:1{522}                                                *
    * com.datamirror.ts.util.oracle.OracleRedoNativeApi            *
    * logEventCallback()    Failed to execute SQL statement in     *
    * database. An error was encountered while executing an SQL    *
    * statement in database. The database error message is ' '.    *
    * Error detected in file                                       *
    * /dmbuild/jenkins/release/build-output/linux/x86/default/64/t *
    * emp/tsJava/src/com/datamirror/ts/util/oracle/dll/BequeathCon *
    * nect.c at line 1385. Refer to the preceding message(s) for   *
    * additional information. The SQL statement was 'ALTER SESSION *
    * SET NLS_LANGUAGE = 'AMERICAN''. Refer to the second level    *
    * text of this error message. Try to fix the problem(s) based  *
    * on the error information provided.                           *
    * 132664    2018-03-15 12:39:22.613    SHAREDSCRAPE LOG        *
    * READER:1{522}    com.datamirror.ts.eventlog.EventLogger      *
    * logActualEvent()    Event logged: ID=2919 MSG=IBM InfoSphere *
    * Data Replication daemon has encountered an error message.    *
    * Failed to execute SQL statement in database. An error was    *
    * encountered while executing an SQL statement in database.    *
    * The database error message is ' '. Error detected in file    *
    * /dmbuild/jenkins/release/build-output/linux/x86/default/64/t *
    * emp/tsJava/src/com/datamirror/ts/util/oracle/dll/BequeathCon *
    * nect.c at line 1385. Refer to the preceding message(s) for   *
    * additional information. The SQL statement was 'ALTER SESSION *
    * SET NLS_LANGUAGE = 'AMERICAN''. Refer to the second level    *
    * text of this error message. Try to fix the problem(s) based  *
    * on the error information provided.                           *
    *                                                              *
    * Cause:                                                       *
    * The BequeathConnection.c was always returning the error      *
    * incorrectly, even for the successful connection and          *
    * execution of SQL.                                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IIDR 11.4.0.0-5057 for all LUW Engines or later   *
    ****************************************************************
    

Problem conclusion

  • Upgrading to IIDR 11.4.0.0-5057 for all LUW Engines or later
    will fix the issue
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR59307

  • Reported component name

    IS CDC ORACLE

  • Reported component ID

    5725E30OR

  • Reported release

    B40

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-21

  • Closed date

    2019-01-25

  • Last modified date

    2019-01-25

  • 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

    IS CDC ORACLE

  • Fixed component ID

    5725E30OR

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.4","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 October 2023