SIM Installation - Database configuration failed

Patrice D P — Wed, 22 Jul 2009 13:58:44 GMT

Hi,
The installation of SIM 5.3 failed ..

In initconfig.log :

7. Database Configuration
Connecting to database ..
Dropping database 'Insight_v50_0_164259491' ..
Creating database 'Insight_v50_0_164259491'..
Creating schema 'schema40.sql' ..
WARNING - Got exception from the SQL command:CREATE index notice_st_dev_sv_index on notices(State, deviceKey, noticeseverity) The exception is:
java.sql.SQLException: Le nom de colonne 'deviceKey' n'existe pas dans la table ou la vue cible.
WARNING - Got exception from the SQL command:CREATE INDEX trap_rcv_lu_index on trapitems (trap_enterprise, trap_generic_id, trap_specific_id) The exception is:
java.sql.SQLException: L'objet "trapitems" est introuvable, car il n'existe pas ou vous ne disposez pas des autorisations requises.
WARNING - Got exception from the SQL command:create view notices_view as ( select devices.Name as 'Device Name', 'Severity' = case when noticeSeverity=100 then 'Informational' when noticeSeverity = 1 then 'Normal' when noticeSeverity=2 then 'Warning' when noticeSeverity=3 then 'Minor' when noticeSeverity=4 then 'Major' when noticeSeverity=5 then 'Critical' else convert(char(10), noticeSeverity) end, 'state' = case when state=1 then 'Discovered' when state=2 then 'Not Cleared' when state = 5 then 'Cleared' when state = 6 then 'IN Progress' end, generated, cleared, largeValue as Description from notices, noticeType, devices, stringresource, stringtablelarge where notices.noticeType = noticeType.noticeType and notices.deviceKey = devices.deviceKey and stringresource.resourceclassname='noticetype' and stringresource.resourceName='description' and noticeType.noticeType=stringresource.subclass and stringtablelarge.id = stringresource.id ) The exception is:
java.sql.SQLException: Nom d'objet 'stringresource' non valide.
WARNING - Got exception from the SQL command:create view view_deviceAssociations as ( select 'associatedDeviceKey'=deviceKey, 'DeviceKey'=device_associations.deviceKey1 , 'associatedDeviceName'=RTRIM(name), 'associatedDeviceStatus'=overallstatus, 'associatedDeviceType'=producttype, 'AssociationTypeNumber'=AssociationTypeNumber from device_associations LEFT OUTER JOIN devices ON (device_associations.deviceKey2= devices.deviceKey ) ) The exception is:
java.sql.SQLException: Nom de colonne non valide : 'deviceKey2'.
WARNING - Got exception from the SQL command:INSERT FolderQueryStatusPolicy(type,className) Values (1,'com.hp.mx.core.foldermanager.QueryStatusBySeverityPolicy') The exception is:
java.sql.SQLException: Nom d'objet 'FolderQueryStatusPolicy' non valide.
......
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' ..
..Done
8. Database Content
ERROR - null
Completed with error.

Details can be found in the log files at: C:\Program Files\HP\Systems Insight Manager\logs
-------------- Date = mercredi 22 juillet 2009 16 h 49 CEST
-------------- Operation = Configure
========== End Initial Configuration Record ==========

is that someone can help me ?
thanks

Re: SIM Installation - Database configuration failed

Patrice D P — Wed, 22 Jul 2009 14:17:08 GMT

the result of mxinitconfig -a

Re: SIM Installation - Database configuration failed

Patrice D P — Thu, 23 Jul 2009 13:24:48 GMT

I found !
when i installed SQL server, i choose in "collation settings" binary order base on code point comparaison 850 multilingual
The script schema40.sql is executed but case sensitive !
In collation settings, i choose French and i have no problem for instalaltion of SIM !
:)

topic SIM Installation - Database configuration failed in Server Management - Systems Insight Manager

SIM Installation - Database configuration failed

Re: SIM Installation - Database configuration failed

Re: SIM Installation - Database configuration failed