TNPM/dataview

From neil.tappsville.com
Revision as of 09:28, 3 September 2019 by Gonzo (talk | contribs) (Created page with "=== Diagnostic Reports ==== * 490000026 - Element and SE and Group information * 490000033 - Metric and Formula Informantion * 100210559 - Element and SE Information similar...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Diagnostic Reports =

  • 490000026 - Element and SE and Group information
  • 490000033 - Metric and Formula Informantion
  • 100210559 - Element and SE Information similar to 490000026

Nice CSV Exports

To make the csv's easier for humans to read:

DV''UserCleanCSVResultSet|''|true|_|

resmgr -import rusr -colNames "name ruprp.name ruprp.value" -line "SSSW\\\\staging|''|DV''UserCleanCSVResultSet|''|true|''|"


Normal output:

HEADER
groupNumber, resourceNumber, mId600000-avg, mId600000-max, mId600001-avg, mId600001-max, mId600007-avg, mId600007-max, mId600008-avg, mId600008-max,
mId600000, mId600001, mId600007, mId600008, groupName, resourceName, totalNoPages, propValues, propNames, cseNumber, totalNoResources
DATA
205328513, 205869021, 55439.82716049383, 9956240.0, 0.5543982716049383, 99.5624, 0.0, 0.0, 0.0, 0.0,
Queue Throughput (bits/sec), Queue Utilization %, Queue Tail Dropped (pkts), Queue RED Dropped (pkts), SDP/RAS (IDL1005700xx), business-SDP/RAS (IDL1005700xx)(NZL-IP12e), 2.0, , , , 65.0

Nice Output:

HEADER
Queue Throughput (bits/sec)-avg, Queue Throughput (bits/sec)-max, Queue Utilization %-avg, Queue Utilization %-max, Queue Tail Dropped (pkts)-avg, Queue Tail Dropped (pkts)-max, Queue RED Dropped (pkts)-avg, Queue RED Dropped (pkts)-max, groupName, resourceName,
propValues, propNames, totalNoResources
DATA
55439.82716049383, 9956240.0, 0.5543982716049383, 99.5624, 0.0, 0.0, 0.0, 0.0, SDP/RAS (IDL1005700xx), business-SDP/RAS (IDL1005700xx)(NZL-IP12e),
 , , 65.0

Installing Silverstream Designer

Use the Silverstream Server disk - install only the designer + silverJrunner

Open Silvertream designer - authenticate to the silverstream server

Download instance - EJB JARs & Media - Jars

  • DVChartStyles.jar
  • jcschart40.jar
  • xerces.jar

Exit Silverstream designer

Add the following Windows environment variable

Variable name = AGCLASSPATH, Variable value = C:\Program Files\Silver Stream\eXtendAppServer\lib\DVChartStyles.jar;C:\Program Files\Silver Stream\eXtendAppServer\lib\jcschart40.jar;C:\Program Files\Silver Stream\eXtendAppServer\lib\xerces.jar


Dataview API Help Page

Because I can never remember it

http://host[[:port]]/database/PROVISO/[[Data View]]/Query.xml?queryType=DVHelpPage


Running Silverstream tools from a windows PC

Ensure that all silverjrunner commands have '+Xms64M +Xmx256M' after them, as they may hang trying to download content from the database otherwise if the virtual memory is set to small

DVNavigator (Report Editor)

SilverJRunner.exe +Xms64M +Xmx256M HOSTNAME:8080 PVR DVNavigator

DVUserEditor (Assign Users to groups)

SilverJRunner.exe +Xms64M +Xmx256M HOSTNAME:8080 PVR DVUserEditor

Silverstream Debug Console

SilverJRunner.exe +Xms64M +Xmx256M HOSTNAME:8080 PVR PVRDebugControl

Silverstream Management Console

smc.exe HOSTNAME:8080

No charts in reports

Check silverstream log, if the following error occurs

com.quallaby.cpe.Chart Updatter.updateFrom(Unknown Source)

The "Chart Updatter class" is in DVChartStyles.jar, it is very likely that either the jar is missing from "../dataview/jar" directory, or it is missing in the AGCLASSPATH and/or "../silverstream/.agprofile" file.


Ensure that DVChartStyles.jar, jcschart40.jar and xerces.jar are in the dataview/jar folder

Secondly, ensure that the Xvfb frame buffer is running

ps -lfea | grep Xvfb


Dataview Export API

Export data aggregated at the period specified about all sub-elements below a specified group

http://[[server]]/PVR/PROVISO/[[Data View]]/Query.csv?queryType=DVColBasedTS&subElmtGrpID=203387577&metricIDs=60500571
&statistics=avg&startTime=2011.02.22.00.00.00&endTime=2011.02.22.23.59.59&subPeriod=900&resLabelID=100072130
&tz=GMT%2B12&convertTime=true
http://[[server]]/PVR/PROVISO/[[Data View]]/Query.csv?queryType=DVColBasedTS&subElmtGrpID=203387579
&metricIDs=60500580,29526,29520,29524,60500571,60500580&statistics1=avg
&statistics2=avg,min,max&statistics3=avg&statistics4=max&statistics5=avg,max&statistics6=count,sum,squality
&startTime=2011.03.03.00.00.00&endTime=2011.03.03.23.59.59&subPeriod=900&resLabelID=100072130
&tz=GMT%2B12&convertTime=true

Add Error to the login page (so a proxy can check why they are there

Pages / DVLogIn.html Programming Editor

Function -Button1 Method - Page ActionPerformed


Under

: catch ( com.sssw.rt.util.[[Ago SecurityException]] pwe )
: {
: PVRcLog.debug( 1, PVRcLog.SYS''SECURITY, THIS''CLASS''NAME, "handle''Button1_pageActionPerformed",
: "User entered invalid information for name and/or password");

Add

lblWelcome.setText("Failed login. Please try Again");


NRT and Real Time Reports

THe dataview communuicates with the CMGR to get RT and NRT data

Examples of the log

Near Real Time

2014.05.06-02.20.40 UTC CMGR-6946       I       NRT_QUERY       Processing 1 queries
2014.05.06-02.20.40 UTC CMGR-6946       3       RESULT''SET''SIZE Read 1 rows
2014.05.06-02.20.40 UTC CMGR-6946       I       NRT_PERFORMANCE 39 results retrieved in 51240 us (db in 20201 us, corba in 30340 us)
2014.05.06-02.20.40 UTC CMGR-6946       I       NRT_QUERY       Processing 1 queries
2014.05.06-02.20.40 UTC CMGR-6946       3       RESULT''SET''SIZE Read 1 rows

Real Time

[[pvuser@panther:/opt/datachannel/log]] grep RT_DATA proviso.log | egrep '9.x.y.z' | grep 10089 | tail -5



2011.05.10-16.20.00 UTC CMGR-791 3 RT_DATA received data: <1305044400 '9.x.y.z:If<2>:10089' '0'>
2011.05.10-16.20.30 UTC CMGR-791 3 RT_DATA received data: <1305044430 '9.x.y.z:If<2>:10089' '0'>
2011.05.10-16.21.00 UTC CMGR-791 3 RT_DATA received data: <1305044460 '9.x.y.z:If<2>:10089' '0'>

Real Time when the dataviews subscription to Corba has expired.

2014.05.06-02.21.41 UTC CMGR-6946       3       RT_SUBSCRIBE    adding subscription: <target: 208367513, formulaIds: {2206,2207}, period: 30, duration: 1800.0>
2014.05.06-02.21.41 UTC CMGR-6946       3       RESULT''SET''SIZE Read 1 rows
2014.05.06-02.21.41 UTC CMGR-6946       1       CME''PRELOAD     Getting prestarted queryPvDbSqlStatement: <nil,select STR''NAME, STR_VALUE from  REG$DATALOAD REG WHERE S>
2014.05.06-02.21.41 UTC CMGR-6946       W       [[DC10162]]       ERR_RTDS        Subscription invalid for realtime with error: ORA-01403: no data found
2014.05.06-02.21.41 UTC CMGR-6946       W       DST_EXCEPTION   subscription invalid: ORA-01403: no data found


Adding % to report titles IV60613

1. adding four percent(%) symbol instead of two percent symbol.

2. Adding space between parenthesis. Both the workaround worked properly for customer. But customer wants the permanant fix.