Creating a view in One Identity

I've created a view in One Identity but when I try to view a single object of the view in Object Browser, it returns an error:

[810351] The table TableName has no primary keys. That's why it can only handle collections of objects. Single objects cannot be created for this table.

I can't make one of the columns as primary as it is greyed out.

Can I fix the error or do I need to delete the view and start over?

Top Replies

henrik a johansson over 5 years ago in reply to Trevor Pike +1 suggested

Yes, I created the view with Schema Extension and the view contains a SQL-code like this: FIRST_VALUE(UID_Person) OVER(PARTITION BY ColumnName)

But I've fixed the problem, I've forgotten to have a PK on…

Parents

0 Trevor Pike over 5 years ago

What is the SQL Criteria used for the view? I assume you used the Schema Extension wizard to create it?

Thanks
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 henrik a johansson over 5 years ago in reply to Trevor Pike

Yes, I created the view with Schema Extension and the view contains a SQL-code like this: FIRST_VALUE(UID_Person) OVER(PARTITION BY ColumnName)

But I've fixed the problem, I've forgotten to have a PK on the view. When I extended the view with UID_Person and made that IsPKMember and IsUID then it worked.
Cancel
Up +1 Down

Reply

Verify Answer

Reject Answer

Cancel

Reply

0 henrik a johansson over 5 years ago in reply to Trevor Pike

Yes, I created the view with Schema Extension and the view contains a SQL-code like this: FIRST_VALUE(UID_Person) OVER(PARTITION BY ColumnName)

But I've fixed the problem, I've forgotten to have a PK on the view. When I extended the view with UID_Person and made that IsPKMember and IsUID then it worked.
Cancel
Up +1 Down

Reply

Verify Answer

Reject Answer

Cancel

Children

No Data