The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
UCMDB and UD Practitioners Forum (Previously CMS)
cancel
Showing results for 
Search instead for 
Did you mean: 

Deploy UCMDB 10.1x with PostgreSQL DB

Highlighted
tbriet
Super Collector

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
Dima Gomel
New Member

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