I have a UBAQ dashboard that I had deployed with Application Studio. It was working well until this week. Now the updateable part of the BAQ doesn’t seem to work. It uses a custom action to process the updates. The data is going into my callcontext fields like it should, but nothing is working on my UBAQ side.
Setting the application aside for a moment, I just open the UBAQ, and try to manually enter a record. Normally I can do this, if I type in all the right values it expects, but not anymore. I have removed all the widgets from the BPM, and replaced them with just a messagebox to show debug info. With start linked to the messagebox only.
Does anyone know of any issues that could be causing this sudden change? I just get that cryptic error 500 with no details.
I am on cloud. I went to Server File Download, but I don’t see any files that relate to the issue. I couldn’t find any files there that had a recent date, so I think I dont have access to that.
We’re on cloud - select Admin from the dropdown, then look for the appserverlogs folder. Can take a few seconds for the folder to appear but then you should be able to search/download the appropriate file.
EDIT - or use @GabeFranco 's dash, probably a lot easier lol
I had a few UBAQs which suddenly stopped working on some update and it turned out the Query to Object column mapping & Object to Query column mappings didn’t match up. Could be something similar here?
For me, it was a date field which was being parsed as System.DateTime which needed to be System.DateTime? (but only kinetic would fuss about the field being nullable)
Oh, I forgot about that problem, you are right, that has happened to me with more than one uBAQ before. I had to click the “Resync column mapping” button or whatever it was. Same thing, DateTime vs. DateTime?
I have reported it. Per support, the solution is to reselect the service method. They don’t see any reason to report it to development and do not know the root cause.
I thought this might be the case as well, but my UBAQ uses advanced BPM processing rather than the standard update BPM. I have been suspecting that date/time thing as the issue. I hate tried various ways to make the field formats match, with no luck. Where can I add that ? to the end of the DateTime?
An Epicor employee saw this post and reached out to offer me a snippet of the log that I can’t access. This seems to be the relevant part, something about a messed up JSON in queryResultDataset. Unexpected end when reading JSON. Path ‘queryResultDataset’
{"Source":"EventLog","LogEntry":{"EventSource":"IceAppServer","Time":"2026-01-19T17:44:26.0000000Z","Channel":"Epicor App Server","Level":"Error","EventId":0,"Message":"Ice.Common.EpicorServerException: Unexpected end when reading JSON. Path 'queryResultDataset'.\r\n ---> Newtonsoft.Json.JsonSerializationException: Unexpected end when reading JSON. Path 'queryResultDataset'.\r\n
at Newtonsoft.Json.Converters.DataTableConverter.CreateRow(JsonReader reader, DataTable dt, JsonSerializer serializer)\r\n
at Newtonsoft.Json.Converters.DataSetConverter.ReadJson(JsonReader reader, Type objectType, Object existingValue, JsonSerializer serializer)\r\n
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.DeserializeConvertable(JsonConverter converter, JsonReader reader, Type objectType, Object existingValue)\r\n
yaddah yaddah...
Dev tools only shows me the error I first posted. Kinetic UX Trace doesn’t see any BOs fire off to trace. Where could I poke around to find that JSON? I still have my BPM kneecapped, from Start right to a single debug text box showing the variables pulled from callcontext fields. That dialog box never fires either. So, I dont think the UBAQ even gets to the action part.
