The following queries would do the same function than deleting the files logically from Filezilla, they will delete the record from the logical table and fill in the SRPF_GC_DETECTED_TIME in the physical table which is taken for reference for the deletion.
This is just a sample that may require more effort, involve your DBA for further assistance creating the desired query,
UPDATE TD.SMART_REPOSITORY_PHYSICAL_FILE SET SRPF_GC_DETECTED_TIME=GETDATE()
WHERE SRPF_ID in (select SRLF_PHYSICAL_ID FROM td.SMART_REPOSITORY_LOGICAL_FILE WHERE SRLF_NAME=’default.usp’)
DELETE FROM [default_123_db].[td].[SMART_REPOSITORY_LOGICAL_FILE] WHERE SRLF_NAME=’default.usp’
Additionally, in this way you can specify the name of the attachment being useful to delete specific files as ‘VuserLog.zip’.
After the queries are applied run the Promote Repository cleanup.
- Run a Controller scenario with one virtual user.
- Go to the target LoadGenerator machine. If it’s a remote LoadGenerator, use a remote desktop session.
- Open Windows Performance Monitor. (Open the Windows search bar and look for perfmon.exe or open the Control Panel and go to “System and Security -> Administrative Tools – Performance Monitor”).
- Click on Performance Monitor in order to add a new counter as shown in the below image.
- Add a counter for Processor Time and Working Set by process (the Web Browser that is being used by the virtual user)
Working Set is the current size, in bytes, of the Working Set of this process. The Working Set is the set of memory pages touched recently by the threads in the process.
CPU time (or process time) is the amount of time for which a central processing unit (CPU) was used for processing instructions of a computer program or operating system. In other words, CPU utilization.
Now you are monitoring the CPU usage with one Vuser. With this information you can estimate how many Vusers you can run in this LoadGenerator.
- Let’s say we want to keep our CPU usage under 70%. We need to monitor the average CPU usage during the test with one Vuser.
- In this example, we see an average of 12 percent average usage. If we divide 70 / 12 that gives us 5.8. That means that we can run approximately 5 or 6 Vusers in this LG.
After completing the steps above, you will have an estimate of Vusers you will be able to run in your machine, and can estimate how many LoadGenerators you need for your test.
APM 9.40 installed in Linux
When generating the EUM report “BPM Performance over time” or “Metrics overtime” the timestamp of the header of all columns doesn’t dshowa proper timestamp,
but a string like “@_@15”
This does not happen on a APM 9.40 on Windows installation.
In APM’s eum.log the following error is logged when the report is generated:
(EumBaseTablePresentationBuilder.java:127) ERROR – Failed to generate table presentation model for PerformanceMatrixTable
java.util.MissingResourceException: Can’t find resource for bundle java.util.PropertyResourceBundle, key format.HOUR_minute
Some tests done:
on a working system I generated a report at 01/15, showing data points at 15:02, 16:00, 17:00, after saving the report via the browser in one of the files
(in my case it’s “HPE Application Performance Management (running on sov02bac13.eu.hpecorp.net)_files”\PIDefaultEntryPoint_data\newReport_data\DrawSkeletonAction_data\ajaxNavigate.htm
using F12 -> tab Inspector in Mozilla, or F12 in IE does the same trick)
I can see for a table cell with time “15:02”
<td realcellindex=”3″ title=”15:02″ .. name=”@_@1516024920″ ..
for the field with time “16:00” I can see
<td realcellindex=”4″ title=”16:00″ .. name=”@_@1516028400″
so in my case we do have the correctly displayed time, “15:02”, I guess via the element “title” but also this strange string “@_@1516024920”, which turns out to be the EPOCH date/time.
1516024920 = 15/01/2018 15:02:00
on a failing system, the HTML code when disaplying the report shows the bad values as column title:
title=”@_@151623633″ .. name=”@_@151652633″ ..
which (I think) explains what we see, a column title “@_@15”,
while in my system’s case I have
title=”15:02″ .. name=”@_@1516024920″ ..
and thus I see “15:02” as column title.
On Windows environments the code doesn’t refer to the property “format.HOUR_minute” but on Linux it does due to some conditions.
Also the property “format.HOUR_minute” is missing in some of the localizaion files.
There was a localization parameter missing.
The code has been fixed to take the correct parameter.
A hotfix is available via QCCR1I130187