Some DB SPI Reports are not generating in Reporter. (529 Views)
Reply
Frequent Advisor
mikeKey
Posts: 45
Registered: ‎11-28-2011
Message 1 of 7 (529 Views)

Some DB SPI Reports are not generating in Reporter.

[ Edited ]

Hello,

 

I faced with problem during the generating some reports in Reporter 4.0 (DB SPI 12).

 

I have management server - OMW 9, the report server - Reporter 4.0 with DB SPI 12.04 on MS SQL and managed node - SQL Server 2008. All of these configured and integrated.

I generate the DB SPI report for MS SQL, but some reports does not generated correctly.

For example, reports "MS SQL Active Messages - Top 20" and "MS SQL Active Message Severity" does not generate, and "MS SQL I/O - Top 20" generates and shows fine.

 

During the generating of the incorrect report I see in the log "trace.RepCrys" that the Reporter execute SQL-query:

select "DBSPI_MSGS_ACT"."SYSTEMNAME from "DBSPI_MSGS_ACT" 

 but the Reporter database doesn't have the table DBSPI_MSGS_ACT.  This is likely to cause failure.

 

How can I verify or repair  a database?

Please suggest or help.

 

Best regards,

Mikhail

 

HP Expert
BeatrizR
Posts: 119
Registered: ‎06-01-2012
Message 2 of 7 (487 Views)

Re: Some DB SPI Reports are not generating in Reporter.

Hello Mikhail,

 

DBSPI_MSGS_ACT table is created when GatherDBSPI.exe is executed. GatherDBSPI is automatically scheduled to be executed everyday by Reporter. You need to run the below command so that messages are collected with DB name as openview. Also change the gatherDBSPI schedule in the Reporter scheduler to include parameter openview. This way it will be done automatically during nightly reporter maintenance.

 

 # gatherdbspi -W openview

 

 

I hope this helps.

 

Regards,

 

Beatriz

HP Support
If you find this or any post resolves your issue, please make sure to mark it as an "Accepted as Solution".
If you liked the reply then please show this with KUDOs
Frequent Advisor
mikeKey
Posts: 45
Registered: ‎11-28-2011
Message 3 of 7 (460 Views)

Re: Some DB SPI Reports are not generating in Reporter.

Hello Beatriz,

 

Thank you for reply!

 

I tried the command "gatherdbspi -W openview" and got the error message (please find the attached screenshot).

This error is strange, because most of DB SPI reports were generated successfully except a few.

How could I start gatherDBSPI.exe correctly? Please suggest.

 

Best regards,

Mikhail

Frequent Advisor
mikeKey
Posts: 45
Registered: ‎11-28-2011
Message 4 of 7 (417 Views)

Re: Some DB SPI Reports are not generating in Reporter.

[ Edited ]

Hello experts,

 

I performed a fresh installation of the Reporter 4.0 and the DB SPI 12.04 (only MS SQL) to resolve this problem, but it had no effect. Now I can't generate some of DB SPI reports (for example, "MS SQL Active Messages - Top 20").

 

I got the following error message then run the generating of report:

 

2014.01.21 17:45:57 - (9):(4564) (c) Copyright 2004 Hewlett-Packard Development Company, L.P.
2014.01.21 17:45:57 - (9):(4564) ManagedRepcrys MS SQL Active Messages - Top 20 -x HTML4.0 
2014.01.21 17:45:58 - (9):(4564) ReportName:MS SQL Active Messages - Top 20
2014.01.21 17:45:59 - (9):(4564) Could not recognize database type
2014.01.21 17:46:00 - (9):(4564) Start the Gathering Operating Parameters Process
2014.01.21 17:46:00 - (9):(4564) MS SQL Active Messages - Top 20, HTML: webpages\mssspi\dbspisqlitoevents
2014.01.21 17:46:00 - (9):(4564) MS SQL Active Messages - Top 20,  PAGE_BREAKS: F
2014.01.21 17:46:00 - (9):(4564) MS SQL Active Messages - Top 20, DATABASE: Reporter
2014.01.21 17:46:00 - (9):(4564) MS SQL Active Messages - Top 20, SERVER: Reporter
2014.01.21 17:46:00 - (9):(4564) MS SQL Active Messages - Top 20, DB USER: openview
2014.01.21 17:46:00 - (9):(4564) MS SQL Active Messages - Top 20, REPORT Doc: reports\MSSSPI\a_dbspisqlitoevents.rpt
2014.01.21 17:46:00 - (9):(4564) End the Gathering  Operating Parameters Process
2014.01.21 17:46:03 - (9):(4564) Report Selection Formula (  {DBSPI_MSGS_ACT.APPLICATION} = "MSSQL Server"  AND  {DBSPI_MSGS_ACT.OVDBNAME} = "OVO_MGMTSRV_DB1"  )  
2014.01.21 17:46:03 - (9):(4564) Error in Report template, Record Selection must have AllDatesToToday keyword
2014.01.21 17:46:03 - (9):(4564) Modified Report Selection Formula (  {DBSPI_MSGS_ACT.APPLICATION} = "MSSQL Server"  AND  {DBSPI_MSGS_ACT.OVDBNAME} = "Reporter"  )  
2014.01.21 17:46:03 - (9):(4564) Export to HTML4.0 format
2014.01.21 17:46:04 - (9):(4564)  SELECT "DBSPI_MSGS_ACT"."SYSTEMNAME", "DBSPI_MSGS_ACT"."OBJECT", "DBSPI_MSGS_ACT"."MSGTXT", "DBSPI_MSGS_ACT"."APPLICATION", "DBSPI_MSGS_ACT"."MSG_COUNT", "DBSPI_MSGS_ACT"."OVDBNAME"
 FROM   "DBSPI_MSGS_ACT" "DBSPI_MSGS_ACT"
 WHERE  "DBSPI_MSGS_ACT"."APPLICATION"='MSSQL Server' AND "DBSPI_MSGS_ACT"."OVDBNAME"='Reporter'

2014.01.21 17:46:05 - (E):(4564) Exiting with Crystal Reports error ID : -256, message : 
Error in file a_dbspisqlitoevents {F1EFD809-0E87-4800-86BD-9EE942C955D1}.rpt:
Failed ro retrieve data from the database.
Details:  [Database Vendor Code: 208 ]
2014.01.21 17:46:05 - (9):(4564) Finish Report "MS SQL Active Messages - Top 20 -x HTML4.0 "
2014.01.21 17:46:05 - (9):(4564) End of Program

 

Then I am running "gatherDBSPI.exe" for creating the necessary tables, but the gatherDBSPI application close with the error message:

 

"The program can't start because ovtrc3.dll is missing from your computer. 
Try reinstalling the program to fix this problem".

 

Has anyone encountered a similar problem? How could I launch the gatherDBSPI.exe? How could I generate all of DB SPI reports without the errors? Any suggestions?

 

Thanks and regards,

Mikhail.

HP Expert
BeatrizR
Posts: 119
Registered: ‎06-01-2012
Message 5 of 7 (407 Views)

Re: Some DB SPI Reports are not generating in Reporter.

Hello Mikhail,

 

Do you have any other system with the same characteristics than this one from where you can copy the missing dll ovtrc3.dll?

 

Regards,

 

Beatriz

HP Support
If you find this or any post resolves your issue, please make sure to mark it as an "Accepted as Solution".
If you liked the reply then please show this with KUDOs
Frequent Advisor
mikeKey
Posts: 45
Registered: ‎11-28-2011
Message 6 of 7 (399 Views)

Re: Some DB SPI Reports are not generating in Reporter.

Hello Beatriz,

 

Thank you for reply.

 

I have the OMW9 server, the old installation of Reporter 4.0 server and the fresh installation of Reporter 4.0 server. But "ovtrc.dll" file does not exist on these servers.

 

Does anyone have this file?

 

Best regards,

Mikhail.

Frequent Advisor
mikeKey
Posts: 45
Registered: ‎11-28-2011
Message 7 of 7 (357 Views)

Re: Some DB SPI Reports are not generating in Reporter.

Hello,

This error seems like an incorrect process of DB SPI installation or DB SPI binary files. But installation logs haven't errors.

Did anyone have the same problems with DB SPIs?

Regards,
Mikhail
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.