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

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 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