• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 95 subscribers
  • Views 4363 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

The system (Database (****)) does not have a data store! error in Target System Browser

Tim Staddon
over 7 years ago

Hi,

I am getting this error when resolving two key resolutions by reference (KRBR for short) on a target table which is used for account-in-group mapping:

Property (vrtKRBR_UserStatus@table) could not read the value from system object (id)!
The system (Database (Oracle: database)) does not have a data store!

But the object matching rules test OK, a simulation of the sync works OK, and the object browser correctly displays the result after throwing this error.

So, the userID one is configured like this.

Name: vrtKRBR_USERID_AsString

Display name: USERID_AsString

Description: Get USERID_AsString (conversion from autonumber to string) from USER table

Base property: USERID (pick from list)

Search property: vrtConv_USERID_AsString (picked from list)

The group one is set up the same way but uses group ID from the GROUP table.

On the Identity Manager side the UNSAccountB and UNSGroupB objects have KRBR pointing to their respective ObjectGUIDs, and the mappings for both tables populate the ObjectGUID by converting the autonumber.

In Object Browser, after I dismiss the errors, the two vrtKRBR attributes are shown correctly and a property join has USERID|GROUPID for all rows, exactly as I'd expect.

So what does the error mean?

Thanks in advance

Parents
  • 0 over 7 years ago
    I am having some problems to understand what you are doing exactly. When I am looking at your definition of UserID it seems that are trying to reference the UserID as base property (unconverted) and search for a string converted value.

    But how the tables are related is not clear to me.

    If you are using KRBR your property needs to detected as reference property. You could check the schema on the target system connection if that is the case. If not, you can try to add a manual reference during the connector definition.
Reply
  • 0 over 7 years ago
    I am having some problems to understand what you are doing exactly. When I am looking at your definition of UserID it seems that are trying to reference the UserID as base property (unconverted) and search for a string converted value.

    But how the tables are related is not clear to me.

    If you are using KRBR your property needs to detected as reference property. You could check the schema on the target system connection if that is the case. If not, you can try to add a manual reference during the connector definition.
Children
No Data