BMC Communities Banner
Up to Discussions in Knowledge Module Development

This Question is Possibly Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (5 pts)
4 Replies Last post: Oct 25, 2009 9:29 AM by Mohamed Nabil Ali  
Mahesh Participant
Mahesh
26 posts since
Feb 2, 2009
Currently Being Moderated

Apr 23, 2009 8:28 PM

History Loader and Propogator

Is there any document which can help me in configuring the History loader and propogator? And I have have loads and loads of data that is getting monitored by the 200 Patrol Agents for my application. Once I configure them use push the data in the MS SQL Servers using the History loader and propogator , how do I start reporting? Is there any web view by default available or do I need to build one for my self?

 

Any quick response will be appreciated and all the points will be awarded :)

rasto danis Expert
rasto danis
1,025 posts since
Mar 13, 2001
Currently Being Moderated
1. Apr 24, 2009 3:31 AM in response to: Mahesh
Re: History Loader and Propogator

there is a doc named PATROL History Loader Knowledge Module User Guide, that is a part of PM for servers documentation

product functionality ends with data in database table, it's completely up to you how you will manage that data

if you need some other functionality - take look at pm reporting which can aggregate data more efficiently and also provides oracle db for data & bo for reporting

Report Abuse
Mahesh Participant
Mahesh
26 posts since
Feb 2, 2009
Currently Being Moderated
2. Apr 24, 2009 2:29 PM in response to: rasto danis
Re: History Loader and Propogator

 

20090424112638 PatrolAgent-I-EUSER: ExecuteCommand: Couldn't execute command of type 'SQL'

20090424112638 MSSQLSERVER_History_Loader.MSSQLSERVER_History_Loader Command, Line# 339: execute: couldn't execute SQL command

20090424112638 CREATE VIEW p_view (

20090424112638 node_name,

20090424112638 app_name,

20090424112638 instance_name,

20090424112638 parameter_name,

20090424112638 time_stamp,

20090424112638 value)

20090424112638 AS

20090424112638 select pa.node_name,

20090424112638 pa.app_name,

20090424112638 pi.instance_name,

20090424112638 pa.parameter_name,

20090424112638 ph.timestamp,

20090424112638 ph.value

20090424112638 from p_apps pa,

20090424112638 p_instances pi,

20090424112638 p_history ph

20090424112638 where pa.app_id = ph.app_id

20090424112638 and pi.instance_id = ph.instance_id

20090424112638 go

20090424112638

20090424112638 PSL function <execute> failed.

20090424112638 Fri Apr 24 11:26:38 2009 : View creation complete.

 

I have configured the MS SQL Server HOME directory to the path where the OSSQL is available in the Microsoft SQL Server directory.

Please let me know hwat is going wrong?

 

 

Report Abuse
JamLin Participant
JamLin
4 posts since
Jun 10, 2009
Currently Being Moderated
3. Sep 27, 2009 3:59 AM in response to: Mahesh
Re: History Loader and Propogator

Hi Mahesh,

 

I occur the same issue with you.

 

Have you resolved this issue right now?

 

I found out the possible reason with this issue.

Refer to the following URL:

http://documents.bmc.com/supportu/documents/33/57/53357/53357.pdf

 

This is the PATROL History Loader User Guide.

PATROL HL KM System Requirement Table is P.23 in this documention.

The supported RMBMS is Microsoft SQL Server 7.0 and 2000.

 

Do you install the Microsoft SQL Server 2005?

 

Vic

Report Abuse
Mohamed Nabil Ali Participant
Mohamed Nabil Ali
7 posts since
Oct 25, 2009
Currently Being Moderated
4. Oct 25, 2009 9:29 AM in response to: Mahesh
Re: History Loader and Propogator

Well I was reading this post as I had the same issue, but i could solve it. So i thought i would share my findings:

I am running MSSQL 2005

Make sure you have configured the MSSQLSERVER Path correctly. In my case it is: "C:\Program Files\Microsoft SQL Server\90\"

That should work perefectly, if not check the error logs of the agent, as it will provide you with some useful info.

Report Abuse

Advertisement

More Like This

  • Retrieving data ...