Highlighted
Honored Contributor.
Honored Contributor.
416 views

Deploy UCMDB 10.1x with PostgreSQL DB

With an OOTB deployment,we have a lot of unbound history tables and it is not possible to change size of an attribute. The queries to update DB are wrong.

 

In cmdb.dal.error.log

 

2014-09-11 14:12:39,458 [qtp1467732304-1894] 959765396 Can't execute statement [ALTER TABLE HDM_140710RUNNING_SOFTWARE_1 ALTER COLUMN A_VERSION VARCHAR(151)], due to
exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near "VARCHAR"
Position: 65

 

PG log

 

2014-09-11 14:11:46 CEST ERROR: syntax error at or near "VARCHAR" at character 65
2014-09-11 14:11:46 CEST STATEMENT: ALTER TABLE HDM_140710RUNNING_SOFTWARE_1 ALTER COLUMN A_VERSION VARCHAR(151)

 

 

Tags (1)
0 Likes
1 Reply
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: Deploy UCMDB 10.1x with PostgreSQL DB

This is a known problem. The defect is here . The solution will be delivered with future CUPs.

If you raised case with support already, please send me a case number in PM. I'll take care.

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
0 Likes
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.