JR35323: MSSQL ENTERPRISE STAGE - STITCHING RELIES UPON USERNAME AS SCHEM A INCORRECTLY

APAR status

• Closed as fixed if next.

Error description

• RTC
  https://ips-rtc.swg.usma.ibm.com/jazz/web/projects/IFT%20-%20Me
  tadata%20Workbench#action=com.ibm.team.workitem.viewWorkItem&id
  =7717
  
  As reported by Chevron
  
  Stitching failed to reconcile MSSQL Stages and the imported
  Databasse because the imported Database reflected "dbo" as
  the Schema, whereas the Username within the Stage was an
  actual user
  

Local fix

• If no schema is specified then:
       if the selectd db type  is MSSQL use "dbo"
       otherwise use the user name
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  MWB 8.1.2 and earlier
  ****************************************************************
  PROBLEM DESCRIPTION:
  MSSQL ENTERPRISE STAGE - STITCHING RELIES UPON USERNAME AS SCHEM
  A INCORRECTLY
  ****************************************************************
  RECOMMENDATION:
  Upgrade to 8.1.2 FP1
  ****************************************************************
  

Problem conclusion

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:

Modules/Macros

• MWB
  

Fix information

Applicable component levels

• R812 PSN

     UP