Analysis of Robot reports from OSM Jenkins

Date and time of the report: 2022-11-14 08:20:48.135148

Analysed period: 2022-10-24 to 2022-11-14.

1. Retrieval of all currrent data for aggregate analytics

Database update:

Retrieving from database...	

DONE

2. Aggregated analysis of stability

2.1 Restricts data to time window for analysis

2.2 Finding sequences of successful builds and Robot reports

Two values retrieved from the build are key to determine the state of the jubs and test suites at a given moment:

• build_result is the outcome of the build, reported by Jenkins. It can be: SUCCESS, FAILURE, UNSTABLE or ABORTED.
• test_result is the summary of the concerned Robot tests. It can be: FAIL, UNAVAILABLE or PASS.

Based on these two states, 3 types of temporal sequences of success/failure are identified per builds and test suites:

1. Successful builds/failed builds in a row: grp_build_result.
2. Successful test reports vs. test reports with fails in a row: grp_test_result.
3. Clean builds and tests vs. failures (of any kind) in a row: grp_success_fail.

For the identification of these sequences, the following mapping applies:

Type of sequence	Relevant state	OK sequence contains	NOK sequence contains	Ignore
grp_build_result	build_result	SUCCESS or UNSTABLE	FAILURE	ABORTED
grp_test_result	test_result	PASS	FAIL	UNAVAILABLE
grp_success_fail	test_result	PASS	FAIL or UNAVAILABLE	N/A

The different groupings of segments are detected and a label is added to each sample...

DONE

Then, the duration of each of the sequences of success/failure is determined and a specific dataframe is built summarizing such sequences, to ease their representation and analysis...

DONE

2.3 Finding sequences of pass/fails per test suite

DONE

3. Reports

3.1 Aggregated success rate per test step

Empty dataframe. Skipping.

3.2 Overall success of Jenkins builds and Robot tests

3.3 Sequences of pass/fails per test suites

Empty dataframe. Skipping.

3.4 Failing days per test suite

Empty dataframe. Skipping.

job	Master branch				Release TEN				Release TWELVE
	days_failing	days_passing	days_run	error_rate	days_failing	days_passing	days_run	error_rate	days_failing	days_passing	days_run	error_rate
suites
Basic 01-Crud Operations On Vim Targets	0.500000	21.041748	21.541748	0.023211	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Basic 05-Instantiation Parameters In Cloud Init	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Basic 06-Vnf With Charm	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.588461	19.996296	20.584757	0.028587
Basic 07-Secure Key Management	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.588461	19.996296	20.584757	0.028587
Basic 08-Disable Port Security Network Level	1.148252	20.393495	21.541748	0.053304	9.000069	12.456944	21.457014	0.419447	0.588461	19.996296	20.584757	0.028587
Basic 09-Manual Vdu Scaling	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.588461	19.996296	20.584757	0.028587
Basic 11-Native Charms	0.634410	20.907338	21.541748	0.029450	8.000035	13.456979	21.457014	0.372840	0.588461	19.996296	20.584757	0.028587
Basic 12-Ns Primitives	0.648252	20.893495	21.541748	0.030093	8.000035	13.456979	21.457014	0.372840	0.588461	19.996296	20.584757	0.028587
Basic 13-Ns Relations	0.000000	21.541748	21.541748	0.000000	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Basic 14-Vnf Relations	2.000035	19.541713	21.541748	0.092845	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Basic 15-Rbac Configurations	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Basic 16-Advanced Onboarding And Scaling	0.000000	21.541748	21.541748	0.000000	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Basic 17-Delete Vnf Package	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Basic 18-Ns Ip Profile	0.013843	21.527905	21.541748	0.000643	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Basic 19-Vnf Ip Profile	0.013843	21.527905	21.541748	0.000643	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Basic 20-Manual Native Charm Vdu Scaling	0.621042	20.920706	21.541748	0.028830	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Basic 21-Persistent Volumes	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Basic 21-Support Of Volumes	2.000035	19.541713	21.541748	0.092845	0.000000	0.000000	0.000000	0.000000	0.999965	19.584792	20.584757	0.048578
Basic 22-Cross Model Relations	8.000046	13.541701	21.541748	0.371374	0.000000	0.000000	0.000000	0.000000	3.131609	17.453148	20.584757	0.152132
Basic 23-Sol004 Sol007 Packages	0.000000	21.541748	21.541748	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.584757	20.584757	0.000000
Basic 24-Affinity Groups	0.634410	20.907338	21.541748	0.029450	0.000000	21.457014	21.457014	0.000000	0.914028	19.670729	20.584757	0.044403
Basic 25-Update Charm In Running Vnf Instance	0.000000	21.541748	21.541748	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.584757	20.584757	0.000000
Epa 01-Epa Sriov	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Epa 02-Additional Capabilities	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Epa 03-Crud Operations On Sdnc	0.500000	21.041748	21.541748	0.023211	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Epa 04-Epa Underlay Sriov	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	9.709097	10.875660	20.584757	0.471664
Epa 05-Epa Underlay Passthrough	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
Fail 01-Insufficient Resources	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Hackfest Basic	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Hackfest Cloudinit	0.000000	21.541748	21.541748	0.000000	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Hackfest Multivdu	6.351748	15.190000	21.541748	0.294858	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Heal 01-Volume Vdu Healing	2.500035	19.041713	21.541748	0.116055	0.000000	0.000000	0.000000	0.000000	1.265787	19.318970	20.584757	0.061491
Heal 02-Scale Vdu Healing	7.013426	14.528322	21.541748	0.325574	0.000000	0.000000	0.000000	0.000000	9.079954	11.504803	20.584757	0.441101
Heal 03-Multiple Healing	11.730718	9.811030	21.541748	0.544557	0.000000	0.000000	0.000000	0.000000	2.543056	18.041701	20.584757	0.123541
Heal 04-Autohealing	12.230683	9.311065	21.541748	0.567767	0.000000	0.000000	0.000000	0.000000	0.543113	20.041644	20.584757	0.026384
K8S 01-Create K8S Cluster	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
K8S 02-K8Scluster Creation	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
K8S 03-Simple K8S	1.648299	19.893449	21.541748	0.076516	0.000000	21.457014	21.457014	0.000000	2.588495	17.996262	20.584757	0.125748
K8S 04-Openldap Helm	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
K8S 05-K8S Proxy Charms	0.000000	21.541748	21.541748	0.000000	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
K8S 06-K8S Secure Key Management	0.000000	21.541748	21.541748	0.000000	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
K8S 07-Dummy Helm	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
K8S 08-Simple K8S Scaling	1.648299	19.893449	21.541748	0.076516	0.000000	21.457014	21.457014	0.000000	2.588495	17.996262	20.584757	0.125748
K8S 09-Pebble Charm K8S	1.648299	19.893449	21.541748	0.076516	0.000000	0.000000	0.000000	0.000000	2.588495	17.996262	20.584757	0.125748
K8S 10-Sol004 Sol007 With K8S Proxy Charms	6.351748	15.190000	21.541748	0.294858	0.000000	0.000000	0.000000	0.000000	0.000000	20.584757	20.584757	0.000000
K8S 11-Simple Helm K8S Scaling	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
K8S 12-Openldap Helm Day-2	1.648299	19.893449	21.541748	0.076516	0.000000	0.000000	0.000000	0.000000	2.588495	17.996262	20.584757	0.125748
Quotas 01-Quota Enforcement	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Sa 01-Vnf With Vim Metrics	0.500000	21.041748	21.541748	0.023211	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Sa 02-Vnf With Vim Metrics And Autoscaling	0.500000	21.041748	21.541748	0.023211	9.541204	11.915810	21.457014	0.444666	0.000000	20.584757	20.584757	0.000000
Sa 07-Alarms From Sa-Related Vnfs	6.851748	14.690000	21.541748	0.318068	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Sa 08-Vnf With Vnf Indicators Snmp	0.000000	21.541748	21.541748	0.000000	0.000000	21.457014	21.457014	0.000000	0.000000	20.584757	20.584757	0.000000
Slice 01-Network Slicing	6.351748	15.190000	21.541748	0.294858	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Slice 02-Shared Network Slicing	6.351748	15.190000	21.541748	0.294858	8.000035	13.456979	21.457014	0.372840	0.000000	20.584757	20.584757	0.000000
Sol003 01-Vnf-Lifecycle-Management	0.000000	21.541748	21.541748	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.584757	20.584757	0.000000
basic 23-delete vnf package SOL004 SOL007	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
k8s 10-k8s proxy charms SOL004 SOL007	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000

4. Information about the latest builds of relevant jobs

Latest build of each job

	job	build	timestamp	duration	build_result	test_result	pass_count	fail_count
0	osm-stage_3-merge/master	2369	2022-11-14 02:06:18	18209392	UNSTABLE	FAIL	508.0	13.0
1	osm-stage_3-merge/v12.0	193	2022-11-14 01:04:13	16152793	FAILURE	FAIL	507.0	11.0
2	osm-stage_3-merge/v11.0	332	2022-08-08 23:00:14	11064864	SUCCESS	PASS	421.0	0.0
3	osm-stage_3-merge/v10.0	621	2022-11-14 04:08:14	11029	FAILURE	UNAVAILABLE	NaN	NaN

Click to see the details of build 2369 of osm-stage_3-merge/master

Click to see the details of build 193 of osm-stage_3-merge/v12.0

Click to see the details of build 332 of osm-stage_3-merge/v11.0

Click to see the details of build 621 of osm-stage_3-merge/v10.0

Failed test suites per job (if any):

osm-stage_3-merge/master: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
76	Basic 01-Crud Operations On Vim Targets	FAIL	2022-11-14 02:30:46	2022-11-14 02:37:07	2	2	Create VIM Target Basic	Check for VIM Target Metric
80	Basic 08-Disable Port Security Network Level	FAIL	2022-11-14 02:48:25	2022-11-14 02:54:18	8	1	Create VIM With Port Security Disabled	Check for VIM Target Status
99	Epa 03-Crud Operations On Sdnc	FAIL	2022-11-14 03:54:24	2022-11-14 04:00:30	2	1	Check SDNC Status Is Healthy	Check for SDNC Status
105	Heal 01-Volume Vdu Healing	FAIL	2022-11-14 04:12:54	2022-11-14 04:19:40	11	2	Heal Persistent Volume VDU	Heal Network Service
108	Heal 04-Autohealing	FAIL	2022-11-14 04:49:18	2022-11-14 05:01:34	9	2	Wait For Autohealing To Be Completed	Wait Until Keyword Succeeds
120	Sa 01-Vnf With Vim Metrics	FAIL	2022-11-14 05:46:16	2022-11-14 06:01:43	6	1	Get VNF VIM-based Metrics	Wait Until Keyword Succeeds
121	Sa 02-Vnf With Vim Metrics And Autoscaling	FAIL	2022-11-14 06:01:43	2022-11-14 06:33:21	10	3	Get VNF VIM-based Metric Before Auto-scaling	Wait Until Keyword Succeeds
122	Sa 07-Alarms From Sa-Related Vnfs	FAIL	2022-11-14 06:33:21	2022-11-14 06:51:04	15	1	Get Alarm Metric	Wait Until Keyword Succeeds

osm-stage_3-merge/v12.0: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword
144	Basic 22-Cross Model Relations	FAIL	2022-11-14 02:27:56	2022-11-14 02:46:43	9	1	Instantiate Charm Network Service	Create Network Service
146	Basic 24-Affinity Groups	FAIL	2022-11-14 02:46:57	2022-11-14 02:49:11	6	1	None	None
158	Heal 03-Multiple Healing	FAIL	2022-11-14 03:34:28	2022-11-14 04:01:13	6	7	Scale Out Charm VNF	Execute Manual VNF Scale
159	Heal 04-Autohealing	FAIL	2022-11-14 04:01:13	2022-11-14 04:06:30	9	2	Wait For Autohealing To Be Completed	Check For NS Operation Completed

osm-stage_3-merge/v11.0: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

osm-stage_3-merge/v10.0: (full report)

	name	status	starttime	endtime	pass	fail	failed_test_name	failed_keyword

Details of failed tests into failing test suites (if any):

osm-stage_3-merge/master: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime
7	Basic 01-Crud Operations On Vim Targets	Create VIM Target Basic	Check for VIM Target Metric	FAIL	2022-11-14 02:30:50	2022-11-14 02:33:52
18	Basic 01-Crud Operations On Vim Targets	Create VIM Target With Extra Config	Check for VIM Target Status	FAIL	2022-11-14 02:34:00	2022-11-14 02:37:02
23	Basic 08-Disable Port Security Network Level	Create VIM With Port Security Disabled	Check for VIM Target Status	FAIL	2022-11-14 02:48:27	2022-11-14 02:51:29
37	Epa 03-Crud Operations On Sdnc	Check SDNC Status Is Healthy	Check for SDNC Status	FAIL	2022-11-14 03:54:27	2022-11-14 04:00:27
76	Heal 01-Volume Vdu Healing	Heal Persistent Volume VDU	Heal Network Service	FAIL	2022-11-14 04:18:08	2022-11-14 04:18:29
83	Heal 01-Volume Vdu Healing	Check VNF After Healing	Should Not Be Equal	FAIL	2022-11-14 04:18:32	2022-11-14 04:18:32
119	Heal 04-Autohealing	Wait For Autohealing To Be Completed	Wait Until Keyword Succeeds	FAIL	2022-11-14 04:50:43	2022-11-14 05:00:47
129	Heal 04-Autohealing	Check VNF After Healing	Should Not Be Equal	FAIL	2022-11-14 05:00:51	2022-11-14 05:00:51
143	Sa 01-Vnf With Vim Metrics	Get VNF VIM-based Metrics	Wait Until Keyword Succeeds	FAIL	2022-11-14 05:47:01	2022-11-14 06:01:01
170	Sa 02-Vnf With Vim Metrics And Autoscaling	Get VNF VIM-based Metric Before Auto-scaling	Wait Until Keyword Succeeds	FAIL	2022-11-14 06:02:33	2022-11-14 06:16:33
177	Sa 02-Vnf With Vim Metrics And Autoscaling	Wait VIM-based Metric To Exceed Threshold	Wait Until Keyword Succeeds	FAIL	2022-11-14 06:16:36	2022-11-14 06:30:36
182	Sa 02-Vnf With Vim Metrics And Autoscaling	Get VDUs After Auto-scaling	Run Keyword If	FAIL	2022-11-14 06:32:37	2022-11-14 06:32:37
208	Sa 07-Alarms From Sa-Related Vnfs	Get Alarm Metric	Wait Until Keyword Succeeds	FAIL	2022-11-14 06:35:35	2022-11-14 06:49:36

osm-stage_3-merge/v12.0: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime
221	Basic 22-Cross Model Relations	Instantiate Charm Network Service	Create Network Service	FAIL	2022-11-14 02:28:41	2022-11-14 02:43:51
249	Heal 03-Multiple Healing	Scale Out Charm VNF	Execute Manual VNF Scale	FAIL	2022-11-14 03:38:43	2022-11-14 03:39:04
276	Heal 03-Multiple Healing	Stop VDUs	Stop Server	FAIL	2022-11-14 03:39:17	2022-11-14 03:39:20
281	Heal 03-Multiple Healing	Heal VDUs	Heal Network Service	FAIL	2022-11-14 03:39:20	2022-11-14 03:49:27
287	Heal 03-Multiple Healing	Check VNFs After Healing	Should Not Be Equal	FAIL	2022-11-14 03:49:29	2022-11-14 03:49:29
295	Heal 03-Multiple Healing	Delete NS Instance	Delete NS	FAIL	2022-11-14 03:49:29	2022-11-14 03:53:37
296	Heal 03-Multiple Healing	Delete NS Descriptor	Delete NSD	FAIL	2022-11-14 03:53:37	2022-11-14 03:53:39
297	Heal 03-Multiple Healing	Delete VNF Descriptors	Delete VNFD	FAIL	2022-11-14 03:53:39	2022-11-14 03:53:41
324	Heal 04-Autohealing	Wait For Autohealing To Be Completed	Check For NS Operation Completed	FAIL	2022-11-14 04:05:40	2022-11-14 04:05:42
331	Heal 04-Autohealing	Check VNF After Healing	Should Not Be Equal	FAIL	2022-11-14 04:05:46	2022-11-14 04:05:46

osm-stage_3-merge/v11.0: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime

osm-stage_3-merge/v10.0: (full report)

	suite_name	test_name	keyword_name	status	starttime	endtime

---

---