Search <book_title>...

APTARE IT Analytics Installation and Upgrade Guide for Windows

Last Published: 2022-09-01

Product(s): APTARE IT Analytics (10.6)

Attribute management during the Portal upgrade

Because you may already have attributes in your database that have names that duplicate the system names introduced in Version 10, the upgrade process must apply logic to prevent duplicate attribute names. During the Portal upgrade, the following logic is used:

In the top-level domain, if the upgrader finds an existing attribute that has a name that is the same as a new system attribute (for example, Location) it creates the system attribute and populates it with the list of values from the existing attribute.
For multi-tenancy environments where there are multiple domains, if an attribute is found in both a parent and child domain, the child domain will not inherit the values but instead, the values of the attribute in the child domain will remain intact. See also, Attribute Inheritance Overrides.
If multiple attributes with the same name are encountered in the same domain (for example, a host Location attribute and an array Location attribute), the values from all the attributes with the same name (for all objects) are merged into the system attribute.
The upgrader will list the attributes with the list of values that will be merged into the new System Attributes. You can choose to let the upgrader merge the attributes or you can stop the upgrade and use the steps provided to rename existing attributes.
See Steps to Rename Duplicate Attributes.
Merging of values ensures that all objects that have been assigned the attribute will retain this attribute with its values and therefore, reports that use the attributes will continue to work as expected.

Example of a Merge of Attribute Values

Before the upgrade:

Location attribute exists for Hosts, with a list of values: San Diego, New York, Seattle.
Location attribute exists for Arrays, with a list of values: Paris, London, Singapore.

After the upgrade:

Location system attribute has been created to replace the object-specific attributes. This system attribute will contain a merged list of values (LOV): San Diego, New York, Seattle, Paris, London, Singapore.
This list of values applies to all objects.
Once the upgrade is successful, you may want to modify the merged list of values via the Portal: Select Admin > Advanced > Attributes.

Steps to Rename Duplicate Attributes

Log in to the Portal server
At the command line:
```
su - aptare
```
At the command line, launch sqlplus:
```
sqlplus <username>/<pwd>@//localhost:1521/scdb
```
Example: sqlplus portal/portal@//localhost:1521/scdb
To rename an attribute, execute the following SQL statements, substituting <variables> with values listed in the upgrade messages:
```
UPDATE apt_attribute
SET attribute_name = <attributeName>
WHERE attribute_id = <AttributeID>;
Commit;
```
Example: This example renames the Location attribute so that it is not merged with the system attribute named Location.
```
UPDATE apt_attribute
SET attribute_name = 'Location1'
WHERE attribute_id = 100001;
Commit;
```

Best Practice for Attributes in Multi-Tenancy Environments

Maintain attributes at the top-level domain so that the attributes are available to all client/child domains.
During the Portal upgrade to Version 10.x.xx, newly introduced System Attributes will be added to the top-level domain.