Adobe Campaign Classic V8 Non Admin user not able to run query on nms recipient | Community
Skip to main content
SushantTrimukheD
SushantTrimukheD
Level 4
December 7, 2021
Solved

Adobe Campaign Classic V8 Non Admin user not able to run query on nms recipient

  • December 7, 2021
  • 2 replies
  • 2401 views

Hi,

 

We are implementing a solution where different users have access to different market folders and campaigns; hence we created new users and gave them below access rights to their market folders.

Named Rights:

- Prepare Delivery

- Start Deliveries

- Workflow

- Approval Administration

and the below-mentioned Folders:

- Campaign Management

- Campaign Process (under Administration -> Production -> Technical workflows)

The same is working on V7, but on V8, it's giving the following error on workflow when querying recipient where now recipient is on cloud and using FFDA access to retrieve data.

07/12/2021 10:12:20 query XSV-350062 Unable to start data source 'nms:extAccount:ffda *Account Name'.
07/12/2021 10:12:20 query Cannot load document of type 'External Accounts (nms:extAccount)' satisfying condition '([/@name] = 'ffda')'.
07/12/2021 10:12:20 query WDB-200011 The requested database record does not exist.
07/12/2021 10:12:20 query (0)=ffda
07/12/2021 10:12:20 query Rights xr WHERE xr.iOperatorId IN (258970, 258974)) OR E0.iFolderId=0)) AND (((E0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (258970, 258974)) OR E0.iFolderId=0)) AND ((E0.sName = :#(1)#)))' could not be executed. Param
07/12/2021 10:12:20 query WDB-200001 SQL statement 'SELECT E0.sProvider, E0.sServer, E0.sAccount, E0.sDbName, E0.sPassword, E0.iUnicodeData, E0.iNChar, E0.sTimezone, E0.iIsFFDA, E0.iOnEveryRun, E0.mData FROM NmsExtAccount E0 WHERE ((E0.iFolderId IN (SELECT xr.iFolderId FROM Xtk

 

Any suggestion or name rights should be used; please let me know or any workaround.
@vraghav @garima_gakhar @farah-mohammed

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

    Hi @david--garcia 

     

    You are right, i was getting this error but when I used the above namerights and given access to the folders then it stopped giving error but after that I was facing the above errors. The error is still there and it has not solved the issue.


    Posting the soulution which worked for me as a work around as in V7 we dont face any issue but in V8 we are and to solve this below are some access which you need to give for opreator group.

     

    Read Access:

    /Administration/Production/Technical workflows/Campaign process

    /Administration/Platform/External Accounts

    /Administration/Campaign Management

     

    Read Write Access:

    /Administration/Production/Objects created automatically

     

    Thanks

    Sushant Trimukhe

    2 replies

    david--garcia
    david--garcia
    Level 10
    December 7, 2021

    Can you check on (Administration > Platform > External accounts.) if the ffda external account record exists? this external account is configured by Adobe for your instance. could it be that it has not been configured? as the SQL queries states that is missing.

     

    If not then raise it to Adobe Support as a P2

     

    There is also a patched released under version 8.1.20 September 7 2021 indicating a fix applied to ffda that is relevant to replication of operator groups and rights, what is your version of v8?

     

    Release 8.1.20

    • Fixed an issue with FFDA preventing the proper replication of operator groups and rights.

     

    References

    1. https://experienceleague.adobe.com/docs/campaign/campaign-v8/config/external-accounts.html?lang=en
    2.  https://experienceleague.adobe.com/docs/campaign/campaign-v8/start/release-notes.html?lang=en
    SushantTrimukheD
    SushantTrimukheDAuthor
    Level 4
    December 7, 2021

    Thanks @david--garcia ,

     

    We are already in 8.1.20 of V8 and the external account is present, but its only working by Admin user if any other new user is trying to query recipient its not working.

    I have read about that patch but we are already in 8.1.20 hence it should work.

     

    Any other issue that may create this issue ?

     

    Thanks

    Sushant Trimukhe

      david--garcia
      david--garcia
      Level 10
      December 7, 2021

      The next issue could be folder rights as the SQL error is doing a join on xtkrights with your two operators (xr.iOperatorId IN (258970, 258974)) )

       

       

       

      Can you check the web@default logs and look for an error code QUE-370030 perhaps there are some missing rights on some folders, something like the following

       

       

      QUE-370030 You do not have the rights needed on folder of identifier xxx (documents of type 'Workflow (workflow)') to complete the operation. (iRc=-53)

       

      So search for all instances of "QUE-370030 You do not have the rights" and go back a few days until today, then there could be multiple folders mentioned.

       
       

       

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      December 23, 2021

      Hi @sushanttrimukhed,

      Were you able to resolve this query or do you still need more help here? Do let us know.

      Thanks!

      Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...