IJ33806: "BMXAA4144E - THE DATE/TIME FORMAT IS NOT VALID" ERROR WHEN TRYING TO QUERY DATES BEFORE 1776 USING MIF

APAR status

• Closed as program error.

Error description

• PROBLEM:
  
  "BMXAA4144E - The date/time format is not valid" error when
  trying to query dates before 1776 using MIF
  
  
  
  STEPS TO REPRODUCE:
  
  Using POSTMAN and MAXDEMO data:
  
  http://MAXIMO-SERVER/maximo/oslc/os/MXASSET?lean=1&oslc.select=
  assetnum&oslc.where=status%3D%22active%22%20and%20installdate%3
  E%3D%221775%22
  
  In this example the OSLC transaction is trying to query assets
  that were installed in 1775
  
  RESULTS:
  
  BMXAA4143E - The date format is not valid. Use the date format
  defined by your locale, or use the calendar control to enter a
  date.
  at psdi.util.MXFormat.jmigStringToDateTime(MXFormat.java:1016)
  at psdi.iface.mos.ConversionUtil.stringToDate(ConversionUtil.ja
  va:103)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.getQbeV
  alueForDate(OslcQueryHandler.java:1813)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.getColu
  mnValue(OslcQueryHandler.java:1537)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.setAttr
  ibuteQbe(OslcQueryHandler.java:1723)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.handleQ
  ueryClause(OslcQueryHandler.java:1197)
  at com.ibm.tivoli.maximo.oslc.provider.OSGETRouteHandler.handle
  Request(OSGETRouteHandler.java:407)
  at com.ibm.tivoli.maximo.oslc.provider.MaximoOslcProviderServle
  t.handleRoute(MaximoOslcProviderServlet.java:1240)
  at com.ibm.tivoli.maximo.oslc.provider.MaximoOslcProviderServle
  t.doGet(MaximoOslcProviderServlet.java:677)
  
  EXPECTED RESULT:
  
  Allow queries for dates before 1776
  
  
  PRODUCT VERSION:
  IBM Tpae Integration Framework 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo MIF users                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * "BMXAA4144E - The date/time format is not valid" error when  *
  * trying to query dates before 1776 using MIF.                 *
  ****************************************************************
  Using POSTMAN and MAXDEMO data:
  [http://localhost:7001/maximo/oslc/os/MXASSET?oslc.select=assetn
  um,*&oslc.where=assetnum=]"1001" and
  statusdate>="1775"&_lid=maxadmin&_lpwd=maxadmin&lean=1
  In this example the OSLC transaction is trying to query assets
  that were installed in 1775
  RESULTS:
  BMXAA4143E - The date format is not valid. Use the date format
  defined by your locale, or use the calendar control to enter a
  date.
  at psdi.util.MXFormat.jmigStringToDateTime(MXFormat.java:1016)
  at psdi.iface.mos.ConversionUtil.stringToDate(ConversionUtil.ja
  va:103)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.getQbeV
  alueForDate(OslcQueryHandler.java:1813)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.getColu
  mnValue(OslcQueryHandler.java:1537)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.setAttr
  ibuteQbe(OslcQueryHandler.java:1723)
  at com.ibm.tivoli.maximo.oslc.provider.OslcQueryHandler.handleQ
  ueryClause(OslcQueryHandler.java:1197)
  at com.ibm.tivoli.maximo.oslc.provider.OSGETRouteHandler.handle
  Request(OSGETRouteHandler.java:407)
  at com.ibm.tivoli.maximo.oslc.provider.MaximoOslcProviderServle
  t.handleRoute(MaximoOslcProviderServlet.java:1240)
  at com.ibm.tivoli.maximo.oslc.provider.MaximoOslcProviderServle
  t.doGet(MaximoOslcProviderServlet.java:677)
  EXPECTED RESULT:
  Allow queries for dates before 1776
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: Release 7.6.1.3 of Base Services
  

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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels