What should be checked if we get "An error has Occurred" while performing any Data Manipulation Activity on the website Like Adding assets, Deleting Robots ?
Most likely the issue is with the Database being used. The database does not have enough space in either the main database (.mdf) or Log database (.ldf) causing the failures while performing any Transactions on the website.
To Troubleshoot this:
- Connect to the Target database mentioned in the connection string of the web.config using SSMS.
- Execute stored procedure sp_helpdb, sp_spaceused to know the free space.
The above stored procedures will provide you is there is free space available for the website to perform any transactions. Any manual insert, Delete, Update query on the database will also fail in such scenario.