UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

Deploy UCMDB 10.1x with PostgreSQL DB

Advisor

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)

 

 

1 REPLY
HPE Expert

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
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.
//Add this to "OnDomLoad" event