SQL Net Connect String Error

About this task

If you get the error "The SQL Net connect string shown on the Analytics catalog is BLACKHOLE after installing the IBM® Sterling Warehouse Management System Analytics on a fresh server" when trying to open the catalog:

The catalog's available user classes do not correspond to any defined by the Common Logon Server"

Follow these steps to ensure that the YNA-catalog can be opened:

Procedure

  1. Launch the Access Manager Administrator.
  2. Right-click Root User Class, select Add User Class, and perform the following functions:
    • Under the General tab enter Creator in the Name text box.
    • Select the Permissions tab and set the permissions for the Creator user class.
    • Click Apply to save the information.
    • Click OK to return to the Access Manager Administration Tree.
  3. From the Administration Tree select the folder named Users.
    • Select the user(default is administrator) that you would like to associate with the user class, right-click, and select Membership tab. Select the user class that the user belongs to. In this case the Creator user class. Alternatively you can associate the user by selecting the user named Administrator, and then drag it into the Creator user class.

Results

An error will occur if any user not belonging to a specific user class attempt to log in to the catalog, hence ensure that all the users belong to a user class before attempting to open an Impromptu® catalog.