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.

  • 7004573
  • 30-Sep-2009
  • 27-Apr-2012

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

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.