IT44614: WHEN AM/PM MARKERS ARE SET AS A.M/P.M, ERRORS ARE OBSERVED WHILECASTING STRINGS TO DATETIME FORMAT

APAR status

• Closed as program error.

Error description

• While formatting or casting strings into dateTime there could be
  dateTime parsing errors if the AM/PM markers are set to be in
  a.m/p.m format for the respective locale.
  
  Example :
  Sample ESQL code :
  DECLARE var1 CHARACTER CAST(InputRoot.BLOB.BLOB AS CHAR CCSID
  1208);
  DECLARE var2 DATE CAST(var1 AS DATE FORMAT 'M/d/yyyy hh:mm:ss
  a');
  SET OutputRoot.BLOB.BLOB = CAST(CAST(var2 AS CHAR FORMAT
  'yyyy-MM-dd') AS BLOB CCSID 1208);
  
  Sample error seen in traces :
  
  ImbExceptionLog::FileDestination::writeException
  (000065E6-64DF6855-00000001) , 'Exception log entry: ',
  '2023-08-18 22:47:17.633841        26086     THROWN  BIP3204S
  RecoverableException    ImbTimeStampFormatter::subParse  'No am
  / pm here' ['1/1/1900 12:00:00 am', 'M/d/yyyy hh:mm:ss a', 'a',
  'a']    CommonServices/ImbTimeStampFormatter.cpp:1654
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM App Connect Enterprise V12 using nl_NL(Dutch -
  Netherlands) or other locales where the AM/PM markers are in the
  form a.m/p.m.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  In the nl_NL locale, as part of recent changes in the library,
  the AM/PM markers have been changed from AM/PM to a.m./p.m. App
  Connect Enterprise currently handles AM/PM markers in the
  formats AM/PM and am.pm. Hence when these markers are
  represented as a.m/p.m there will be errors observed while
  casting strings to DATETIME format.
  

Problem conclusion

• App Connect Enterprise is now capable of handling the scenario
  when the AM/PM markers are in the form a.m/p.m. In addition to
  this APAR, the user is required to set the environment variable
  MQSI_LOCALE_COMPATIBILITY to 1 which will allow App Connect
  Enterprise to interpret a.m/p.m correctly. This can be used when
  the customer is using nl_NL locales or other affected locales.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v12.0      12.0.11.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  APP CONNECT ENT

• Fixed component ID

  5724J0560

Applicable component levels