I've got a rather large installation that's been live for about three weeks now and my client's users (12 of them pretty constantly hitting the database) still randomly get errors when trying to add new records to a MySQL database (AutoInc key).
It's a master-detail relationship with a read-only grid and an editable detail part. When they click submit, the grid won't rebuild and they get an error about expanding the grid part. The record goes into the database but the grid won't appear. I checked the server logs and there are a number of entries like the following:
I've scoured these boards and seen occasional mention of this type of error, usually resolved by upgrading the server build. But (AFAIK) I'm on the latest version and this is killing me. I've now got to expand the application and write additional ones and frankly if I can't get to the bottom of this I'll be forced to switch to C# .NET, which I really don't want to do. Either that or lose my client and the projects with it. I have similar projects on a much smaller scale and those don't seem to be throwing these errors (same database design, although of course there are slight differences) or at least clients don't report them. I'm confident in using Alpha for those smaller apps but a larger one, now I'm not so sure.
Does anyone have any idea what might be going on?
Thanks in advance.
It's a master-detail relationship with a read-only grid and an editable detail part. When they click submit, the grid won't rebuild and they get an error about expanding the grid part. The record goes into the database but the grid won't appear. I checked the server logs and there are a number of entries like the following:
Code:
Fri Nov 13 07:07:52 2015 Thread: AppServerWorker1 Request URI: /__a5RunGrid.a5w?__pageName=__a5runGrid.a5w&__gridFilename=FreightBillHeader&__alias=TBI_FREIGHTBIL_112110WQQA&__unsaved=no&_isLookupGrid=false Script: TEMPLATE Line: 1 Property not found rv.KEYS subelement not found. Execution Stack: 0#1 evaluate_shared_private( 0#37 OOhttpdServerClientMIME(ptemp,"AppServerMain") 0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.ScriptName),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path) 0#62 x_out = a5_ajax_grid(tmpl) 0#1 args.set("PKValue_1",convert_type(rv.KEYS.R1[1],"N"))
Does anyone have any idea what might be going on?
Thanks in advance.