How To: Kinetic - Updateable UBAQ in a Grid

I fallowed all your steps, and I get this error when I click my save button

image

Is this still not supported?

That error could be a million and one things.
Go into your server and read the event viewer to see what the actual problem is.

Ok, so here is the error from event viewer on the server:\

Okay. And did you read it?

3 Likes

Yes, I did. Forgive me, I am new to kinetic and in the process of converting my dashboards over. Is there something that I need to enable. The dashboard work in our current system but not in our kinetic environment. I am still trying to learn the ins and outs of kinetic and app studio.

It’s telling you that your BAQ doesn’t have a BPM on update or it’s disabled.
Either make one or enable it.

1 Like

I moved my BAQ from our current e10 system to Kinetic via Solution workbench. I and seeing in the update tab of the BAQ that there is in fact a BPM attached.

Does the BAQ work? Have you tested it in the BAQ designer?

1 Like

You may have to reselect the business object in the BAQ. The schema may have changed should of auto updated but… :man_shrugging:

1 Like

It works in Our e10 environment but not in Kinetic. In Kinetic it returns records, but the update does not work. In e10 even the update works.

1 Like

I’ve never imported an updatable BAQ from another version, but wow I totally believe this! Fascinating catch.

I assume the BAQ conversion (in Conversion Workbench) would fix it, too. But your way sounds much faster and easier.

Ok, after re-selecting the business object, the updating part of the BaQ now works and the update seems to work in the classic dashboard for kinetic. but in the kinetic dashboard is not passing my required fields. They are Key1, CallSeqNum, callDesc, and RelatedToFile.

It is supposed to be getting the results from the changed table.

Well… have you added those fields to the columns in App Studio? Been there…

4 Likes

I have just tested this in version 2024.2.3 and the problem still exists.
I will make an EpicCare case for this.

Minor change but for anyone looking at this in the future. It looks like in 2024.2 they changed the name of the widget from erp-baq to kinetic-baq. The properties tab still says erp-baq though.

2 Likes

If you’re sending half of much data (just the Rowmod=U half, and excluding the old Rowmod = “”), wouldn’t it speed things up at least?

Speed up, certainly. Lose functionality too.

You need the unmodified row to know what changed, or you can’t do validations or custom things.

Gotta be fixed.

2 Likes

Hi,

Has anyone had this? I have UBAQ in classic, works good i can update many rows at once. In kinetic same baq: I can update only one row at a time and only if the current row is active(selected) in grid, if i try to use Send all rows (pic below), I get error in response

We apologize, but an unexpected internal problem occurred. Please provide your System Admin or Technical Support this Correlation ID for further details. Correlation ID: bd718cee-eee9-4217-9995-29932c3a81d8

I am in cloud so can not check exact error in server side. UBAQ should be good it is marked as “Allow Multiple Row Update” , update method ICE UD02 UpdateExt.

UPDATE
Found this, so error point to:

<![CDATA[System.ArgumentException: The input string ‘4500.708’ was not in a correct format.Couldn’t store <4500.708> in Calculated_SumOnhand Column. Expected type is Decimal.

I do not understand why, if this field not marked as updatable neither in UBAQ neither in kinetic grid columns. And still in classic no errors :confused:
Hmm, could it be some Studio :poop: ?

You can, actually!
Use the “Server File Download” screen and select Admin as the Directory Type.

3 Likes

To add on to this, I prefer doing this in Classic because the last time I checked, you can’t sort by Modified Date in Kinetic but can in Classic. You’ll need to grab all of the files showing for the date in question, then search for the correlation ID that you got in the error message in each of the log files.

I use Notepad++ to open all the log files, then do a search across all open files. Makes it much easier.

1 Like