• State Verified Answer
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 25 subscribers
  • Views 2094 views
  • Users 0 members are here

Virtual Item to Virtual Item Relationship Import through staging table

Chirag Shah
Offline

Hi,

I am trying to import Virtual Item to Virtual Item Relation ship through Staging table (table name - stage_relationships) but getting below status message in "stage_load_status_arc" table

Error - Based on provided specifics, the Left Object was not found. Code = 86 Middle: Rev:

below is a loading data format of staging table -  stage_relationships

rel_scope rel_template_name rel_template_namespace left_object_type left_stage_object_id left_object_namespace left_object_code left_object_middle left_object_rev left_controlling_obj_namespace left_controlling_obj_code left_controlling_obj_middle left_controlling_obj_rev left_controlling_object_id left_object_id right_object_type right_stage_object_id right_object_namespace right_object_code right_object_middle right_object_rev right_controlling_obj_namespace right_controlling_obj_code right_controlling_obj_middle right_controlling_obj_rev right_controlling_object_id right_object_id delete_rel rel_id rel_scope_id rel_template_id context_id row_id replace_rel ext_status_code ext_status_msg
UBN MCP-VIRTUALITEM-VIRTUALITEM-TMP-01 UBN 123 NULL UBN 86 NULL NULL NULL NULL NULL NULL NULL NULL 123 NULL UBN 86-20 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 3341621 NULL NULL NULL

 

Note that left (86) and right (86-20) objects specified in above data are already present in EB as Virtual Item and they don't have "Middle" and "Revision" Fields in VITEMS table.

 

How to resolve this issue and load relationship between virtual Item and Virtual Item through staging table ?

 

Kindly reply ASAP as this needs to be resolved on priority basis.

 

Thanks & Regards

Chirag Shah

 

Communities
Support and Services
Training and Learning
Social Media