IT08478: CANNOT RETRIEVE DATA WHEN VIEWING NODE PROPERTIES IN THE OPERATIONS CENTER

7.1.4.000-TIV-TSMOC-LinuxS390
7.1.4.000-TIV-TSMOC-LinuxPPC64
7.1.4.000-TIV-TSMOC-Windows
7.1.4.000-TIV-TSMOC-Linuxx64
7.1.4.000-TIV-TSMOC-AIX
7.1.1.200-TIV-TSMOC-Windows
7.1.1.200-TIV-TSMOC-Linuxx64
7.1.1.200-TIV-TSMOC-LinuxS390
7.1.1.200-TIV-TSMOC-LinuxPPC64
7.1.1.200-TIV-TSMOC-AIX
Tivoli Storage Manager Operations Center V7.1.1.x interim fix downloads
IBM Spectrum Protect Operations Center V7.1.4 Download

APAR status

• Closed as program error.

Error description

• In the Operations Center, for some nodes, the properties will
  not display, an error message returned ?Cannot retrieve data?.
  Click on the error to see more details:
  ANRG0091E The syntax of the following command is not valid.
  
  Check the Tivoli Storage Manager server activity log to verify
  the command with syntax error. An error similar to the following
  will be seen:
  ANR0162W Supplemental database diagnostic information:
  -1:21000:-811 ([IBM][CLI Driver][DB2/NT64] SQL0811N  The
  result of a scalar fullselect, SELECT INTO statement, or
  VALUES INTO statement is more than one row.
  SQLSTATE=21000).
  
  ANR0516E SQL processing for statement SELECT
  CLIENT_PRODUCTS , PLATFORM_NAME , DOMAIN_NAME ,
  OPTION_SET , CONTACT , REG_TIME , REG_ADMIN , URL ,
  CLIENT_VERSION || '.' || CLIENT_RELEASE || '.' ||
  CLIENT_LEVEL || '.' || CLIENT_SUBLEVEL as CLIENT_DETAILS
  , TCP_ADDRESS , EMAIL_ADDRESS , PROXY_TARGET ,
  PROXY_AGENT , AUTHENTICATION , KEEP_MP , MAX_MP_ALLOWED ,
  TXNGROUPMAX , DATAWRITEPATH , DATAREADPATH , ARCHDELETE ,
  BACKDELETE , COMPRESSION , COLLOCGROUP_NAME ,
  DEDUPLICATION , LASTACC_TIME , LASTSESS_COMMMETH ,
  LASTSESS_RECVD , LASTSESS_SENT , ROUND (
  LASTSESS_DURATION , 2 ) as LASTSESS_DURATION , ROUND ( (
  case when LASTSESS_DURATION <> 0 then (
  LASTSESS_IDLEWAIT/LASTSESS_DURATION ) *100 else 0 end ) ,
   3 ) as LASTSESS_IDLEWAIT , ROUND ( ( case when
  LASTSESS_DURATION <> 0 then (
  LASTSESS_COMMWAIT/LASTSESS_DURATION ) *100 else 0 end ) ,
  3 ) as LASTSESS_COMMWAIT , ROUND ( ( case when
  LASTSESS_DURATION <> 0 then (
  LASTSESS_MEDIAWAIT/LASTSESS_DURATION ) *100 else 0 end )
  , 3 ) as LASTSESS_MEDIAWAIT , REPL_BKRULE , REPL_ARRULE ,
  REPL_SPRULE , ( case when REPL_STATE = 'NONE' then
  REPL_STATE else REPL_STATE || '_' || REPL_MODE end ) as
  REPL_STATE , ( select ( case when REPL_MODE is null then
  '-1' else PEERSERV end ) as PEERSERV from
  TSMGUI_ALLCLI_GRID where SERVER = 'xxxx' and NAME =
  'xxxx' ) , NODEGROUP , UTILITYURL FROM NODESVIEW WHERE
  NODE_NAME = 'xxxx'  failed.
  
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Operations Center 6.x, 7.x on all
  platforms.
  
  Customer/L2 Diagnostics (If Applicable)
  If there are multiple entries that match the node name and the
  server name in table TSMGUI_ALLCLI_GRID, this problem occurs. To
  verify, run the following SQL select from the HUB server admin
  console:
  SELECT * FROM TSMGUI_ALLCLI_GRID WHERE SERVER = 'SERVERNAME' AND
  NAME='NODENAME'
  .
  Replace SERVERNAME and NODENAME with the same servername and
  nodename that are reported in the error.
  This statement will return two or more entries. For example,
  tsm: CHCTSMX>SELECT * FROM TSMGUI_ALLCLI_GRID WHERE SERVER =
  'CHCTSMX' AND NAME='CHCMPF'
             NAME: CHCMPF
           SERVER: CHCTSMX
             TYPE: 1
           STATUS: 0
           LOCKED: 0
       HAS_BACKUP: 1
      HAS_ARCHIVE: 0
      HAS_SPACEMG: 0
       IS_VIRTUAL: 0
     IS_SCHEDULED: 1
  SEC_LAST_ACCESS: 5293
          VERSION: 7
          RELEASE: 1
            LEVEL: 0
         SUBLEVEL: 3
         VM_OWNER:
          VM_FSID:
          VM_TYPE:
       REPL_STATE: 0
        REPL_MODE: 0
         REPLSERV:
         PEERSERV:
         PLATFORM: WINNT
           DOMAIN: DOM_WINDOWS_CHC
             GUID: 94.80.a4.b0.9d.9a.11.e3.8e.a3.00.50.56.a5.3d.5d
        NEXTSCHED: WINDOWS-2145
        STARTTIME: 21:45:00
          ENDTIME:
      STARTWINDOW: 10
          RUNTIME: 34
         SCHEDNUM: 1
     SERVERSTATUS: 0
  
             NAME: CHCMPF
           SERVER: CHCTSMX
             TYPE: 2
           STATUS: 0
           LOCKED: 0
       HAS_BACKUP: 1
      HAS_ARCHIVE: 0
      HAS_SPACEMG: 0
       IS_VIRTUAL: 1
     IS_SCHEDULED: 0
  SEC_LAST_ACCESS: 67992
          VERSION: 0
          RELEASE: 0
            LEVEL: 0
         SUBLEVEL: 0
         VM_OWNER: MGI01
          VM_FSID: 324
          VM_TYPE: 1
       REPL_STATE: 0
        REPL_MODE: 0
         REPLSERV:
         PEERSERV:
         PLATFORM: ?
           DOMAIN: CHCTSMX_VIRTUAL
             GUID: ?
        NEXTSCHED:
        STARTTIME:
          ENDTIME:
      STARTWINDOW: 0
          RUNTIME: 0
         SCHEDNUM: 0
     SERVERSTATUS: 0
  
  
  Initial Impact:
  Low
  
  Additional Keywords:
  TSM OC
  

Local fix

• Node with TYPE=1 is a client node. Node with TYPE=2 is a VMware.
   Change the node names so they are different.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager Operations Center users.          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currenlty *
  * projected to be fixed in level 7.1.1. Note that this is      *
  * subject to change at the direction of IBM.                   *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms: AIX, Linux, 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