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

[jayeshb_jb]

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

[Jonathon_wodnicki]

Hi,

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

Thanks,

-Jon

[jayeshb_jb]

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]

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

[jayeshb_jb]

Hi Jon,

Thanks for helping. Your comment lead to the solution. What I did was, I changed the access control from 'Anonymous Access' to 'Enable access control' and it worked.

Regards,

Jayesh

[Anita_punmiya]

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

[jayeshb_jb]

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

[sreev97350841]

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

[sreev97350841]

Found it in the properties section of the web application.

Thanks

Sree

[jayeshb_jb]

I am glad that this post was helpful.

Regards,

Jayesh

[pablo_rosero1]

anitap82640902 wodnicki Thank you for giving Jayesh a hand!