IBM Support

IV18992: Changing the locale settings from en_US.UTF-8 to RU_RU.UTF.8 then save GUI and start Discovery generate error in disco log.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ITNM 39 FP1
    AIX 5.3 / 6.1
    
    Problem description : on ITNM 3.9 + FP1 AIX install when
    customer is changing the locale settings from en_US.UTF-8 to
    RU_RU.UTF-8 then saves the discovery settings from GUI and start
    FullDiscovery, ncp_disco.log reports :
    
    2012-02-10T16:17:21: Warning: W-RIV-002-140: [1t]
    CRivInsert.cc(1563)The database insert was invalid. Column and
    values lists different lengths, can not construct record from
    insert. Column list length: 35 value list length: 36
    

Local fix

  • Workaqround:
                    Cause of the problem : After save disco config
    from gui,
    the
    value of m_NothngFndPeriod from DiscoConfig.<>.cfg become
    altereted to 90,000000 instead of 90.
    Workaround: manually remove the value and insert the correct
    one: 90
    
    And changing the following
    
    create table disco.config
    (
        m_NothngFndPeriod   float,          // Amount of time
    between device
                                            // finds to fulfill find
    rate criteria
    
    To
    
    create table disco.config
    (
        m_NothngFndPeriod   int,            // Amount of time
    between device
                                            // finds to fulfill find
    rate criteria
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 3.8, 3.9 all platforms, users using Russian locale           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Problem description : on ITNM 3.9 + FP1 AIX install when     *
    * customer is changing the locale settings from en_US.UTF-8 to *
    * RU_RU.UTF-8 then saves the discovery settings from GUI and   *
    * start                                                        *
    * FullDiscovery, ncp_disco.log reports :                       *
    *                                                              *
    * 2012-02-10T16:17:21: Warning: W-RIV-002-140: [1t]            *
    * CRivInsert.cc(1563)The database insert was invalid. Column   *
    * and                                                          *
    * values lists different lengths, can not construct record     *
    * from                                                         *
    * insert. Column list length: 35 value list length: 36         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This was a locale issue caused by the fact that the          *
    * m_NothngFndPeriod in the DiscoSchema.cfg is defined as a     *
    * floating point number. In the Russian locale they use a      *
    * comma instead of a period as the decimal point and that      *
    * meant after saving the disco configuration via the GUI disco *
    * couldn't then read the file.  The fix (and the workaround)   *
    * is to change the m_NothngFndPeriod definition to be an       *
    * integer number of seconds instead of  a floating point       *
    * number                                                       *
    ****************************************************************
    

Problem conclusion

  • | fix pack | 3.8.0-ITNMIP-FP0007 and
    | fix pack | 3.9.0-ITNMIP-FP0003
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV18992

  • Reported component name

    TIV NETWK MGR I

  • Reported component ID

    5724S4500

  • Reported release

    380

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-04-04

  • Closed date

    2012-06-07

  • Last modified date

    2013-01-23

  • 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

    TIV NETWK MGR I

  • Fixed component ID

    5724S4500

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"380","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 August 2023