cancel
Showing results for 
Search instead for 
Did you mean: 
lonesurvivor
Nintex Newbie

What do I have to configure to get "Search query"-Action working?

Jump to solution

Hello everyone and a happy new year,

I'd like to experiment with the "Search query"-Workflow Action in Nintex Workflows 2016 but when I open the dialog, I get this error message:

I already looked up in the Nintex Configuration pages in the Central Administration and for manuals in the Nintex database but I didn't find a hint. Also the help for this dialog in general is more than poor... :-(

Frank Field Do you have any tech paper for me?

Can anybody help and give a hand what I have to setup to remove the errormessage and get the current managed property list?

Greetings from Nuremberg

Ricky

Reply
3 Replies
lonesurvivor
Nintex Newbie

Re: What do I have to configure to get "Search query"-Action working?

Jump to solution

Thanks to our database admin we found out that it is necessary to give owner-permissions on the search-database to the service account for the webapplication. The error has been fetched in the trace-log so we got a clue where to look:

SqlError: 'Cannot open database "SP_DEV_F1_Service_Search" requested by the login. The login failed.'

After setting this permission, the dialog works like desired:

Reply
akrasheninnikov
Nintex Newbie

Re: What do I have to configure to get "Search query"-Action working?

Jump to solution

db_owner must be overkill. There's a role defined in the database just for that: SPSearchDBAdmin. Quite likely a finer set of permissions like db_datareader would also work.

Reply
lonesurvivor
Nintex Newbie

Re: What do I have to configure to get "Search query"-Action working?

Jump to solution

db_datareader didn't work but changing the permission from db_owner to SPSearchDBAdmin like you said did the trick. Thanks a lot!

Reply