Search <book_title>...

APTARE IT Analytics Installation and Upgrade Guide for Linux

Last Published: 2022-09-01

Product(s): APTARE IT Analytics (10.6)

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;