HP SIM 5 Update 2 on RedHat EL 4

[JimKnopf]

I have problems with the installation of HPSIM on linux. Everything goes well until the step mxinitconfig -a. The installation ends with:
14. Initialization and Database Population .............
Failed
Details can be found in the log file at /var/opt/mx/logs/initconfig.log
Configuration failed to complete due to the following exception:
Cannot start HPSIM service or it is not operating properly

Postgres ist up and running:
postgres 19923 1 0 11:36 pts/3 00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
postgres 19925 19923 0 11:36 pts/3 00:00:00 postgres: stats buffer process
postgres 19926 19925 0 11:36 pts/3 00:00:00 postgres: stats collector process

I did this installation more than one times and followed the instruction step by step. But now I have really no idea what I should do. I hope someone could give me a good hint, to bring it up.

[Stefan John]

Jim,

We have a similiar problem when installing HP SIM 5 on RH EL 4. Unfortunately we didn't solve that problem till now.

We got the following error messages:

7. Database Configuration
Connecting to database...
Dropping database 'insight_v1_0' ..
Creating database 'insight_v1_0'..
Creating schema 'schema40.sql' ..
WARNING - *** WARNING: FAILED the following SQL command:
====
CREATE FUNCTION getdate() returns timestamp with time zone AS 'select current_timestamp' LANGUAGE 'SQL' ; ====
org.postgresql.util.PSQLException: FEHLER: Funktion »getdate« existiert bereits mit den selben Argumenttypen

WARNING - *** WARNING: FAILED the following SQL command:
====
CREATE TABLE devices ( DeviceKey int NOT NULL CONSTRAINT
DF_devices_DeviceKey_1__13 DEFAULT (0), Name varchar (255) NOT NULL CONSTRAINT DF_devices_Name_7__13 DEFAULT (' '), GUID varchar(32) NOT NULL CONSTRAINT DF_devices_GUID_3__1
3 DEFAULT (' '), Discovered bigint NOT NULL CONSTRAINT
DF_devices_Discovered_2__13 DEFAULT (0), ProductSubType varc
har(32) NOT NULL CONSTRAINT DF_devices_Type_10__13 DEFAULT (0), OverallStatus int NOT NULL CONSTRAINT DF_devices_O verallStatus_1__20 DEFAULT (10), ProductType int NOT NULL CONSTRAINT DF_devices_ProductType_1__20 DEFAULT (0), Prod uctTypeStr varchar(32) NOT NULL DEFAULT (' '), ProductName varchar (100) NOT NULL , timestamp bigint NULL , LockFla gs int NOT NULL DEFAULT (0), fullDNSName varchar(90), MxGUID varchar(32), CONSTRAINT PK___5__11 PRIMARY KEY ( Devi ceKey ) ) ; ====
org.postgresql.util.PSQLException: FEHLER: Relation »devices« existiert bereits

WARNING - *** WARNING: FAILED the following SQL command:
====
CREATE TABLE notices ( NoticeId int NOT NULL CONSTRAINT
DF_notices_NoticeId_2__13 DEFAULT (0), State int NOT NULL C ONSTRAINT
DF_notices_State_5__13 DEFAULT (0), NoticeType int NOT NULL CONSTRAINT
DF_notices_NoticeType_4__13 DEFAUL T (0), NoticeSeverity int NOT NULL CONSTRAINT DF_notices_NoticeSeverity3__13 DEFAULT (0), NoticePriority int NOT NU LL CONSTRAINT DF_notices_NoticePriority1__13 DEFAULT (0), DeviceKey int NOT NULL CONSTRAINT DF_notices_Device_1__13
DEFAULT (0), Generated bigint NOT NULL CONSTRAINT
DF_notices_Generated_1__13 DEFAULT (0), Cleared bigint N
OT NULL CONSTRAINT DF_notices_Fixed_3__13 DEFAULT (0), Completed bigint
NOT NULL CONSTRAINT DF_notices_Completed

Of course we tried the installation more than one time and we fulfilled any requirements listed in the installation manual...?