Setting up the product library in an ArcSDE environment

This workflow provides steps for creating and configuring a geodatabase as a product library that can be used in an enterprise ArcSDE environment to manage data and products. If you do not want to create your own product library for nautical products, you can import the preconfigured nautical product library XML workspace installed with the solution.

Two different procedures are used to create and set up an ArcSDE geodatabase for the product library. One is used for setting up the product library on an ArcSDE geodatabase for Microsoft SQL Server Express licensed for ArcGIS Desktop (instance of SQL Server Express). The other is used for setting up the product library on an ArcSDE geodatabase licensed for ArcGIS Server Enterprise. The steps in this workflow are for setting up the product library on an ArcSDE geodatabase for Microsoft SQL Server Express licensed for ArcGIS Desktop, but additional information and links are provided for setting up the product library on an ArcSDE geodatabase licensed for ArcGIS Server Enterprise.

Adding a database server

This section describes how to add a database server connection under the Database Servers node in the Catalog window. This is a connection to a Microsoft SQL Server Express instance set up to store geodatabases. You can skip this section if you are using Oracle, SQL Server Enterprise, or another ArcSDE geodatabase licensed for ArcGIS Server Enterprise to store the geodatabase you are using as the product library.

You will need to install SQL Server Express, if you have not already, and enable it to store geodatabases.

Schritte:
  1. Start ArcMap, open the Catalog window, then expand the Database Servers node in the Catalog tree.
  2. Doppelklicken Sie auf Datenbankserver hinzufügen.
  3. In the Add Database Server dialog box, provide the name of the ArcSDE database server. This is in the form <server_name>\<instance_name>, where the server name is the name of the server on which SQL Server Express is installed and the instance name is the name of the SQL Server Express instance.

    For example, if a database server is named SOPHIE\SQLEXPRESS, SOPHIE is the server name, and SQLEXPRESS is the instance name. Using 127.0.01 for the server name will avoid sourcing issues if multiple users are going to be accessing the product library.

  4. Klicken Sie auf OK.

    5. Das Serversymbol wird im Kataloginhaltsverzeichnis unter Datenbankserver angezeigt.

    TippTipp:
    Wenn Sie den Datenbankserver hinzufügen und das Symbol im Kataloginhaltsverzeichnis mit einem leeren weißen Quadrat angezeigt wird, wurde der Datenbankserver zwar hinzugefügt, sein Status ist jedoch unbekannt. Doppelklicken Sie darauf, um einen Verbindungsversuch zu starten. Wenn Sie keine Verbindung herstellen können, informieren Sie sich beim Administrator des betreffenden Datenbankservers, ob die SQL Server Express-Instanz ausgeführt wird, ob sie mit dem Netzwerk verbunden ist und über welche Art von Berechtigung Sie für diesen Datenbankserver verfügen.

Creating the administrator database connection

If the product library is stored in an ArcSDE geodatabase licensed for ArcGIS Server Enterprise, you need to create an administrator database connection. If your product library is stored in SQL Server Express, you can skip this section, since you only need to add a database server connection (first section of this workflow).

If you want to create a database connection for SQL Server, go to Making a direct connection from ArcGIS Desktop to a geodatabase in SQL Server. If you want to create a database connection for Oracle, go to Making a direct connection from ArcGIS Desktop to a geodatabase in Oracle.

Creating an ArcSDE geodatabase

The server administrator needs to create a new geodatabase from Oracle, SQL Server, SQL Server Express or another enterprise database management system (DBMS) that can be used as the product library. The steps in this section are for creating an ArcSDE geodatabase for Microsoft SQL Server Express licensed for ArcGIS Desktop (SQL Server Express geodatabase). If you want to create a geodatabase from Oracle, SQL Server, or another ArcSDE geodatabase licensed for ArcGIS Server Enterprise, see the following topics for information:

Recommendations for Oracle databases

It is recommended that you ensure that the following parameter values are used when creating an Oracle database:

Parameter name

Value

Configure with Database Enterprise Manager

Enabled

Shared memory management

AUTOMATIC

Character Sets

Unicode (AL32UTF8)

OPEN_CURSORS

2000–10000

SESSION_CACHED_CURSORS

50–150

pre_page_sge

True
Oracle parameters for product library

When using product library in the Nautical Solution, for each checking in process, it writes a sizable amount of data that includes the MDF and MXD files into the product library tablespace. It is highly recommended to manage the growth of this tablespace. The size of the product library tablespace depends on number of products and the frequency of changes to the product in the product library. Ideally, keep 6GB of space for the initial size and increment it in 3GB chunk datafile. Set the AUTOEXTEND parameter of the tablespace to true to allow the tablespace to automatically extend the datafile when it becomes full. If the product library tablespace is full, you may get errors while running nautical processes such as populate, apply changes and checking in products.

The steps below are for creating an ArcSDE geodatabase for Microsoft SQL Server Express licensed for ArcGIS Desktop (an instance of SQL Server Express).

Schritte:
  1. Log in as a server administrator, start ArcMap, then open the Catalog window.
  2. Klicken Sie im Kataloginhaltsverzeichnis mit der rechten Maustaste auf den Datenbankserver, auf dem Sie die neue Geodatabase erstellen möchten.
  3. Klicken Sie auf Neue Geodatabase.
  4. Geben Sie im Textfeld Name der Geodatabase einen Namen für die neue Geodatabase ein.

    Der Name muss mit einem Buchstaben beginnen, darf keine Leerzeichen oder Sonderzeichen (z. B. #, @ oder *) enthalten und ist auf maximal 31 Zeichen beschränkt, wenn er mit dem Servernamen kombiniert ist.

  5. Wenn Sie den Speicherort der Datenbankdatei ändern möchten, geben Sie den neuen Speicherort im Textfeld Geodatabase-Datei an, indem Sie auf die Ellipsen-Schaltfläche (...) klicken und zum gewünschten Speicherort navigieren.
  6. Geben Sie die Größe der neuen Geodatabase im Textfeld Anfangsgröße ein.
  7. Wählen Sie im Dropdown-Menü Einheiten die Option "MB" oder "GB", oder übernehmen Sie die Standardgröße von 100 MB.

    Unabhängig von der anfänglichen Größe kann die Geodatabase später je nach Bedarf bis zu 4 GB groß werden.

    HinweisHinweis:

    Die Geodatabase muss ursprünglich mindestens so groß sein wie die Modelldatenbank in der SQL Server Express-Instanz. Die Modelldatenbank ist die Systemvorlage für alle neuen Datenbanken. Durch die Größe der Modelldatenbank ist die Mindestgröße für alle Datenbanken vorgegeben, die in dieser SQL Server Express-Instanz erstellt werden. Wenn Sie versuchen, eine Geodatabase zu erstellen, die diese Mindestgröße unterschreitet, wird die Datenbankerstellung abgebrochen und folgende Fehlermeldung zurückgegeben:

    Error creating this geodatabase
CREATE DATABASE failed. 
Primary file must be at least <size of model> to accommodate a copy 
of the model database.

  8. Click OK.

    9. Während der Erstellung der Datenbankdatei und des Geodatabase-Schemas wird eine Fortschrittsanzeige eingeblendet. Nach Abschluss des Vorgangs wird die neue Geodatabase auf der Registerkarte "Inhalt" und im Kataloginhaltsverzeichnis angezeigt.

Creating geodatabase users

You can choose to add users to a geodatabase stored in SQL Server through Microsoft SQL Server Management Studio Express.

Learn how to add users for an Oracle database

Learn how to add Windows-authenticated users or groups to a SQL Server database

Learn how to add database-authenticated users to a SQL Server database

The steps below are for creating users for the product library geodatabase in ArcCatalog on a database server (an instance of SQL Server Express) and SQL Server.

Schritte:
  1. Log in as a server administrator, start ArcMap, then open the Catalog window.
  2. Klicken Sie mit der rechten Maustaste auf den Datenbankserver, dem Sie einen Benutzer oder eine Gruppe hinzufügen möchten.
  3. Klicken Sie auf Berechtigungen.
  4. Klicken Sie im Dialogfeld Berechtigungen auf Benutzer hinzufügen.
  5. Geben Sie den Ort an, an dem Sie nach dem Benutzer bzw. der Gruppe suchen möchten.

    Dies kann der lokale Computer oder eine Domäne sein.

  6. Geben Sie den Namen des hinzuzufügenden Benutzers bzw. der Gruppe ein. Sie können auf Erweitert klicken, um die Suchkriterien zu verfeinern.
  7. Klicken Sie auf Namen überprüfen, um die Gültigkeit des Anmeldenamens zu überprüfen.
  8. Click OK.

Granting geodatabase roles/permissions

A role needs to be assigned to the users that are going to be working with the product library so they can view or add components, information, and data to the product library. These permissions are at the geodatabase level, assigned separately from the product library permissions. The roles are assigned through ArcCatalog as permissions for users that are using a product library stored in SQL Server Express or SQL Server. For Oracle and any other ArcSDE geodatabase licensed for ArcGIS Server Enterprise, the role CKB_USERS must be created for the users to be recognized by the product library. This can be done by using the following statement:

CREATE ROLE CKB_USERS NOT IDENTIFIED

User names for the role are required for any users who are going to be working with the product library and need to read from or write to the product library tables and other components. The administrators are considered the owners of the data, so they already have this privilege.

Below are suggested user names and the permissions required for each level for Oracle (and SQL Server if using Microsoft SQL Server Management Studio Express).

For product library administrators, the following is suggested:

User type

Role

Oracle permissions

SQL Server permissions

Data owner

CONNECT

  • CREATE PROCEDURE
  • CREATE SEQUENCE
  • CREATE SESSION
  • CREATE TRIGGER
  • CREATE VIEW
  • CREATE TABLE

  • CREATE TABLE
  • CREATE VIEW
  • CREATE PROCEDURE
Administrator permissions

For product library editors, the following is suggested:

User type

Role

Oracle permissions

SQL Server permissions

Data editor/Data viewer

  • CONNECT
  • CKB_USERS

CREATE SESSION

CREATE TABLE

Editor permissions

Learn more about user permission levels for Oracle

Learn more about user permission levels for SQL Server

The steps below are for granting roles/permissions on a database server (an instance of SQL Server Express), and SQL Server.

Schritte:
  1. Klicken Sie mit der rechten Maustaste auf die Geodatabase, für die Sie Benutzerberechtigungen gewähren möchten.
  2. Klicken Sie auf Verwaltung und dann auf Berechtigungen.
  3. Wählen Sie aus der Liste im Dialogfeld Berechtigungen den gewünschten Benutzer bzw. die Gruppe aus.
  4. Click the appropriate role:
    • Keine: Kein bestimmter Zugriff auf die Geodatabase oder die Datasets in der Geodatabase.
    • Nur Lesen – Der Benutzer kann Daten nur anzeigen und auswählen.
    • Lesen/Schreiben – Der Benutzer kann vorhandene Datasets in einer Geodatabase anzeigen und ändern sowie neue Datasets erstellen.
    • Admin – Der Benutzer kann Verwaltungs-Tasks in einer bestimmten Geodatabase ausführen.
    • Serveradministrator – Dieser Benutzer verwaltet den Datenbankserver.
  5. Click Apply.

Configuring the database in ArcSDE

You need to configure the MAXBLOBSIZE and TCPKEEPALIVE parameters for the ArcSDE geodatabase used as the product library. The product library can be set up in a central or local geodatabase. A central geodatabase is usually an ArcSDE geodatabase with Oracle, SQL Server, SQL Server Express, or another enterprise DBMS installed. A local geodatabase is usually an ArcSDE geodatabase with SQL Server Express installed locally to house and manage the product library.

The DBMS used for the geodatabase should be configured before the product library is set up with the default geometry storage. See geodatabase storage in relational databases or geodatabase parameters for more information.

The MAXBLOBSIZE value is -1 by default. However, if you are using Oracle or another enterprise DBMS, make sure that this value is set to -1 and the TCPKEEPALIVE value is set to 1. This command should be used from the command prompt of a machine where ArcSDE is installed.

For example:

sdeconfig -o alter -v MAXBLOBSIZE=-1-i <service> -u sde -p <sde_password>

For more information, see the ArcSDE Administration Command Reference.

You can download a Portable Document Format (PDF) version of the book from the ESRI Support Center Web site (login required): ArcSDE Server documentation

HinweisHinweis:

The ArcSDE documentation refers to the parameter name as Property Name in the command line examples.

Use the steps below if you are using SQL Server Express or SQL Server to configure the MAXBLOBSIZE and TCPKEEPALIVE parameters.

Schritte:
  1. Open SQL Server Management Studio Express.
  2. Click Connect on the Connect to Server dialog box that appears.
  3. Expand Databases, the geodatabase you are using for the product library, and Tables.
  4. Right-click on the SDE_server_config table and click Edit Top 200 rows.
  5. Find MAXBLOBSIZE in the prop_name field and change it to -1 in the num_prop_value field if it is another value.
  6. Find TCPKEEPALIVE in the prop_name field and change it from 0 to 1 in the num_prop_value field.
    VorsichtVorsicht:

    If you are using a local geodatabase and you modify the parameters while the Catalog window is open, you need to refresh (or disconnect and reconnect to) your SQL Server Express instance to confirm that the geodatabase has the new settings. You can right-click the database server and click Refresh.

  7. Close SQL Server Management Studio Express.

Defining and upgrading the geodatabase as a product library

After the geodatabase has been created, various tables and feature classes that are part of the product library need to be added to it. This process can be completed in ArcMap.

The steps in this section are for defining and upgrading the geodatabase as a product library in ArcMap.

Schritte:
  1. Start ArcMap.
    TippTipp:

    If the ArcMap - Getting Started dialog box appears, you can open a new or existing map document. You can also check the Do not show this dialog box in the future check box and click Open.

  2. On the main menu, click Customize > Production > Production Properties.

    The Production Properties dialog box appears.

  3. If necessary, click Data Management.
    Data Management pane on the Production Properties dialog box
    4. HinweisHinweis:

    By default, the Nautical Solution automatically sets a preconfigured file geodatabase product library in the Product Library Workspace property. Continue with the steps to choose an ArcSDE product library.

  4. Click the cell next to Workspace in the Product Library section and click the ellipsis (...) that appears.

    The Please browse to the location of the Product Library Workspace dialog box appears.

  5. Navigate to the product library database.
  6. Click Open.

    The Upgrade Workspace dialog box appears.

  7. Click Yes to upgrade the geodatabase you want to use as the product library.

    The Product Library Workspace Upgrade window appears and displays a progress bar while the geodatabase is updated. The Production Properties dialog box appears once the process is complete.

  8. Click OK.

Adding required tables to the product library geodatabase

Since you are not using the preconfigured nautical product library, you need to copy the PLTS_UCE_ and ELM_ tables into the new product library geodatabase you created. The PLTS_UCE_ tables are used for rounding rules, unit conversions, and so on. ELM_ tables are used for database elements in cartographic production.

Creating a personal or file geodatabase

You need to create a personal or file geodatabase to import the preconfigured product library and copy the required tables from it.

Schritte:
  1. Click the Catalog window button Fenster "Katalog" on the Standard toolbar in ArcMap.
  2. Expand:
    • Database Connections if using an Oracle, SQL Server, or another enterprise geodatabase
    • Database Servers if using a SQL Server Express geodatabase
  3. Right-click the folder in the Catalog tree where you want to create the new geodatabase, point to New, then click one of the following:
    • Personal Geodatabase—If you want to create a personal geodatabase
    • File Geodatabase—If you want to create a file geodatabase

    ArcCatalog creates a new geodatabase in the location you selected.

  4. Type the name for the new geodatabase.
    TippTipp:

    You can also rename the new geodatabase by right-clicking the new geodatabase name and choosing Rename.

Importing the Product Library XML workspace for the Nautical Solution

Once you have created a personal or file geodatabase, you can import the preconfigured product library.

Schritte:
  1. Expand:
    • Database Connections if using an Oracle, SQL Server, or another enterprise geodatabase
    • Database Servers if using a SQL Server Express geodatabase
  2. Double-click the product library administrator connection geodatabase to connect to it.
  3. Right-click the geodatabase you just connected to and choose Import > XML Workspace Document.
  4. Click the Data option if necessary.
  5. If you are trying to set up the product library for ENC and Chart products, perform the following sub steps:
    1. Browse to the appropriate location:
      • On Windows XP, browse to <Installation location>\Documents and Settings\All Users\Application Data\ESRI\Production10.0\ProductLibraryFiles
      • On Windows Vista, Windows 7, and Windows Server 2008, browse to <Installation location>\Documents and Settings\All Users\AppData\Roaming\ESRI\Production10.0\ProductLibraryFiles

    2. Unzip the NAUTICAL_PRODUCT_LIBRARY_V10.0.0.0_GX.XML.ZIP file.
    3. open NAUTICAL_PRODUCT_LIBRARY_V10.0.0.0_GX.XML.

    The version information at the end of the file name represents the release the model was associated with. It is recommended that you always use the latest version. The first two values, 10, represent the major release value. The second value represents the minor release value. The third value represents the service pack value, and the fourth value represents a patch. For example, 93.0.1.0 represents 9.3 Service Pack 1.

    For AML products, the AML_PRODUCT_LIBRARY_V10000000_GX.XML.ZIP file should be used.

  6. Click Next and click Finish.

    The XML will take a few minutes to import.

Copying the tables into the product library geodatabase

You will need to copy the required tables from the preconfigured product library into the product library geodatabase you created.

Schritte:
  1. Click the personal or file geodatabase to view its contents.
  2. Select the following tables:
    • PLTS_UCE_MAPPINGS
    • PLST_UCE_CONVERSIONS
    • PLTS_UCE_ROUNDINGRULES
    • ELM_CATEGORIES
    • ELM_ELEMENTS
    • ELM_PRODUCTS
    • ELM_SOLUTIONS
  3. Right-click all the selected tables and click Copy.
  4. Navigate to the destination product library geodatabase.
  5. Right-click and click Paste.

Granting privileges to product library components

All the tables in the product library need to have read/write privileges assigned to them, except the PCAT_PERMISSION table. The PCAT_PERMISSION table only needs read privileges assigned to it.

The permissions need to be assigned to the CKB_USERS role.

Both the administrator and other user accounts in the underlying database management system should have appropriate privileges and roles assigned to them. When you set up your connection to your spatial database, ensure you are connecting as the appropriate user.

Schritte:
  1. Start ArcCatalog.
  2. Expand one of the following:
    • Database Servers if using a SQL Server Express geodatabase
    • Database Connections if using an Oracle, SQL Server, or another enterprise geodatabase
  3. Double-click the product library administrator connection geodatabase to connect to it.
  4. Select all tables except PCAT_PERMISSION, right-click, then click Privileges.
  5. Type CKB_USERS into the text box on the Privileges dialog box.
  6. Check the check box next to SELECT, UPDATE, INSERT, and DELETE.
  7. Click OK.
  8. Select PCAT_PERMISSION, right-click, then click Privileges.
  9. Type CKB_USERS into the text box on the Privileges dialog box.
  10. Check the check box next to SELECT.
  11. Click OK.

Versioning within product library

You need to register product library components for versioning to allow them to be editable.

You need to register the product library feature classes and tables for versioning.

Schritte:
  1. Start ArcCatalog.
  2. Expand one of the following:
    • Database Servers if using a SQL Server Express geodatabase
    • Database Connections if using an Oracle, SQL Server, or another enterprise geodatabase
  3. Double-click the product library administrator connection geodatabase to connect to it.
  4. Right-click each feature class in your product library and choose Register as Versioned.

    Do not check the Register the selected objects with the option to move edits to base check box.

  5. Click OK.
  6. Right-click each table in your product library and choose Register as Versioned.

    If you are using the Nautical Solution, do not register the following tables as versioned:

    • ELM_CATEGORIES
    • ELM_ELEMENTS
    • ELM_PRODUCTS
    • ELM_SOLUTIONS
    • PLST_UCE_CONVERSIONS
    • PLTS_UCE_MAPPINGS
    • PLTS_UCE_ROUNDINGRULES

    Do not check the Register the selected objects with the option to move edits to base check box.

  7. Click OK.

Creating database connections for product library users

Database connections need to be created for the other product library users if the product library is stored in Oracle, SQL Server, or another ArcSDE geodatabase licensed through ArcGIS Server Enterprise. If your product library is stored in SQL Server Express, you can skip this section, since other users will only need to add a database server connection (first section of this workflow).

If you want to create a database connection for SQL Server, go to Making a direct connection from ArcGIS Desktop to a geodatabase in SQL Server. If you want to create a database connection for Oracle, go to Making a direct connection from ArcGIS Desktop to a geodatabase in Oracle.

HinweisHinweis:

For step 6, if using database authentication, type the user name of the product library user for which you want to create a database connection.

Once you have performed all the steps in this workflow, the product library workspace is ready for you to create the solution, product class, series, and users and user permissions. Other users still need to define the product library workspace in their client machine to be able to create and manage data and/or products.


Copyright © 1995-2010 Esri. Alle Rechte vorbehalten.
9/17/2010