We recently had a client that was running into an issue when attempting to create one particular entity in the Saleslogix web client. Other entities could save fine. When they went to save the record they would immediately get a popup that just said “E_FAIL(0x80004005)”.
It turns out the fix for this was quite easy- perform an IIS reset.
The web server normally requests a batch of table ID Key sequences, which are then cached for the session and used as needed. This is to avoid constantly having to retrieve IDs from the database. Apparently in this case the batch process somehow became broken for that one key base.