IBM Support

IV95216: SETDBSCHEMA.BAT -F A FAILS AT RESET STATE OF RESENRICHREADER SERVICE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Product: IBM Tivoli Business Service Manager
    Release: 6.1.1 (FP4)
    Severity: 4
    
    Problem Description: IBM Tivoli Business Service Manager 6.1.1
    (FP4).
    
    setdbschema -f a function fails at reset state of
    ResEnrichReader service in Windows.
    
    When running the setdbschema.bat -f a function, the system asks
    if you
    want to reset state of ResEnrichReader impact service. If you
    answer
    Yes the script fails with the following message:
    
    State of ResEnrichReader service is different to database
    state, reset
    state of ResEnrichReader service? (Y/N) Y
    TBSM/Impact Username: tipadmin
    TBSM/Impact Password: tipadmin
    'C:\Program' is not recognized as an internal or external
    command,
    operable program or batch file.
    
    C:\Program Files\IBM\tivoli\tbsm\XMLtoolkit\bin>exit /b 1
    C:\Program Files\IBM\tivoli\tbsm\XMLtoolkit\bin>
    
    In the setdbschema.bat I can see this fragment failing:
    :RESETRESENRICHREADER
    @IF EXIST "%TBSM_HOME%" (
    @IF EXIST
    "%TBSM_HOME%\etc\TBSM_resenrichreader_tbsmnotifications.state"
    (
    @SET /P RESETSTATE="State of ResEnrichReader service is
    different to
    database state, reset state of ResEnrichReader service? (Y/N) "
    @IF /I "!RESETSTATE!"=="y" GOTO :CLEARSTATEANDRESTART
    @IF /I "!RESETSTATE!"=="yes" GOTO :CLEARSTATEANDRESTART
    @IF /I "!RESETSTATE!"=="Y" GOTO :CLEARSTATEANDRESTART
    @IF /I "!RESETSTATE!"=="Yes" GOTO :CLEARSTATEANDRESTART
    @GOTO:ALLDONE
    )
    )
    @IF NOT EXIST "%TBSM_HOME%" (
    @ECHO "Could not find a TBSM_HOME environment variable.Please
    remember
    to clear ResEnrichReader state through Netcool/Impact User
    Interface";
    @GOTO:ALLDONE
    )
    
    :CLEARSTATEANDRESTART
    @SET /p username="TBSM/Impact Username:"
    @SET /p tbsmpass="TBSM/Impact Password:"
    @CMD /c "%TBSM_HOME%\bin\nci_trigger TBSM %username%/%tbsmpass%
    ResEnrichReaderRecycle Action ClearState"
    @GOTO:ALLDONE
    
    So the last command should probably be
    :CLEARSTATEANDRESTART
    @SET /p username="TBSM/Impact Username:"
    @SET /p tbsmpass="TBSM/Impact Password:"
    @CMD /c ""%TBSM_HOME%\bin\nci_trigger" TBSM
    %username%/%tbsmpass%
    ResEnrichReaderRecycle Action ClearState""
    @GOTO:ALLDONE
    
    After that only I can see it succeeded:
    State of ResEnrichReader service is different to database
    state, reset
    state of ResEnrichReader service? (Y/N) Y
    TBSM/Impact Username:tipadmin
    TBSM/Impact Password:***
    Policy completed successfully
    
    C:\Program Files\IBM\tivoli\tbsm\XMLtoolkit\bin>exit /b 0
    C:\Program Files\IBM\tivoli\tbsm\XMLtoolkit\bin>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Software Group Pre-Sales                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SETDBSCHEMA.BAT -F A FAILS AT RESET STATE OF RESENRICHREADER *
    *    SERVICE.                                                  *
    * 'C:\Program' is not recognized as an internal or external    *
    * command,                                                     *
    * operable program or batch file.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * change the path as below:                                    *
    * @CMD /c ""%TBSM_HOME%\bin\nci_trigger" TBSM                  *
    * %username%/%tbsmpass% ResEnrichReaderRecycle Action          *
    * ClearState"                                                  *
    ****************************************************************
    None
    

Problem conclusion

  • change the path as below:
    @CMD /c ""%TBSM_HOME%\bin\nci_trigger" TBSM
    %username%/%tbsmpass% ResEnrichReaderRecycle Action ClearState"
    
    The fix for this APAR is contained in the TIV-BSM 6.2.0 Release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV95216

  • Reported component name

    TIV BUS SERV MG

  • Reported component ID

    5724C5100

  • Reported release

    611

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-18

  • Closed date

    2017-12-08

  • Last modified date

    2018-09-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • UNKNOWN
    

Fix information

  • Fixed component name

    TIV BUS SERV MG

  • Fixed component ID

    5724C5100

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSPFK","label":"Tivoli Business Service Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
27 April 2020