IT42515: SQL0007N ..INVALID CHARACTER ERROR GENERATING CLIENTS WITH THE MOST DATA BACKED UP REPORT USING VERSION 8.1.16

APAR status

• Closed as program error.

Error description

• The SQL generated by the IBM Spectrum Protect Operations Center
  custom report that collects the Clients with the most data
  backed up will fail reporting the following exception in the
  Server Activity log:
  
  ANR0162W Supplemental database diagnostic information:
  -1:42601:-7 ([IBM][CLI Driver][DB2/LINUXX8664]
  
  SQL0007N The statement was not processed because a character
  that is not supported in SQL statements was included in the SQL
  statement.
  
  Invalid character: "<A0>". Text preceding the invalid
  character: "46' as server from (". SQLSTATE=42601).
  
  ANR0516E SQL processing for statement select node_name , type ,
  size , 'SERVER' as server from ( <A0><A0><A0><A0>
  <A0><A0><A0><A0><A0><A0><A0><A0><A0><A0><A0><A0>
  
  ( SELECT name as node_name , type , sum ( case when coalesce (
  BYTES_PROTECTED , 0 ) > 0 then coalesce ( BYTES_PROTECTED , 0 )
  else coalesce ( BYTES , 0 ) end ) as size from summary s inner
  join tsmgui_allcli_grid on entity = name WHERE ( activity =
  'BACKUP' or activity = 'ARCHIVE' ) group by name , type<A0>
  order by size desc fetch first 10 rows only ) union
  
  ( SELECT name as node_name , type , coalesce ( sum ( bytes ) ,
  0 ) as size from summary_extended s inner join
  tsmgui_allcli_grid on sub_entity = name WHERE a ctivity =
  'BACKUP'
  and ( activity_type = 'Full' or activity_type like
  'Incremental%' ) AND sub_entity is not null group by name , type
  order b y size desc fetch first 10 rows only ) ) failed.
  
  
  The Clients with the most data backed up report can be
  generated using the Operations Center report custom builder.
  
  
  
  IBM Spectrum Protect Versions Affected:
  
  IBM Spectrum Protect Operations center 8.1.16.000 on all
  supported platforms
  |MDVREGR 8.1.16.000-5608E01UI |
  

Local fix

• The following SQL can be used in the Operations Center SQL
  builder to gather the same information.
  Replace <servername> with the Server name that you want to
  collect the output from.
  
  select node_name , type , size , '<servername>' as server from (
  ( SELECT name as
  
  node_name , type , sum ( case when coalesce ( BYTES_PROTECTED ,
  0 ) > 0 then coalesce (
  
  BYTES_PROTECTED , 0 ) else coalesce ( BYTES , 0 ) end ) as size
  from summary s inner join
  
  tsmgui_allcli_grid on entity = name WHERE ( activity = 'BACKUP'
  or activity = 'ARCHIVE' ) group by
  
  name , type order by size desc fetch first 10 rows only ) union
  ( SELECT name as node_name , type
  
  , coalesce ( sum ( bytes ) , 0 ) as size from summary_extended
  s inner join tsmgui_allcli_grid on
  
  sub_entity = name WHERE activity = 'BACKUP' and ( activity_type
  = 'Full' or activity_type like
  
  'Incremental%' ) AND sub_entity is not null group by name ,
  type order by size desc fetch first 10
  
  rows only ) )
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect Operations Center users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available.                           *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, Linux, and
  Windows.
  

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 OPERATIONS

• Fixed component ID

  5608E01UI

Applicable component levels