Cathy2014 Frequent Contributor.
Frequent Contributor.

(DP) Support Tip: Listing media pools in GUI fails

listing media pools in GUI fails with:

ERROR: integer out of range
  Where: PL/pgSQL function "calc_pool_parameters" line 10 during statement block local variable initialization

[Policy AgeLimit, MaxOverwrites] were overrided with large numbers, when no such parameters was specified in omnimm -modify_pool command.

Overflow happened in SQL script because of wrong large values.


Already have hotfix QCCR2A63914. but customer didn't want to install patch, he want an workaroud only.

fixed the issue with the pools using below workaroud.

Updated all of the existing pools with fresh media condition factors via command line and now we can see all of our pool information again.

LTO Pools:

omnimm -modify_pool  App+Loose 36 250

StoreOnce Pools:

omnimm -modify_pool  Loose 777 9999

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.