Direct links to fixes
IBM InfoSphere Data Replication CDC for all Windows agents 11.4.0.0 Build 5057
IBM InfoSphere Data Replication CDC for all AIX agents 11.4.0.0 Build 5057
IBM InfoSphere Data Replication CDC for all LinuxPower agents 11.4.0.0 Build 5057
IBM InfoSphere Data Replication CDC for all LinuxSystemZ agents 11.4.0.0 Build 5057
IBM InfoSphere Data Replication CDC for all Linux agents 11.4.0.0 Build 5057
IBM InfoSphere Data Replication CDC for all Linux agents 11.4.0.0 Build 5057
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