topic HPSIM 4.1 with remote Database(sql2000) in Server Management - Systems Insight Manager

HPSIM 4.1 with remote Database(sql2000)

Vivek_21 — Wed, 21 Jul 2004 05:42:49 GMT

Hi There,

I am wondering if anybody tried using remote db with HPSIM 4.1.

I have been trying this bit the install never seem to be over while doing that, works fine with MSDE, but i dont want to use that as it will increase the overhead on my CMS box.

Cheers
Vivek

Re: HPSIM 4.1 with remote Database(sql2000)

Joel Rubenstein — Wed, 21 Jul 2004 07:57:20 GMT

Yes HP SIM 4.1 works fine with remote SQL 2000 databases. Can you be more specific about the installation error?

Re: HPSIM 4.1 with remote Database(sql2000)

Vivek_21 — Thu, 22 Jul 2004 04:01:08 GMT

Hi,

It doesnt throws any error/exception, but after creating database and schema(SIM install) it gets stuck at a screen(Initailizing install), I am trying to use a remote database MS sql 2000 sp3 running on windows 2000 sp4.

The server i am installing HPSIM is running Windows 2003 with sql client tools.

I have tried to install this configuration at least three times and it always shows the same thing.

Any help will be much appreciated.

Cheers
Vivek

Re: HPSIM 4.1 with remote Database(sql2000)

Joel Rubenstein — Thu, 22 Jul 2004 08:59:11 GMT

The problem occurs because when the SIM database is created it uses the collation sequence specified during the SQL 2000 installation. If that collation sequence had been changed from the default (SQL_Latin1_General_CP1_CI_AS) then the SIM installer has problems when creating the necessary database tables.

If you look in the file initconfig.log (before aborting the hung installation) you will see errors like the following.

Creating database 'Insight_v1_0_162058859'...
Creating schema...
*** WARNING: FAILED the following SQL command:
====
CREATE index notice_st_dev_sv_index on notices(State, deviceKey,
noticeseverity)
====
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]
Column name 'deviceKey' does not exist in the target table.
*** WARNING: FAILED the following SQL command:
====
CREATE INDEX trap_rcv_lu_index on trapitems (trap_enterprise,
trap_generic_id, trap_specific_id)
====
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]
Cannot create an index on 'trapitems', because this table does not
exist in database 'Insight_v1_0_162058859'.
*** WARNING: FAILED the following 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 )

To successfully install SIM on SQL 2000 you will need to create a new database instance using the default collation sequence.

Re: HPSIM 4.1 with remote Database(sql2000)

Vivek_21 — Mon, 26 Jul 2004 06:09:59 GMT

Cheers Joel,

Thanks very much for the info.