HPSIM 6.3 : Error when starting (Cannot initialize / populate DB)

[khaled_jamel]

Hi every one

im trying to install HPSIM 6.3 on a centos 6.2 64bit after resolving some error related to libstdc and hostname resolve and after executing /opt/mx/bin/mxinitconfig -a i got an error in 15 step :  Initialization and Database Population ............ Failed

in /var/opt/mx/logs/ i cant found a clear reason for the error, this is the log :

Configuring Server Components (15):
  1. Check Kernel Parameters
 ..Done
  2. Node Security File
 ..Done
  3. Server Property File
 ..Done
  4. Server Authentication Keys
 ..Done
  5. SSH Keys
 ..Done
  6. Status Property File
 ..Done
  7. Task Results Output Cleanup
 ..Done
  8. Database Configuration
Connecting to database ..
Dropping database 'insight_v1_0' ..
Creating database 'insight_v1_0'..
Creating schema 'schema40.sql' ..
WARNING - Got exception from the SQL command:CREATE TABLE groups ( GroupId int NOT NULL CONSTRAINT DF_groups_GroupId_9__13 DEFAULT (0), Name nchar (70) NOT NULL CONSTRAINT DF_groups_Name_7__13 DEFAULT (' '), Static smallint NOT NULL CONSTRAINT DF_groups_Static_8__13 DEFAULT (1), Description varchar (255) NOT NULL CONSTRAINT DF_groups_Description_5__13 DEFAULT (' '), Created timestamp NOT NULL CONSTRAINT DF_groups_Created_6__13 DEFAULT ('12/31/1999'), LastModified timestamp NOT NULL CONSTRAINT DF_groups_LastModified_4__13 DEFAULT ('12/31/1999'), GroupEstablished smallint NOT NULL CONSTRAINT DF_groups_GroupEstablishe3__13 DEFAULT (0), aclId int NOT NULL CONSTRAINT DF_groups_aclId_1__13 DEFAULT (0), creatorUserId int NOT NULL CONSTRAINT DF_groups_creatorUserId_2__13 DEFAULT (0), filterId int NOT NULL CONSTRAINT DF_groups_filterId_1__13 DEFAULT (0), CONSTRAINT PK_groups_1__12 PRIMARY KEY ( GroupId ) ) ;	The exception is:
org.postgresql.util.PSQLException: ERREUR: Valeur du champ date/time en dehors des limites : «12/31/1999»

Creating schema 'DCSchema10.sql' ..
Creating schema 'schema40_41.sql' ..
Creating schema 'schema41_42.sql' ..
Creating schema 'schema42_50.sql' ..
Creating schema 'schema50_51.sql' ..
Creating schema 'schema51_52.sql' ..
Creating schema 'schema52_53.sql' ..
Creating schema 'schema53_54.sql' ..
Creating schema 'schema60_61.sql' ..
Creating schema 'schema61_62.sql' ..
Creating schema 'schema62_63.sql' ..
Creating view 'schema40.sql' ..
Creating view 'DCSchema10.sql' ..
Creating view 'schema40_41.sql' ..
Creating view 'schema41_42.sql' ..
Creating view 'schema42_50.sql' ..
Creating view 'schema50_51.sql' ..
Creating view 'schema51_52.sql' ..
Creating view 'schema52_53.sql' ..
Creating view 'schema53_54.sql' ..
Creating view 'schema60_61.sql' ..
Creating view 'schema61_62.sql' ..
Creating view 'schema62_63.sql' ..
 ...Done
  9. Database Content
 ..Done
  10. Web Server
 ..Done
  11. Setup Property File
 ..Done
  12. JBoss Setup
 ..Done
  13. Agent Configuration
 ..Done
  14. Management Services
 ..Done
  15. Initialization and Database Population

HP Systems Insight Manager Initialization Starts at: mardi 13 janvier 2015 13 h 07 CET
ERROR - Cannot start HP Systems Insight Manager service.
Possible cause: HP Systems Insight Manager service is not properly installed.
Resolution: Make sure HP Systems Insight Manager service is correctly installed, restart HP Systems Insight Manager then run mxinitconfig again.
Details can be found in the log files at: /var/opt/mx/logs
 ............Failed
Exception   :Configuration failed to complete due to the following exception:
    Cannot start HP Systems Insight Manager service.
Possible cause: HP Systems Insight Manager service is not properly installed.
Resolution: Make sure HP Systems Insight Manager service is correctly installed, restart HP Systems Insight Manager then run mxinitconfig again.
Details can be found in the log files at: /var/opt/mx/logs
Completed with error.

Details can be found in the log files at: /var/opt/mx/logs
-------------- Date = mardi 13 janvier 2015 13 h 07 CET

 i can attache file or give any other details if needed, thanks for your help

[Andrew_Haak]

Hello Is the database remote or local ? Oracle or SQL ? The 6.3 is not the latest version for Linux based OS.

Look here for the latest version : http://h20566.www2.hp.com/hpsc/doc/public/display?docLocale=en_US&docId=emr_na-c04462878