Jump to content

Asset picker - getting 'Error in stored query'


Adrian Simpkins
 Share

Recommended Posts

Hi,

I have got the customer picker working fine using a dynamic drop down select box, with a data query against All Users but when trying the asset data query I keep getting 'Error in stored query - please check log fo rmore details'. I have an an asset picker node working but this is not such a smooth operation as having a picker field like the User list. Anyone know why I am getting this error at all please !

Also, where do I check the log for more details?

Many thanks as always

Link to comment
Share on other sites

Hi Armando

Yes I was trying to get asset picker working in a Progressive Capture - I have the below working on some of our PC's but I wanted to try and get the picker option working as its much easier for our Customers :)

These shots show how I have got asset picker working:

315854875_PCflow010719.PNG.f811dff6ba45584a96688e5ce9f7ebb3.PNG960944886_PCassetpickerworking010719.PNG.574b0e266fdc244b3f41c218b1d7fb79.PNG

The screen shot below shows how I was trying to configure the asset picker - this method is giving the error above when I use the PC as a Customer to test the flow:

1853443376_PCassetpickernotworking010719.PNG.86af61ff89536b908366e3838a36c174.PNG

Many thanks !

Link to comment
Share on other sites

Hi @Adrian Simpkins

it seems like the issue is caused by the query returning more results  than the max number allowed. 
The max number of results allowed is defined in the following app setting api.xmlmc.queryExec.maxResultsAllowed .

Can you raise the app setting to a value higher than the total number  of assets and  try again, please?   Then confirm that this fixes the issue ?
In the meantime, I will report this problem; the number of results returned by the query should be capped to the value specified in the app setting.

Regard

Armando

Link to comment
Share on other sites

HI Armando

OK so we currently have 27389 assets - maximum I can increase the value to is 25000. I have updated the maxResultsAllowed to 25000 and still getting the 'Error in Stored Query' error message so the issue is still there

Thanks !

Link to comment
Share on other sites

Hi Armando

Just to confirm I have updated Service Manager with the fix for this, and it is now working as expected and I am able to search for an Asset - thank you for the quick fix.

However, I did try to go back into api.xmlmc.queryExec.maxResultsAllowed to change the max results from 25000 to something above our maximum number of assets, but it will still only let me set a limit of 25000 so I was not sure if this should have been amended as part of this fix?

Many thanks

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...