Scenario: I have created a new slider and added a couple of controls and a panel-card-grid. Following the Application Studio guide and Hannah’s guide, I got it all wired up, and it seems pretty straightforward. [image] How To: Kinetic - Updateable UBAQ in a Grid Experts' Corner …

Found it…Got access to server logs :slight_smile: Stupid typo on one of my columns QuoteHed.QuoteNum instead of QuoteHed_QuoteNum Feeling like Homer Simpson [Scared Homer Simpson GIF by reactionseditor]

Are all your columns in the grid?

Yes, I just double-checked, all are present and all spelled correctly (then I use ‘Columns-Hidden’ to hide the ones I don’t want to show in the grid). I’m hoping support can get me more info from the server logs about the error with the correlation id, that’s my only option if I’m cloud-Saas, corr…

[image] datadaddy: that’s my only option if I’m cloud-Saas, correct ? Open up server file download, choose the admin folder, and see if the server logs (appserverlogs) are listed. If they are, open the latest one (most likely), and download that. Should be able to find it in there. If the…

Also: [image] Server Event Log Dashboard Experts' Corner On by Default with AKS.

I had a similar error just today… BAQ ran fine, but my BAQ grid in my dashboard wouldn’t populate and I saw the same “Bad SQL statement”. Luckily for me, it had been working and then I added some columns and started getting this error. The reason, I found, was I had a calculated field which, again…

@dcamlin Thanks for the idea, but unfortunately I have no calculated fields. I did have it working at one point but needed to add some fields to the ubaq…I also added them to the grid…it makes we wonder if it’s out of synch or something, like changes aren’t being recognized or properly persisted. (…

But its working now! [Homer Simpson Skipping GIFs | Tenor] Homer Gif for every situation.

Kinetic UI, UBAQ based Grid on new slideout, baffled by SQL error

Kinetic ERP

klincecum (Kevin Lincecum) July 2, 2024, 7:22pm 5

Also:

Topic		Replies	Views
Updatable BAQ application studio Kinetic ERP	16	358	February 5, 2026
UBAQ not saving in app studio Kinetic ERP kinetic , ubaq , application-studio	7	135	January 12, 2026
Invalid SQL on Kinetic version of dashboard Kinetic ERP baq , kinetic , dashboard	1	450	September 22, 2023
Updatable Dashboard w/uBAQ linked to Grid dropping data when columns not present in grid - 2024.2.10 (Kinetic) Kinetic ERP	2	306	February 21, 2025
Kinetic BAQ widget issues with Subquery Criteria Kinetic ERP baq , kinetic , application-studio	5	222	October 21, 2025

Kinetic UI, UBAQ based Grid on new slideout, baffled by SQL error

Related topics