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 number
IT39952
Reported component name
TSM FOR VE DP V
Reported component ID
5725TVEVM
Reported release
81W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-02-14
Closed date
2023-04-28
Last modified date
2023-04-28
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS8TDQ","label":"Tivoli Storage Manager for Virtual Environments"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81W","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
28 April 2023