Is this happening to all users? Just specific users? There is a checkbox on the My Requests page for "Show all requests". Is that checkbox visible/available to you? If so, what happens when you select it and search again? There are various reasons this behavior could occur. In most cases, it is likely related to the user/computer sync processes. This view is intended to show you requests associated with your user ID or with devices that are associated to you. If the user/computer relationships are lost, then it wouldn't know which devices belong to you and wouldn't display requests associated with any devices other than the one you're currently logged in from. If App Portal can't detect what device you're logged in from (e.g. no browser plugin, reverse DNS lookup incorrect, etc.), then it won't even be able to show you requests associated with the current device. Similarly, if your user ID is no longer in the WD_User table or your device is no longer in the WD_Computer table, you wouldn't be able to see requests associated with those objects. Finally, if someone has truncated/deleted records from WD_PackageRequests, you wouldn't see any data in the My Requests view.
I know this doesn't present a "smoking gun", but it at least gives you some things to look at. If nobody has been playing around in the database, then my money is on the data sync process being messed up.
BTW, if you haven't already, I'd suggest opening a support case with Flexera Support and uploading all of your App Portal server logs. They should be able to assist you with this.
Is this happening to all users? Just specific users? There is a checkbox on the My Requests page for "Show all requests". Is that checkbox visible/available to you? If so, what happens when you select it and search again? There are various reasons this behavior could occur. In most cases, it is likely related to the user/computer sync processes. This view is intended to show you requests associated with your user ID or with devices that are associated to you. If the user/computer relationships are lost, then it wouldn't know which devices belong to you and wouldn't display requests associated with any devices other than the one you're currently logged in from. If App Portal can't detect what device you're logged in from (e.g. no browser plugin, reverse DNS lookup incorrect, etc.), then it won't even be able to show you requests associated with the current device. Similarly, if your user ID is no longer in the WD_User table or your device is no longer in the WD_Computer table, you wouldn't be able to see requests associated with those objects. Finally, if someone has truncated/deleted records from WD_PackageRequests, you wouldn't see any data in the My Requests view.
I know this doesn't present a "smoking gun", but it at least gives you some things to look at. If nobody has been playing around in the database, then my money is on the data sync process being messed up.
BTW, if you haven't already, I'd suggest opening a support case with Flexera Support and uploading all of your App Portal server logs. They should be able to assist you with this.
It is happening to all users. We resolved it ourselves. There was a value missing in the RequestCatalogs table in the database
@Cbrhodes​ thank you for sharing your workaround with the rest of the community