New Updates

In Between I have stopped updating this Blog. If you think information provided is helpful please comment on the pages so that i will start updating again

How to run the sql scripts on SHR

Login to SHR server with administrative privilages

go to Start -> Run then type dbisql.exe

Make sure the ODBC data source name is selected as SHRDB.

press connect. (if you are using the default DSN created during the installation no need to input the username and password)

Once it is connected to DB.

go to file menu -> run script  and browse and select the script.  This will run the script and provide the output to default location which is this case C:\HP-SHR\Sybase\IQ15_4\Bin64

In the above screenshot this items are marked in red color. Cut the output file from this location and send it to HP (Make sure this location clean and remove the output files from this location after the activity)

How to customize the first DayOfWeek in SHR/Sybase IQ?

How to customize the first DayOfWeek in SHR/Sybase IQ?   Setting the first day of the week is not technically a setting in SHR. This setting is at the Sybase IQ level, and changes must be made in the database.   The Sybase IQ option DATE_FIRST_DAY_OF_WEEK is, by default, 0, making Sunday the default first day of the week. This option could be set to any of the following values, as appropriate:   DATE_FIRST_DAY_OF_WEEK Value First Day 0 Sunday 1 Monday 2 Tuesday 3 Wednesday 4 Thursday 5 Friday 6 Saturday   The following SQL code may be run in dbisql.exe to change this setting on the pmdb database:    set option DATE_FIRST_DAY_OF_WEEK = 1   Change option in this way affect only current user, so you must connect to DB as pmdb_admin user.   update datetime set week_boundary=case when (datepart(mi,time_full_date) = 0 and                          datepart(hh,time_full_date) = 0 and                          datepart(dw,time_full_date) = 1) then 1               else 0               end; commit   We must also recalculate week numbers to shift Sundays and Mondays to properly weeks. update DATETIME SET TIME_WEEK_NUMBER=datepart(cwk, TIME_FULL_DATE) commit

Data Colection Stops after some time SHR 9.30

On SHR 9.30 i had an issue. Data collection is getting stoped every now and then. Raised a case with HP on this and they found this as a know issue.

If you are having similar issue check for the below error

2013-12-29 11:20:25,380 ERROR, com.hp.bto.bsmr.collection.utils.RollingFileWriter.forceFlush , Error in flushing file C:\HP-SHR\PMDB/extract/\ALL_VIEWS_0_cmdbviews_0_584358474342500.csv

java.io.IOException: This instance of the CsvWriter class has already been closed.

if this is the case there is hotfix available for this . Please be in touch HP support for the hot fix

Sujesh

Oracle Content Pack Error

If you are installing Oracle Content pack on SHR 9.30 over a period of time SHR Infoview will produce an error "Partial-Results".
Same time report genration will be extremly Slow.
I had this issue and Raised case with Support. Looks like it is a known  issue.

QCCR1A171394- duplicate records in k_ci_group_bridge table.

Please check the above for more details and raise a case with HP with details support will provide a solution

SHR Utlities

SHR provide a log viewer utility which is very  good when you need to check some of the log files for a specifica word or ERROR Level.

This utility is available in C:\HP-SHR\PMDB\bin\LogViewer.exe

If you are not aware of this please check it.

SHR Tables and Aggregation -Information

This is Just an information i found it.. This major change is not uddated any in of the documents . So though of sharing with people.

In SHR 9.30 there is no Monthly and above tables. SHR 9.20 had Monthly tables but from 9.30 onwards the aggregation is done in the front end where mponthly and yearly data will be aggregated and presented in the Business Objects level.


Sujesh