Catalog Access Guidelines

Access issues can arise when multiple clients are making requests to an instance of Essbase Studio Server if one of the clients is in the process of scraping a data source for metadata elements. When scraping a data source, Essbase Studio requires exclusive access to the catalog in order to add the metadata derived from scraping. Other requests from Essbase Studio clients—such as login requests, viewing or editing hierarchies or dimension elements—must wait until scraping is completed in order for Essbase Studio Server to process other requests.

You can configure the amount of time clients must wait before being prompted that the request cannot be executed. See server.readLockTimeOut and server.writeLockTimeOut for more information.

You may also choose to unlock the catalog during the scraping process by selecting the “Lock catalog during exploration” check box in the Select Tables page of the Connection Wizard, as described in Selecting Tables for Relational Sources.