TNPM/dataview
Contents
- 1 Diagnostic Reports =
- 2 Nice CSV Exports
- 3 Installing Silverstream Designer
- 4 Dataview API Help Page
- 5 Running Silverstream tools from a windows PC
- 6 No charts in reports
- 7 Dataview Export API
- 8 Add Error to the login page (so a proxy can check why they are there
- 9 NRT and Real Time Reports
- 10 Adding % to report titles IV60613
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.