The network list isn't displayed in the UI ACS 4.22

[sptest232]

There are approximately 200 networks in total. After upgrading ACS from 4.19 to 4.22, attempting to display all networks on a single page in the UI returns the error:
Cannot invoke "com.cloud.offerings.NetworkOfferingVO.getNetworkMode()" because the return value of "com.cloud.offerings.dao.NetworkOfferingDaoImpl.findById(java.io.Serializable)" is null.
If you configure the display to 50 networks per page, the networks are displayed, but when navigating to the fourth page, the error mentioned above appears.

[DaanHoogland]

@sptest232 , i cannot be sure but it sounds like one of the records is corrupt. Either the UUID is missing/invalid or the offering it refers is not there (or something else). have a look at those first. Also try to do the listing in CMK with for instance filter=name,uuid.

good bug hunting

[weizhouapache]

@sptest232 , i cannot be sure but it sounds like one of the records is corrupt. Either the UUID is missing/invalid or the offering it refers is not there (or something else). have a look at those first. Also try to do the listing in CMK with for instance filter=name,uuid.

good bug hunting

yes, it looks the network offering of a network has been (marked as) removed

[sptest232]

Yes, that's right.
using sql request
select network_offering_id, networks.name, networks.state, network_offerings.name, network_offerings.removed, network_offerings.uuid from networks inner join network_offerings on networks.network_offering_id = network_offerings.id where network_offerings.removed IS NOT NULL and networks.state <> "Destroy";

found a record
+---------------------+---------------+---------+------------------------------------------+---------------------+------------------------------------------+
| network_offering_id | name | state | name | removed | uuid |
+---------------------+---------------+---------+------------------------------------------+---------------------+------------------------------------------+
| 19 | Kuber_cluster | Shutdown | DefaultNetworkOfferingforKubernetesService | 2023-12-14 08:02:01 | 1bfaa28e-0c27-42e7-ac97-97443501c507 |
+---------------------+---------------+-----------+--------------------------------------------+---------------------+--------------------------------------+

The following

UPDATE network_offerings set removed=NULL WHERE uuid="1bfaa28e-0c27-42e7-ac97-97443501c507" helped.

Thank you very much for your help!