Environment
The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions.
Situation
While trying to log into SCC you recive the following error message.
"The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions."
This is generally caused by the MSSQL database being restarted, while sentinel is still running. This causes a disconnect in where the view currently was writing and the view after the database running. You will generally see something similar to the error within the DAS_Query0.0log as well as the DAS_Binary0.0log
"The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions."
This is generally caused by the MSSQL database being restarted, while sentinel is still running. This causes a disconnect in where the view currently was writing and the view after the database running. You will generally see something similar to the error within the DAS_Query0.0log as well as the DAS_Binary0.0log
Resolution
To resolve this issue you need to refresh the views between sentinel and MSSQL. to do this restart sentinel. once it has come back up login to SDM. Go to the partitions tab any table and manually add a partition generally 1 day. Once the view has finished refreshing you can log into SCC. This will refresh the view and allow SCC to see the correct views within the database.