error while upgrading usage meter 3.0.2 to 3.3.2

[vinayralph]

I'm trying to upgrade vCloud Usage Meter 3.0.2 to 3.3.2. I have followed the procedure given in the "vCloud Usage Meter User's Guide - vCloud Usage Meter 3.3".

On Importing the um from the old appliance it shows error as below

in the Error.log it shows ERROR: relation "Provider" does not exist

in the import.log it shows scp: /tmp/umxfer: No such file or directory

cp: cannot start '/tmp/umxfer/defaultks': No such file or directory

ALTER DATABASE

psql.bin:/opt/vmware/cloudusagemetering/database/migrate/302-310.sql:1: ERROR:relation "LdapServer" does not exist

ALTER TABLE

psql.bin:/opt/vmware/cloudusagemetering/database/migrate/302-310.sql:10: ERROR: relation "VcdServer" does not exist

I would like to know and understand where am I making a mistake. The steps being followed are as given in the user guide installation and upgrade sections.

[dbriccetti]

Hi. Are there any clues in the import log in /var/log/usgmtr?

[vinayralph]

Hello

Thank you for your response. the Import log is listed below.

Stopping tcSeruer

Instance is running as PID=5255, shutting down...

Instance is running PID=5255, sleeping for up to 60 seconds waiting for shutdown Instance shut down gracefully

UMware uCloud Usage Meter

scp: Ampzumxfer: No such file or directory l'optzumwarezcloudusagemeterinvencryptionzdefaultks' -> l'optzumware/cloudusage meterinvencryptionzdefaultks-20141017_141354'

cp: cannot stat 'Ampzumxfer,defaultks1: No such file or directory

cp: cannot stat 'Ampzumxfer,defaultks1: No such file or directory

alter database usgmtr rename to usgmtr_20141017_141354;

ALTER DATABASE psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:1: ERROR: relation -LdapSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:2: ERROR: relation -LdapSeruer- does not exist

CREATE TABLE psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:9: NOTICE: ALTER TABLE ADD PRIMARY KEY will create implicit index -Ucd3eruerCustomer_pke

y" for table -Ucd3eruerCustomer-

ALTER TABLE psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:10: ERROR: relation -Ucd3eruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:11: ERROR:

relation "Customer" does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:13: ERROR: relation -Ucd3eruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:14: ERROR: relation -Ucd3eruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:16: ERROR: relation -ZimbraSample- does not exist

LINE 1: delete from -ZimbraSample-;

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:17: ERROR: relation -Zimbra3ample- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:19: ERROR: relation -ZimbraServer- does not exist

psql.bin:/optzumwarezcloudusagemetering/databasezmigrate,302-310.sql:20: ERROR: relation -ZimbraServer- does not exist

psql.bin:/optzumwarezcloudusagemeterinvdatabasezmigrate,302-310.sql:21: ERROR: relation -ZimbraSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:26: NOTICE:

CREATE TABLE PRIMARY KEY will create implicit index -ZimbraEdition_pkey- for

table -ZimbraEdition-

CREATE TABLE

CREATE SEQUENCE

CREATE INDEX psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:31: ERROR:

relation -Zimbra3ample- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:33: ERROR: relation -UcopsSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,database/migrate,302-310.sql:34: ERROR: relation -UcopsSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:36: ERROR: relation -UcopsSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:49: NOTICE:

CREATE TABLE , PRIMARY KEY will create implicit index -UmHistory_pkey- for tab le -UmHistory-

CREATE TABLE

CREATE SEQUENCE psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:52: ERROR: relation "Um- does not exist

CREATE VIEW psql.bin:/optzumwarezcloudusagemetering,database/migrate,302-310.sql:61: ERROR: relation "Um- does not exist

psql.bin:/optzumwarezcloudusagemetering,database/migrate,302-310.sql:62: ERROR: relation "Um- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:63: ERROR: relation "Um- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:70: NOTICE:

CREATE TABLE , PRIMARY KEY will create implicit index -UmEuent_pkey- for table

-UmEuent-

CREATE TABLE

CREATE SEQUENCE psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:72: ERROR: relation "Um- does not exist

CREATE INDEX psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:75: ERROR: relation -UcServer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:76: ERROR: relation -UcServer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:83: NOTICE:

CREATE TABLE , PRIMARY NH will create implicit index -HorizonSample_pkey- for table -HorizonSample-

CREATE TABLE

CREATE SEQUENCE psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,302-310.sql:85: ERROR: relation -ZimbraSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:1: ERROR: relation -Email3eruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:2: ERROR: relation -Email3eruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:4: ERROR: relation -ZimbraServer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:5: ERROR: relation -ZimbraServer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:6: ERROR: relation -ZimbraSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:7: ERROR: relation -ZimbraSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:9: ERROR: relation -LdapSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:10: ERROR: relation -LdapSeruer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:12: ERROR: relation -Report3etLicenseSet- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:13: ERROR: relation -ReportSetLicenseSet- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:25: NOTICE:

CREATE TABLE PRIMARY REY will create implicit index -InuentoryItem_pkey- for

table -InuentoryItem-

CREATE TABLE

CREATE SEQUENCE

CREATE INDEX

CREATE TABLE

INSERT 0 1

ALTER TABLE

CREATE SEQUENCE psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:41: ERROR: relation "Host" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:42: ERROR: relation "HostHistory" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:43: ERROR: relation "HostHistory" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:44: ERROR: relation "HostHistory" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:51: ERROR: relation "HostHistory" does not exist

LIME 2: select * from "HostHistory" a where exists(

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:53: ERROR:

view "LicenseHostCount" does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:57: ERROR: relation "License" does not exist

LIME 2: ... Ename, 1.code, count(l.codel as "numHosts" from "License" ...

A

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:59: ERROR: relation "Host" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:60: ERROR: relation "Host" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:61: ERROR: relation "Host" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:62: ERROR:

relation "Host" does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:63: ERROR:

relation "Host" does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:67: ERROR:

relation "Host" does not exist

LIME 3: -mem3ize- from "Host" h, "HostLatestHistory" hl wher...

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:73: ERROR: relation -Um- does not exist

LIME 4: from -Um- u, -UmHistory- uh, "Host" h, "HostHistory" hh

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:86: ERROR: relation "Sample" does not exist

LIME 8: from "Sample" s, "Collection" c, "Um" u, -UmHistory- uh,...

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:88: ERROR:

relation -Ucd3eruer- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:90: ERROR:

relation -Uc3eruer- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,310-320.sql:92: ERROR:

relation "CustomerLocation" does not exist

LIME 1: update "CustomerLocation" set "countryCode" = 'GB' where "co...

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:1: ERROR: table "SrmServer" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:3: ERROR: relation -Um- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:4: ERROR: relation -Um- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:6: ERROR: table -ProtectedUmMonth- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:14: NOTICE:

CREATE TABLE PRIMARY REY will create implicit index -ProtectedUuidMonth_pkey

for table -ProtectedUuidMonth-

CREATE TABLE

CREATE SEQUENCE

CREATE INDEX psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:18: ERROR:

view "SampleToLicense" does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:20: NOTICE:

function betweenco(pg_catalog.timestamp,pg_catalog.timestamp,pg_catalog.timest amp) does not exist, skipping

DROP FUNCTION

CREATE FUNCTION psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:36: ERROR: relation "Sample" does not exist

LINE 8: from "Sample" s, "Collection" c, -Um- u, "UmHistory" uh,...

A

psql.bin:/opt,vmwarezcloudusagemetering,databasezmigrate,320-330.sql:38: ERROR: relation "Collection" does not exist

psql.bin:/opt,vmwarezcloudusagemetering/databasezmigrate,320-330.sql:40: ERROR: relation -UcServer- does not exist

psql.bin:/opt,vmwarezcloudusagemetering,databasezmigrate,320-330.sql:41: ERROR: relation -UcServer- does not exist

psql.bin:/opt,vmwarezcloudusagemetering,databasezmigrate,320-330.sql:47: NOTICE:

CREATE TABLE PRIMARY REY will create implicit index -SrmUcPair_pkey- for tab

le -3rmUcPair-

CREATE TABLE

CREATE SEQUENCE psql.bin:/opt,vmwarezcloudusagemetering,databasezmigrate,320-330.sql:50: ERROR: relation -UcServer- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:51: ERROR: relation -UcServer- does not exist

CREATE INDEX

CREATE INDEX psql.bin:/opt,vmwarezcloudusagemetering,databasezmigrate,320-330.sql:55: ERROR: view "UmHostHistory" does not exist

ALTER TABLE psql.bin:/opt,vmwarezcloudusagemetering,databasezmigrate,320-330.sql:59: ERROR: relation "Provider" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:60: ERROR:

relation "Provider" does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:61: ERROR: relation "Provider" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:70: NOTICE:

CREATE TABLE PRIMARY KEY will create implicit index -Ucac3eruer_pkey- for to

ble -UcacSeruer-

CREATE TABLE

CREATE SEQUENCE

CREATE INDEX psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:81: NOTICE:

CREATE TABLE PRIMARY KEY will create implicit index -UcacMontb_pkey- for tab

le -UcacMontb-

CREATE TABLE

CREATE SEQUENCE

ALTER TABLE

CREATE INDEX psql.bin:/optzumwarezcloudusagemetering,database/migrate,320-330.sql:86: ERROR: relation -Report3et- does not exist

psql.bin:/optzumwarezcloudusagemetering,database/migrate/320-330.sql:88: ERROR: relation -Ucd3erver- does not exist

psql.bin:/optzumwarezcloudusagemetering,database/migrate/320-330.sql:90: ERROR:

view -MontblyNewUmCount- does not exist psql.bin:/optzumwarezcloudusagemetering,database/migrate,320-330.sql:91: ERROR: table -UmMontb- does not exist

relation -Vcd3eruer- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:90: ERROR:

view -MonthlyNewUmCount- does not exist psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:91: ERROR: table -UmMonth- does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:92: ERROR: table "HostMonth" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:94: ERROR: relation "Provider" does not exist

psql.bin:/optzumwarezcloudusagemetering,databasezmigrate,320-330.sql:95: ERROR: relation "Provider" does not exist

UPDATE 0

Starting tcServer

Using CATALINA_BASE: zusr,localAcseruerzufabric-tc-server-standardzum

Using CATALINA_HOME: zusr,localAcseruerzufabric-tc-server-standard,tomcat-7.0

.35.B.RELEASE

Using CATALINA_TMPDIR: zusr,localAcseruerzufabric-tc-server-standardzum,temp

Using JDE_HOME: zusrdauazlatest

Using CLASSPATH: zusr,localAcseruerzufabric-tc-server-standard,tomcat-7.0

.35.B.DELEASE,binzbootstrap.jar:zusr,localAcseruerzufabric-tc-seruer-standardzt omcat-7.0.35.B.DELEASE,binztomcat-juli.jar

Using CATALINA_PID: zusr,localAcseruerzufabric-tc-server-standardzum,logsztc

seruer.pid

Status: RUNNING as PID=8748

Actually this is the first time I'm attempting to upgrade the vCloud UM. The old appliance was a fresh install and that too was done by someone who is not in our system anymore. Also I haven't worked on Unix/Linux for ages so this kinds of freaking me out.

Any help is greatly appreciated.

[vinayralph]

Hello,

Anyone out there who can help me understand the cause of issue listed in my previous post.
Any help is greatly appreciated.

Regards

Vinay Ralph

[dbriccetti]

Hi. I don’t understand

l'optzumwarezcloudusagemeterinvencryptionzdefaultks

That’s supposed to be a file path. Any ideas?

[KevinClawson]

Did you ever get this resolved? I am having a similar issue and VMware has been slow to respond to my ticket