Highlighted

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

Avatar

Avatar

jayeshb_jb

Avatar

jayeshb_jb

jayeshb_jb

09-07-2019

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

Replies

Highlighted

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

11-07-2019

Hi,

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

Thanks,

-Jon

Highlighted

Avatar

Avatar

jayeshb_jb

Avatar

jayeshb_jb

jayeshb_jb

11-07-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

Highlighted

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

12-07-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

Highlighted

Avatar

Avatar

Anita_p

MVP

Avatar

Anita_p

MVP

Anita_p
MVP

14-07-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

Highlighted

Avatar

Avatar

jayeshb_jb

Avatar

jayeshb_jb

jayeshb_jb

15-07-2019

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

Highlighted

Avatar

Avatar

jayeshb_jb

Avatar

jayeshb_jb

jayeshb_jb

15-07-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

Highlighted

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

17-07-2019

anitap82640902 wodnicki Thank you for giving Jayesh a hand!

Highlighted

Avatar

Avatar

sreev97350841

Avatar

sreev97350841

sreev97350841

21-08-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

Highlighted

Avatar

Avatar

sreev97350841

Avatar

sreev97350841

sreev97350841

21-08-2019

Found it in the properties section of the web application.

Thanks

Sree