IT39952: GVM1102E ERROR WHEN TRYING TO DISPLAY THE "COVERAGE STATUS FOR ALL VMS" REPORT

APAR status

• Closed as program error.

Error description

• Attempting to generate the "Coverage status for all VMs" report
  in the IBM Spectrum Protect for Virtual Environments: Data
  Protection for VMware vSphere GUI triggers the message :
  
  GVM1102E
  The syntax of the following command is incorrect:
  "None available".
  
  In the server ACTLOG, the following message will be reported:
  
  ANR2940E The command 'SELECT NODE_NAME , FILESPACE_NAME ,
  BACKUP_START , BACKUP_END , timestampdiff ( 2 , char
  ( BACKUP_END-BACKUP_START ) ) as "BACKUP_DURATION" ,
  timestampdiff ( 2 , char ( CURRENT TIMESTAMP-BACKUP_END ) )
  as "BACKUP_CURRENCY" , LAST_REPL_START , LAST_REPL_COMP ,
  timestampdiff ( 2 , char ( LAST_REPL_COMP-LAST_REPL_START ) )
  as "LAST_REPL_DURATION" , timestampdiff ( 2 , char ( CURRENT
  TIMESTAMP-LAST_REPL_COMP ) ) as "LAST_REPL_CURRENCY" FROM
  FILESPACEVIEW WHERE NODE_NAME = 'DATACENTER_NODE_NAME' AND
  FILESPACE_TYPE = 'API:TSMVM' AND BACKUP_END IS NOT NULL '
  contains an unknown SQL column name.
  
  This happens when IBM Spectrum Protect server version 8.1.13 and
  higher is used, due to the new "Multiple Targets for
  Replication" feature that was introduced in the server version
  8.1.13.
  
  
  =======================
  Affected product versions:
  IBM Spectrum Protect for Virtual Environments: Data Protection
  for VMware: all 8.1 versions on all supported Windows and Linux
  platforms
  
  
  =======================
  Additional Keywords:
  
  TS008100329 tsm tsmve GVM1102E Coverage status SP VE GUI
  tsmvmwareui
  

Local fix

• Use the following select command with the server administrative
  command line to get the required information:
  (submit this query as one line)
  
  SELECT NODE_NAME, FILESPACE_NAME, BACKUP_START,
  BACKUP_END,timestampdiff (2, char(BACKUP_END-BACKUP_START)) as
  "BACKUP_DURATION", timestampdiff (2, char(CURRENT
  TIMESTAMP-BACKUP_END)) as "BACKUP_CURRENCY",LAST_REPL_START_1,
  LAST_REPL_COMP_1,timestampdiff (2,
  char(LAST_REPL_COMP_1-LAST_REPL_START_1)) as
  "LAST_REPL_DURATION", timestampdiff (2, char(CURRENT
  TIMESTAMP-LAST_REPL_COMP_1)) as "LAST_REPL_CURRENCY" FROM
  FILESPACEVIEW WHERE NODE_NAME = 'DATACENTER_NODE_NAME' AND
  FILESPACE_TYPE= 'API:TSMVM' AND BACKUP_END IS NOT NULL
  
  Replace DATACENTER_NODE_NAME with the datacenter node name in
  your environment.
  
  To get the information from the second replication target, this
  command can be used:
  (submit this query as one line)
  
  SELECT NODE_NAME, FILESPACE_NAME, BACKUP_START,
  BACKUP_END,timestampdiff (2, char(BACKUP_END-BACKUP_START)) as
  "BACKUP_DURATION", timestampdiff (2, char(CURRENT
  TIMESTAMP-BACKUP_END)) as "BACKUP_CURRENCY",LAST_REPL_START_2,
  LAST_REPL_COMP_2,timestampdiff (2,
  char(LAST_REPL_COMP_2-LAST_REPL_START_2)) as
  "LAST_REPL_DURATION", timestampdiff (2, char(CURRENT
  TIMESTAMP-LAST_REPL_COMP_2)) as "LAST_REPL_CURRENCY" FROM
  FILESPACEVIEW WHERE NODE_NAME = 'DATACENTER_NODE_NAME' AND
  FILESPACE_TYPE= 'API:TSMVM' AND BACKUP_END IS NOT NULL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Data Protection for Virtual             *
  * Environments version 8.1 running on Linux and Windows        *
  * platforms                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 8.1.19.                       *
  * Note that this is subject to change at the discretion of     *
  * IBM.                                                         *
  ****************************************************************
  

Problem conclusion

• The problem has been fixed so that logic to display VMs BA
  stutus related reports was changed to take into account (not
  just one but) both replication servers.
  

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

  TSM FOR VE DP V

• Fixed component ID

  5725TVEVM

Applicable component levels