IT34753: BACKUP OF SQL SERVER FAILS WITH 'ENCOUNTERED AN ERROR EXECUTING STEP BASICSTEP1 IN JOB BASICONESTEPJOB'

APAR status

• Closed as program error.

Error description

• The backup of a Microsoft SQL server can fail with the error in
  the Job log:
  ERROR,1598610780660,<date>,2,,Encountered an error
  executing step basicStep1 in job basicOneStepJob
  
  Reviewing the
  Virgo log, it can be seen that an invalid Application Server ID
  is found:
  [date] ERROR http-nio-8082-exec-505
  c.s.dp.xsb.api.commons.exception.ExceptionMessageTranslator com.
  catalogic.ecx.serviceprovider.common.application.exception.Appli
  cationServerDoesNotExistException: id (1089)
  	at
  com.catalogic.e....
  ....
  [date] ERROR http-nio-8082-exec-505
  c.s.dp.xsb.api.commons.exception.ExceptionMessageTranslator com.
  catalogic.ecx.serviceprovider.common.application.exception.Appli
  cationServerDoesNotExistException: Application Server ID is
  invalid.
  [date] ERROR http-nio-8082-exec-505
  c.s.dp.xsb.api.commons.exception.ControllerExceptionHandler
  null
  [date] INFO asyncTaskExecutor-2366
  com.syncsort.dp.xsb.service.authentication.impl.AuthServiceImpl
  <jobid> User sign out from session
  "f3c141b88cee4ec4aa8f469984f5c3cc".
  [date] INFO
  asyncTaskExecutor-2366
  com.syncsort.dp.xsb.sessionmanager.impl.SessionManagerImpl
  <jobid> SessionManager: Destroying session with ID:
  f3c141b88cee4ec4aa8f469984f5c3cc
  [date] ERROR
  asyncTaskExecutor-2366
  org.springframework.batch.core.step.AbstractStep <jobid>
  Encountered an error executing step basicStep1 in job
  basicOneStepJob
  org.springframework.web.client.HttpClientErrorException: 404
  null
  
  
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM
  Spectrum Protect Plus 10.1.x
  
  Initial Impact:
  Medium
  
  Additional Keywords: SPP, SPPlus, TS004104303
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.5 and 10.1.6.           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problems is      *
  * currently projected to be fixed in IBM Spectrum Protect Plus *
  * level 10.1.7. Note that this is subject to change at the     *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Able to proceed with the backup job when one of the SQL servers
  to perform disable logbackup is already unregistered.
  

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:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels