Kbase P95783: Schema Holder not created properly when doing ProToMss with user that is DBO
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/1/2008 |
|
Status: Verified
SYMPTOM(s):
Schema Holder not created properly when doing ProToMss with user that is DBO
FACT(s) (Environment):
Windows
MS SQL DataServer
Doing a ProToMss
Message received - Unable to find schema with selection criteria
user running ProToMss is defined in MS SQL Server as the database owner
Schema holder has _db record, MSS hidden files, but no user schema created.
Progress 9.1x
OpenEdge 10.x
CAUSE:
When the SQL schema is created, MS SQL Server changes the owner from userid of user who is doing the ProToMss to dbo because the user is the database owner.
FIX:
Create a user who has DBA privileges but is not the database owner and not part of the system administration group. Then recreate the MS SQL Server database and run the ProTo MSS again.
or
Fix the existing schema holder by connecting to it and run the Update/Add Schema function. When asked for selection criteria, enter dbo as the owner for the object to be pulled. After selecting and creating all wanted tables, connect to the original Progress database that was used for the ProToMSS. Then use the Adjust Schema Utility to fix up the schema holder.