Follow

How to resolve ODX error: Property 'OwnerId' does not exist for 'object specified'

Symptoms

You receive the following error when you execute an ODX Transfer task:

System.Data.SqlClient.SqlException (0x80131904): Property cannot be updated or deleted. 

Property 'OwnerId' does not exist for 'object specified'

Cause

You are using a pre-existing SQL database as ODX storage.

When you add "SQL Server Data Storage", ODX expects to create and configure its own database.  Since you are using an already existing database, it is missing an extended property OnwerId.  The ODX validation is failing because it expects the extended property OnwerId at the database level.

Resolution

Create a new SQL Server Data Storage from within ODX:

mceclip0.png

OR,

If you need to use a pre-existing SQL database for ODX storage:

In SQL Server Management Studio (SSMS), right-click on the database for ODX storage

-> Properties -> Extended Properties

Manually add an extended property as shown below: 

mceclip0.png

Name: OwnerId
Value: 00000000000000000000000000000000

This will enable ODX to take ownership of the database.

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.