Hardware Asset Table won't be synced
yesterday we found out about a problem with one of our cached SQL Database tables. In short, our Hardware Asset table did not update since May, 8th 2021.
In detail: In our "Dynamic Data" Section of our Cireson Portal, we added the "MT_Cireson$AssetManagement$" entry, so all of our Hardware Assets will be synced from this SCSM table to our ServiceManagement Database into the csnCached_HardwareAsset table. Until May, 8th 2021 everything worked fine and there haven't been any sync issues. But yesterday we found out that there were no entries for Hardware Assets, which were created after May 9th, 2021 at 00:00.
So after some investigation I stopped the Platform Cache and Cachebuilder Service and then did a Truncate on this table. Afterwards I started the Platform Cache and the Cache Builder again. Even after we waited more than 12 hours, no entries have been made. So today morning I navigated to the "Dynamic Data --> Troubleshooting" section and did the following:
- Rebuild Dynamic Data Models
- Purge Platform Cache Data
- Reset Platform Cache
- Schedule Platform Cache Sync
All other cached tables have been flushed and refilled with these steps. Only the Hardware Asset one is still empty (We waited 5 hours so far). I also checked the Platform Cache and Cache Builder Log files and there are no error messages - At least in the Cache Builder; in the Platfrom Cache log we have the same error message all the time:
("Main Exception 2021-05-21T11:11:04.8703571+02:00: HResult: -2146232060, Source: .Net SqlClient Data Provider, Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding., InnerException: System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out, StackTrace at PlatformCache.Data.Services.Implementations.Database.<ReadFromParameterizedSql>d__5`1.MoveNext() in D:\a\1\s\Cireson.WebConsole\PlatformCache.Data\Services\Implementations\Database.cs:line 66
But this message also appeared before we had these syncing issues in our HardwareAsset table.
So my question is: Is there any way to delete this table and force the CacheBuilder to rebuild it? Or is there any way to force a rebuild and delete the "old" table automatically?