By David Crowther
Question:
When I run a Search in MapThat, the search doesn’t run and I get an Error Processing Request message, what is causing this?
Answer:
There can be several reasons that a MapThat Search doesn’t run correctly, and indeed if you get the Error Processing Request message when using MapThat here is an FAQ that could help you resolve other issues –
https://www.cadlinecommunity.co.uk/hc/en-us/articles/360002712757-MapThat-Error-Processing-Request-
However, in this example the error is linked to a Search layer and it’s likely there is an issue with SQL running/executing the SQL Query. Whenever this happens you can check the error messages within the MapThat VE_ERRORLOG table in your SQL Database.
Having received the Error Processing Request message (which is a generic error message) if we view the VE_ERRORLOG table, the following SQL exemption has occurred –
The EXECUTE permission was denied on the object 'fn_CreateAlphanumericSortValue', database 'LandReferencing_GH', schema 'dbo'.
This more detailed error will enable you to understand the cause of the issue e.g. has the SQL Query ran by the MapThat Search Layer returned a SQL Syntax error? Or as in this case, the SQL Search is fine, but SQL is having issues accessing a FUNCTION called – ‘fn_CreateAlphanumericSortValue'.
This function enables the Search Results in MapThat to be ordered correctly, and the error message makes it clear that permission was denied at database level to access and run that Function.
If you access your SQL Server Database, we can edit the Properties of this Function and add a USER/ROLE to have access to Alter, Control, Execute (choose as required) the Function.
Now that this Function can be accessed (and executed by MapThat), the Search will run as desired.