IJ08517: ROUNDING PROBLEM TO IMPORT ASSETSPEC DATA USING DATA IMPORT FUNCTIONALITY.

APAR status

• Closed as program error.

Error description

• PROBLEM:
  Rounding problem to import ASSETSPEC data using Data Import
  functionality.
  PERFORMANCE ISSUE: No
  STEPS TO REPRODUCE:
  The steps below use MAXDEMO as example:
  1) Go to Object Structure and duplicate MXASSET.
  Remove all tables, except ASSET and ASSETSPEC.
  Click on Add/Modify Application Import Support option.
  Add ASSET Aplication.
  Click OK. Save.
  2)Go to Security Groups and give permission to the group that
  you are using to be able to import data in Asset application.
  Logout and login.
  3)Go to Assets application. Create a new Asset as below:
  Asset: PF02
  Click on Specifications.
  Classification: ELECTRICAL
  Add a new Specification.
  Attribute: HEIGHT
  Save.
  4)Import XML below:
  <?xml version="1.0" encoding="UTF-8"?>
  <SyncMXPFASSET2 xmlns="http://www.ibm.com/maximo"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  creationDateTime="2018-08-08T10:12:30-03:00" transLanguage="EN"
  baseLanguage="EN" messageID="877841533733950896199"
  maximoVersion="7 6 20171127-0100 V7609-45">
  <MXPFASSET2Set>
  <ASSET>
  <ASSETNUM>PF02</ASSETNUM>
  <SITEID>BEDFORD</SITEID>
  <ASSETSPEC>
  <ASSETATTRID>HEIGHT</ASSETATTRID>
  <ASSETSPECID>2144</ASSETSPECID>
  <LINEARASSETSPECID>0</LINEARASSETSPECID>
  <NUMVALUE>12.345999</NUMVALUE>
  </ASSETSPEC>
  </ASSET>
  </MXPFASSET2Set>
  </SyncMXPFASSET2>
  OBSERVATION: This problem occurs only with Application Import,
  works fine with a Web Service for example.
  CURRENT ERRONEOUS RESULT:
  Maximo will round the value 12.345999 to 12,346.
  In the Database Configuration application, NUMVALUE is Type
  DECIMAL, Length 30, and Scale 10.
  EXPECTED RESULT:
  Maximo should not round the value, because the scale of the
  attribute is higher than 3.
  ENVIRONMENT (SYSTEM INFO):
  Tivoli's process automation engine 7.6.0.9-IFIX20180314-1711
  Build 20171127-0100 DB Build V7609-45 HFDB Build HF7609-03
  IBM TPAE Integration Framework 7.6.0.9 Build 20171126-2330 DB
  Build V7609-32
  IBM Maximo Asset Management 7.6.0.9 Build 20171127-0100 DB
  Build V7604-01
  SECURITY IMPACT (Y/N): N
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who use application import to load numvalue of any     *
  * specifications                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The NUMVALUE was rounded via application import when it      *
  * should not. For example, a numvalue passed is 12.345999      *
  * should not be rounded as 12.346.  This is how it works in    *
  * the UI where the value is kept and saved as 12.345999.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  side effect of 7609 apar IJ00155
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.1.1 Product
  

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:

Modules/Macros

• maximo
  

Fix information

• Fixed component name

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R760 PSY

     UP