I have this error while opening some forms in my app. I use bootstrap. In my forms or classes i have no "BEGIN TRANSACTION" command... Same data, same configuration files, on my server it works

FoxInCloud HTML generator Version 2.31.0-beta.4 of 2020-08-07 17:40:21 (3 weeks ago)

awHTMLgen error:

Method or procedure gethtml_cnt_members_bs_3_groups_(): error #1590 ("BEGIN TRANSACTION command failed. Nesting level is too deep") at code line #4.506

Form: Object {BaseClass: "Form", ParentClass: "_form", Class: "_form_appuntamento", ClassLibrary:"c:\program files (x86)\acutmobile\mobile.vcx", autocenter: .F., bordercolor: 14737632, height: 1086, left: 1, name: "_form_appuntamento", top: 1, wbsheight: 1.5, wbslhtmlgen: .T., wbssize: 4, wbswidth: 1.5, wcaliassave: "", wcdomeltid: "_form_appuntamento-comandi-_commandbutton_close1", wchtml: "", wcid: "_form_appuntamento", wclanguser: "it", wcmodalchoiceprop: "wuValue", wcpropsave: "WUPK,USER,CLOSABLE,FIRSTSHOW,MANOVALORI,ID,CHE ...", wcpropsavenot: "", wcssclassadd: "", wcuserid: .NULL., wcwindowtheme: "alphacube", width: 780, wlanonymousallowed: .F., wlhtmlgen: .T., wlinitfirst: .F., wljqueryuidialog: .F., wllan: .F., wlpropsrestore: .F., wlpropssave: .F., wlreleaseforce: .F., wlsubform: .F., wlviews3requery: .F., wlweb: .T., wnreq: -1, wohtmlgen: object, wueffecthide: .F., wueffectshow: .F., wviewportheight: 762, wviewportwidth: 1580}

, Control: Object {BaseClass: "Page", ParentClass: "Awpag", Class: "Mobpag", ClassLibrary:"c:\program files (x86)\acutmobile\mob.vcx", parent: _pageframe1, name: "Page3", wchtml: "", wcid: "_form_appuntamento-_pageframe1-page3", wcpropsave: "", wcpropsavenot: "", wcssclassadd: ""}

, wcID: "_form_appuntamento-_pageframe1-page3"

, BaseClass: "page"

call stack: 01 .processhit (561) > 02 .process (951) > 03 .routerequest (970) > 04 mobprocess.process (2807) > 05 wwprocess.process (255) > 06 mobprocess.domevent (4764) > 07 mobprocess.ajaxformrequest (4783) > 08 awajax.formrequest (9554) > 09 awajax.useraction (14339) > 10 awapphost.useraction (3276) > 11 awapphost.useraction_ (3467) > 12 main_scx._pageframe1.page1.contain.grid1.column7._commandbutton1.clickinet (29) > 13 main_scx._pageframe1.page1.contain.grid1.column7._commandbutton1.click (10) > 14 _commandbutton.click (6) > 15 main_scx._pageframe1.page1.contain.grid1.column7._commandbutton1.buttonclick (2) > 16 main_scx.wform (54) > 17 main_scx.wformnoshow (75) > 18 awapphost.oform (2237) > 19 awapphost.formlaunch (2612) > 20 awapphost.formlaunch_ (2953) > 21 awapphost.cformhtml (1886) > 22 awhtmlgen.gethtml (1482) > 23 awhtmlgen.gethtml_ (1871) > 24 awhtmlgen.gethtml_cnt (2110) > 25 awhtmlgen.gethtml_cnt_members (2402) > 26 awhtmlgen.gethtml_cnt_members_bs_chtml_col (2584) > 27 awhtmlgen.gethtml_cnt_members_bs_chtml_col_ (2704) > 28 awhtmlgen.gethtml_member (2015) > 29 awhtmlgen.o_pageframe1.gethtml (1482) > 30 awhtmlgen.o_pageframe1.gethtml_ (1871) > 31 awhtmlgen.o_pageframe1.gethtml_cnt (2110) > 32 awhtmlgen.o_pageframe1.gethtml_cnt_members (2414) > 33 awhtmlgen.o_pageframe1.gethtml_member (2015) > 34 awhtmlgen.o_pageframe1.opage3.gethtml (1482) > 35 awhtmlgen.o_pageframe1.opage3.gethtml_ (1871) > 36 awhtmlgen.o_pageframe1.opage3.gethtml_cnt (2191)

As it works iteratively, awHTML uses a transaction to be able to roll back changes and try another assumption

It should work exactly the same in development and production: fail or succeed on both sides

Please try to make your layout in pageframe1.page3 more simple, eg. reduce the number of visual columns or groupable controls.

If you need more guidance, please post a screenshot of your VFP page pageframe1.page3.

Thanks in advance

Here are two videos of the same part of app on two different servers both in production mode.

Here it works

Here it doesn't work

if you are sure both servers run the exact same code, then HTML generation this form depend on data:

• if it depends on customer-related data, fine, then you should be able to reproduce on your dev. machine by downloading the customer's data
• if it depends on user-related data, then correct your code so that, at .wlInitFirst, cursors and views are NODATA, and tables are EoF()

in order to fix the issue, we ABSOLUTELY need to reproduce it in development.

I installed on a test server (configured as a production server) the same version of the app, same data and configuration files of my customer... and i have no problems on it.... I make the same thing on my development machine and i have no problems on it.. I have the problems only on the customer's server, but i don't understand what it can be..... I know that there is probably something wrong on the customer's server **I don't know what to do to solve this problem ** that is on Foxincloud part of code that i don't know.

We can solve the issue in development mode only… no hope we can debug on the production server, especially inside an iterative process.

To help you find the difference between the production server and your dev. machine, you may want to compare the form state table (temp/<form name>_ini.dbf) on both side.

Michele,

if you're unable to reproduce in development mode, you can force the generated HTML/JS/CSS:

procedure page3.wcHTMLgen
lparameters toHTML, tlInner

text to this.wcHTML noshow
&& copy and paste HTML from form_scx.htm
endtext

local lcJS
text to lcJS noshow
&& copy and paste JS from form_scx.js
endtext

…and copy and paste CSS from awDefaultAll.css into xxx.css