Important Note for Enablement Service Pack 1 for UPK 3.6.1

The following was originally posted to one of the UPK communities on LinkedIn. Since this post generated some feedback that this information was not well-known, I thought it would be good to repost, which I've done with permission from Earl Sullivan.

This is an FYI for those who have UPK 3.6.1 and applied the Enablement Pack 1. There is a manual database update that is needed to be run. Here is the information:

To correct an issue with permissioning in the Library, this Service Pack, issued in March 2010, also contains scripts to update the database on the Oracle Database or MicrosoftSQL server. Once you have run the Setup.exe file for the Service Pack, the necessary script files can be found at the root of the folder where the Developer is installed. These scripts must be run manually according to the instructions below.

To update a database located on an Oracle Database server manually:

  1. Run the Setup.exe to install the files for the Service Pack.
  2. Start SQL*Plus and login with the system account.
  3. At the command prompt, enter the path to the AlterSchemaObjects.sql script located at the root of the folder where the Developer is installed. and append the following parameters:

    schema_owner - There is a limit of 20 characters on the schema owner name. You can find this information in the web.config file located in the Repository.WS in the folder where the server is installed.
    password - The existing schema owner password.
    Statement with generic parameters:
    @C:\AlterSchemaObjects.sql schema_owner password

  4. 4. Run the AlterSchemaObjects.sql script.

To update a database located on a Microsoft SQL server manually:

  1. Run the Setup.exe to install the files for the Service Pack.
  2. Log in to the database using the database administrator account.
  3. Open and edit the AlterDBObjects.sql file located at the root of the folder where the Developer is installed.
  4. Replace the ODServer text with the username used when the database was installed. You can find this information in the web.config file located in the Repository.WS folder in the folder where the server is installed.
  5. Change the database from master to the name of the existing Developer database and run the AlterDBObjects.sql script.
    Note: The database name is the initial catalog in the connection string in the
    web.config file.

Editor's note: The database update fixes a problem with permissions where the permissions for a user will be incorrectly updated when a group that the user was removed from has their permissions changed.

Comments:

Hi Just a minor point but the connection string in the web.config is encrypted in 3.6.1 and therefore it is not possible to get the database username from there. Thanks

Posted by Tim Poynter on June 13, 2010 at 11:15 PM PDT #

You are correct, Tim. Good catch. This is a bug in the documentation and will be addressed in the future. Thanks!

Posted by marc.santosusso on June 14, 2010 at 12:20 AM PDT #

I just confirmed the documentation will be updated in Enablement Service Pack 3.

Posted by marc.santosusso on August 26, 2010 at 06:21 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

The authors of this blog are members of the UPK product development, management, and marketing teams. On this blog, you'll find UPK news, tips/tricks, upcoming events, and general information on UPK - the easy-to-use, comprehensive content development, deployment, and maintenance platform for increasing project, program, and user productivity.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today