IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    IJ08517

  • Reported component name

    INTEGRATION

  • Reported component ID

    5724R46I1

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-08-16

  • Closed date

    2018-09-12

  • Last modified date

    2018-09-12

  • 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



Document information

More support for: Maximo Asset Management

Software version: 760

Reference #: IJ08517

Modified date: 12 September 2018