Cannot see page timer with a long name in the Metric list of the synthetic metric rule

With adjustments to the Postgres database on the App Visibility portal, you can use page timer names that are longer than 255 characters.

Issue

With TrueSight Synthetic Monitor, a page timer with a name that is longer than 255 characters is not displayed in the Metric list of the synthetic metric rule.

Probable cause

The default settings of the Postgres database limits the string length to 255 characters.

Resolution

Back up the Postgres database on the App Visibility portal and increase the column width in the database.

For Windows

1. Log in to the App Visibility portal computer.

2. Back up the App Visibility database.

    Click here to see steps.

   1. On the computer with the App Visibility portal, navigate to the portal_installationDirectory\portal\bin\db directory.
      If the portal and collector are installed on the same computer, they share a database, and you only need to perform the procedure in one place.
   2. Run the following script:
      create-pgsql-dump.bat

   The script creates a backup of the data in the avdb.dump file in the installationDirectory\ADOP_DB\pgsql\backup directory.

   For more information, see Backing up and recovering the App Visibility database.

3. Navigate to the portal_installationDirectory\ADOP_DB\pgsql\bin directory.
   The default directory is C:\Program Files\BMC Software\App Visibility.

4. To access the database, run the following command:

   psql.exe -U postgres -p 8800 avdb

   The default database port is 8800. If you changed the value, use your port number.

5. To increase the column width, run the following command:

   ALTER TABLE portal.synthetic_metric_stats ALTER COLUMN metric_name TYPE VARCHAR(320);

6. To quit, enter \q

For Linux

1. Log in to the App Visibility portal computer as a postgres user, or as a root user and then su postgres.

2. Back up the App Visibility database.

    Click here to see steps.

   1. On the computer with the App Visibility portal, navigate to the portal_installationDirectory/portal/bin/db directory.
      If the portal and collector are installed on the same computer, they share a database, and you only need to perform the procedure in one place.
   2. Run the following script:
      ./create-pgsql-dump.sh

   The script creates a backup of the data in the avdb.dump file in the installationDirectory/ADOP_DB/pgsql/backup directory.

   For more information, see Backing up and recovering the App Visibility database.

3. Navigate to the portal_installationDirectory/ADOP_DB/pgsql/bin directory.
   The default directory is /opt/bmc/App_Visibility.

4. To access the database, run the following command:


   ./psql -h localhost -p 8800 avdb

   The default database port is 8800. If you changed the value, use your port number.

5. To increase the column width, run the following command:

   ALTER TABLE portal.synthetic_metric_stats ALTER COLUMN metric_name TYPE VARCHAR(320);

6. To quit, enter \q