IV62983: ETL IMPORT FAILS FOR SCA VERSION 1.4 (1.4.46)

APAR status

• Closed as program error.

Error description

• One of the SCA database ETL queries was not filtering out
  soft-deleted computers in the IEM database (specifically
  computers that were previously the BES Root Server), and in the
  case that a deleted BES Server computer was the first record
  returned, SCA failed to determine the correct character set from
   that data.
  
  The query was changed to filter out soft-deleted computers and
  to also handle multiple property results by iterating until the
  correct one is found (rather than assuming only one result);
  solved the problem.
  
  This fix will be included in the upcoming SCA 1.5 release.
  

Local fix

• N/A
  

Problem summary

• Problem Description:
  SCA Import fails with error 'database Name Could not determine
  character set of the BES database'
  
  Problem Summary:
  One of the SCA database ETL queries was not filtering out soft
  deleted computers in the IEM database, specifically computers
  that had previously been a BES Root Server, and in the case that
  a deleted BES Root Server was the first record returned, SCA
  failed to determine the correct character set from that data.
  

Problem conclusion

• This issue was resolved in SCA 1.5
  

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

  TV EP MG DSS SC

• Fixed component ID

  5725C43SC

Applicable component levels

• R920 PSY

     UP