Error in Extended schema | Community
Skip to main content
M
Adobe Employee
MrityunjayAdobe Employee
Adobe Employee
May 27, 2022
Question

Error in Extended schema

  • May 27, 2022
  • 2 replies
  • 1509 views

Hi team,

I have inserted some data in the extended recipient schema with the help of workflow. But while opening the navigation hierarchy of extended schema I am getting some errors. I am stuck on that point, can you please help me out. I am attaching the screenshot here. Please look through it.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

C
Adobe Employee
costa_n11Adobe Employee
Adobe Employee
May 27, 2022

Hi @mrityunjay 

The error indicates that when trying to access the recipient record, one of the relations link to the recipient (via the JOIN clauses) doe snot exist. It could be that link is defined as 1:1 instead of 0:1. Saying that you've got a strange JOIN clause on xtkFolder, you got it twice as if the recipient was belonging to 2 folders. JOIN on country and state are left JOIN so you should be fine. We guess is that the Recipient might not be in the folder with the ID mentioned. 

Check if you have a folder with ID: 148193 as indicated in the logs....

Hope this helps

Thanks

Denis

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    June 15, 2022

    Hi @mrityunjay,

    Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

    Thanks!

    Sukrity Wadhwa
    M
    Adobe Employee
    MrityunjayAdobe EmployeeAuthor
    Adobe Employee
    July 1, 2022

    Hi @sukrity_wadhwa   @costa_n11   I am still stuck on this point and unable to resolve the error. I think there is some problem with joins with the recipient schema

    I have made a 1:N join in ctc:recipient(extended schema) and ctc:tourHistory schema and defined this in tourHistory schema.

    Can you please check once if my way of creating a join is correct or not?

     

    please help me out as soon as possible , i will too much grateful

     

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    July 28, 2022

    Hi @costa_n11,

    Could you please help @mrityunjay further here?

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...