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 number
JR35323
Reported component name
METADATA WORKBE
Reported component ID
5724S4100
Reported release
800
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-01-08
Closed date
2010-01-13
Last modified date
2010-01-13
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS3GFL","label":"InfoSphere Metadata Workbench"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
13 January 2010