E9.2 AIS Grid Issue After Tools 9.2.3.5 -> 9.2.5.4 Upgrade

dpasanen

dpasanen

Member
Hello, we're in the midst of a tools upgrade (9.2.3.5 to 9.2.5.4), during an iSeries -> Windows conversion (yea, a lot going on here). Been using AIS for a few years for various things and we seem to be having an issue with grid row exit event rules.

I used to be able to just send the JSON at the bottom of this post to the AIS server and it'd do everything. Insert the first row(0), perform row exit ERs, insert the second row(1), perform row exit ERs, hit controlID 4 a couple times, yahtzee!

But now it seems as though it never performs row exit ERs after inserting the first grid row, so many of my columns remain empty and the form hands me errors. This has broken since our tools upgrade from 9.2.3.5 to 9.2.5.4. Nothing has changed with the form, and this still functions on our prod instance which is still 9.2.3.5.

Anyone run into this somewhere between those tool releases and have a solution? I've tried throwing the various actions into separate calls, tried doing a SelectRow in between them just to try to get it to trigger the ERs and it just never happens.

Thanks in advance!

JSON:
{
    "token": "044NSE40cZBL0/YZM/6GqWdkhNfDnrQGoXcnGDXnym0FVs=MDE4MDA1NTQ4NzI1NDU2NDk0MjcwODk5cHlBSVMxNjI5NDYzMjAxMjMz",
    "deviceName": "AIS",
    "outputType": "VERSION2",
    "allowCache": "true",
    "returnControlIDs": "true",
    "showActionControls": "true",
    "action": "execute",
    "actionRequest": {
        "formActions": [
            {
                "command": "SetControlValue",
                "controlID": "24",
                "value": "        BP18"
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowInsertEvents": [
                        {
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "28",
                                    "value": "F"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowUpdateEvents": [
                        {
                            "rowNumber": 0,
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "32",
                                    "value": "21-133533"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowInsertEvents": [
                        {
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "28",
                                    "value": "T"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowUpdateEvents": [
                        {
                            "rowNumber": 1,
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "32",
                                    "value": "21-133533"
                                },
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "41",
                                    "value": "SL22917-065-10"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "command": "DoAction",
                "controlID": "4"
            },
            {
                "command": "DoAction",
                "controlID": "4"
            }
        ],
        "formOID": "W554116B"
    },
    "formName": "P554116_W554116B",
    "version": "CSG0003",
    "rid": "c2aa1927f53c1fa9",
    "stackId": 1,
    "stateId": 1
}
 
Best I can tell, something changed about the order event rules fire through this or something. My column exit/changed inline event rules used to fire before row exit/changed asynch, but that doesn't seem to be the case anymore. More debugging to be done on this next week...
 
Just in case anyone else runs across this hoping to find an answer, I managed to get this to fire correctly by adding a button (that literally has no event rules) and clicking it between my grid actions. See attached JSON.

This is by no means a fix, this is a crappy workaround to what I consider a bug. I have a service request open with Oracle on it, so hopefully they see it as a bug too...

form.png

JSON:
{
    "token": "044OBCRH5iC1/6bbrj14jjwlr4CdgeVpgBBYXBMKu2O58Y=MDE5MDA1MTg0NjU5MDA2MzE4MzMyMzkxMXB5QUlTMTYyOTc0MDk1MTI2Nw==",
    "deviceName": "AIS",
    "outputType": "VERSION2",
    "allowCache": "true",
    "returnControlIDs": "true",
    "showActionControls": "true",
    "action": "execute",
    "actionRequest": {
        "formActions": [
            {
                "command": "SetControlValue",
                "controlID": "24",
                "value": "        BP18"
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowInsertEvents": [
                        {
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "28",
                                    "value": "F"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "command": "DoAction",
                "controlID": "194"
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowUpdateEvents": [
                        {
                            "rowNumber": 0,
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "32",
                                    "value": "21-133049"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "command": "DoAction",
                "controlID": "194"
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowInsertEvents": [
                        {
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "28",
                                    "value": "T"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "command": "DoAction",
                "controlID": "194"
            },
            {
                "gridAction": {
                    "gridID": "1",
                    "gridRowUpdateEvents": [
                        {
                            "rowNumber": 1,
                            "gridColumnEvents": [
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "32",
                                    "value": "21-133049"
                                },
                                {
                                    "command": "SetGridCellValue",
                                    "columnID": "41",
                                    "value": "SL30905-030-16"
                                }
                            ]
                        }
                    ]
                }
            },
            {
                "command": "DoAction",
                "controlID": "194"
            },
            {
                "command": "DoAction",
                "controlID": "4"
            },
            {
                "command": "DoAction",
                "controlID": "4"
            }
        ],
        "formOID": "W554116B"
    },
    "formName": "P554116_W554116B",
    "version": "CSG0003",
    "rid": "ab7298846fa71c25",
    "stackId": 1,
    "stateId": 1
}
 
Back
Top