Error while querying from xtk:workflow schema in preloading activity of webapp. | Community
Skip to main content
J
jayeshb_jb
Level 2
July 9, 2019

Error while querying from xtk:workflow schema in preloading activity of webapp.

  • July 9, 2019
  • 3 replies
  • 14266 views

Hi all,

I am trying to use 'xtk:workflow' schema in a Preloading activity of web app. On previewing the web app following error is shown:

Failed to preload data: WDB-200001 SQL statement 'SELECT W0.iWorkflowId, W0.sInternalName, W0.sLabel, W0.iState FROM XtkWorkflow W0 WHERE ((W0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (3466)) OR W0.iFolderId=0)) AND (((W0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (3466)) OR W0.iFolderId=0)) AND ((W0.sInternalName = ?)))' could not be executed. Param(0)=xyz(workflowinternalname) WDB-200011 The requested database record does not exist. Cannot load document of type 'Workflows (xtk:workflow)' satisfying condition '([/@internalName] = 'xyz(workflowinternalname)')'. SOP-330011 Error while executing the method 'ExecuteQuery' of service 'xtk:queryDef'.

I tried recreating the same thing using admin rights, but same error shows up.

Kindly help me to solve this error.

Kind Regards,

Jayesh

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

    3 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor
    Community Advisor
    July 11, 2019

    Hi,

    Operator 3466 is neolane, which has admin right. What is 'xyz(workflowinternalname)'?

    Thanks,

    -Jon

      J
      jayeshb_jbAuthor
      Level 2
      July 12, 2019

      Hi,

      xyz(workflowinternalname) was workflow internal name which is being passed as parameter in this webapp. I have replaced it with the actual workflow internal name for confidentiality.

      Regards,

      Jayesh

      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity Advisor
      Community Advisor
      July 12, 2019

      Hi,

      I had that wrong, figured at such a low number the operator id would've been same across installs. So what you're looking at is likely the webapp operator, verified by filtering xtk:operator on id=3466. Simplest answer here would be to just grant that operator read access to the workflow folder(s) you're exposing in the web app.

      Thanks,

      -Jon

        Anita_punmiya
        Anita_punmiya
        Level 5
        July 15, 2019

        Hi Jayesh,

        Can you please check, if "Load Additional Data" is checked in the pre-loading activity?

        If yes then try to test the web app URL using the email delivery and see if it works.

        Regards,

        Anita

          J
          jayeshb_jbAuthor
          Level 2
          July 15, 2019

          Hi Anita,

          The "Load Additional Data" is checked in the pre-loading activity. Also I got the solution to it. What I did was, I changed the access control of webapp from 'Anonymous Access' to 'Enable access control' and it worked.

          Regards,

          Jayesh

          S
          sreev97350841
          Level 2
          August 21, 2019

          Hi Jayesh,

          I'm having the same problem. The webapp user is not finding recipient records that are in a custom folder. Where did you change the access control?

          Thanks

          Sree

          pablo_rosero1
          pablo_rosero1
          Level 9
          July 17, 2019

          anitap82640902 wodnicki Thank you for giving Jayesh a hand!

            Terms & ConditionsAccessibility statement

            Loading footer...