AdvSG Trillian test

[SF] Trillian test result (tid-16920)
Environment: kvm-ol8 (x2), zone: Advanced_with_Security_Groups Networking with Mgmt server ol8
Total time taken: 84581 seconds
Marvin logs: https://github.com/blueorangutan/acs-prs/releases/download/trillian/pr12850-t16920-kvm-ol8.zip
Smoke tests completed. 89 look OK, 60 have errors, 0 did not run
Only failed and skipped tests results shown below:

files to exclude or fix for adv zone with sg:

- [ ] test_direct_download.py
- [ ] test_accounts.py
- [ ] test_events_resource.py
- [ ] test_extension_custom.py
- [ ] test_backup_recovery_nas.py
- [ ] test_global_acls.py
- [ ] test_cluster_drs.py
- [ ] test_guest_vlan_range.py
- [ ] test_deploy_virtio_scsi_vm.py
- [ ] test_internal_lb.py
- [ ] test_ipv4_routing.py
- [ ] test_diagnostics.py
- [ ] test_ipv6_infra.py
- [ ] test_domain_network_offerings.py
- [ ] test_domain_vpc_offerings.py
- [ ] test_extension_lifecycle.py
- [ ] test_kubernetes_clusters.py
- [ ] test_list_volumes.py
- [ ] test_loadbalance.py
- [ ] test_migration.py
- [ ] test_network_acl.py
- [ ] test_network_ipv6.py
- [ ] test_network_permissions.py
- [ ] test_network.py
- [ ] test_nic.py
- [ ] test_non_contigiousvlan.py
- [ ] test_nonstrict_affinity_group.py
- [ ] test_password_server.py
- [ ] test_persistent_network.py
- [ ] test_portable_publicip.py
- [ ] test_portforwardingrules.py
- [ ] test_privategw_acl.py
- [ ] test_public_ip_range.py
- [ ] test_purge_expunged_vms.py
- [ ] test_pvlan.py
- [ ] test_quarantined_ips.py
- [ ] test_register_userdata.py
- [ ] test_router_dhcphosts.py
- [ ] test_router_dns.py
- [ ] test_router_dnsservice.py
- [ ] test_routers_iptables_default_policy.py
- [ ] test_routers_network_ops.py
- [ ] test_routers.py
- [ ] test_service_offerings.py
- [ ] test_vm_life_cycle.py
- [ ] test_set_sourcenat.py
- [ ] test_sharedfs_lifecycle.py
- [ ] test_ssl_offloading.py
- [ ] test_systemvm_userdata.py
- [ ] test_usage.py
- [ ] test_vm_autoscaling.py
- [ ] test_vm_lifecycle_unmanage_kvm_import.py
- [ ] test_vm_snapshots.py
- [ ] test_vnf_templates.py
- [ ] test_volumes.py
- [ ] test_vpc_ipv6.py
- [ ] test_vpc_redundant.py
- [ ] test_vpc_router_nics.py
- [ ] test_vpc_vpn.py
- [ ] test_host_maintenance.py

_Originally posted by @blueorangutan in https://github.com/apache/cloudstack/issues/12850#issuecomment-5586301964_

Start with the Marvin log archive and the listed Python tests, especially the failures in the Advanced_with_Security_Groups environment. Determine which tests need fixes versus exclusion, then rerun the Trillian test; done means the affected tests produce expected results or are explicitly excluded with a reason.

Written by the indexing model from the issue text.