FoxInCloud
Error in app moving on a grid
Gravatar is a globally recognized avatar based on your email address. Error in app moving on a grid
  Michele
  All
  May 2, 2018 @ 05:31am

I still have this kind of error when in my main form a move me on a grid...Not always, randomly...

awajax.lSuccess(.f.): Error detected at code line #14,545 of method 'awajax.propchangedhtml_grid' "Method or procedure gethtml_grd_aw_cscript_dynprops(): error #2071 ("User Thrown Error - Method or procedure gethtml_grd_aw_cscript_dynprops(): error #1234 ("Subscript is outside defined range") at code line #12,170") at code line #12,386"

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  May 2, 2018 @ 06:29am

Ciao Michele, v 2.26.2?

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  May 2, 2018 @ 06:32am

The version we are workin in production is 2.26.1 We plan to install 2.26.2 in next updates...

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  May 3, 2018 @ 12:32am

If you have the error notification email with the attached state tables, please forward it to support at foxincloud.com

Even if 2.26.2 does not solve the issue, we’ll need to match the error line numbers with source code

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  May 3, 2018 @ 01:00am

This is the original mail message

05/02/18 06:06:28 PM awajax.lSuccess(.f.): Error detected at code line #13,557 of method 'awajax.useraction' "FoxInCloud could not process this request: Awajax.useraction() - Error while executing method '_form_bollettino_print._commandbutton2.Clickinet()': Method or procedure cr_query(): error #3 ("File is in use") at code line #136 Parameters received:

  • Value : -N/A-
  • Object : _commandbutton2

    Event: click Property: none Method: none"

Exe: "C:\Program Files (x86)\AcutMobile\mobtest.exe", version 11.2.245 of 04/18/18 04:50:18 PM Process ID: 12628 URL: http://217.57.86.186/acutmobile/DOMEvent.mob?&Event=click&ObjAddr=_form_bollettino_print-_commandbutton2&UserID=55B10D7GG&PageInit=&nReq=68 Client: 192.168.0.200 userID: 55B10D7GG Form variables: &nKeyCode= &nButton=1 &nShiftAltCtrl=0 &nXcoord=97 &nYcoord=46 &nRow=394 &nCol=188 &lastKey=0 &version=2.26.1 &sync=false &vpw=1583 &vph=763 &userID=55B10D7GG &reqID=1262_56W12T3Z7-001 &nInet=0.000 &nCli=0.000 Call stack: 1_.processhit (561) > 2_.process (894) > 3_.routerequest (913) > 4_mobprocess.process (2678) > 5_wwprocess.process (272) > 6_mobprocess.domevent (4548) > 7_mobprocess.ajaxformrequest (4564) > 8_awajax.formrequest (8790) > 9_awajax.useraction (13558) FAS version: 2.26.1 of 2018-02-15 04:43:29 PM GMT (3 months ago) Table New: 'C:\Program Files (x86)\AcutMobile\Temp\55B10D7GG_55b10d7gg_form_bollettino_print_New.DBF' can't be found


 Query String: &Event=click&ObjAddr=_form_bollettino_print-_commandbutton2&UserID=55B10D7GG&PageInit=&nReq=68
DLL or Script: /acutmobile/DOMEvent.mob
             : C:\inetpub\wwwroot\AcutMobile\DOMEvent.mob

Host Server Name: 217.57.86.186 Machine Name: SRV1 Referring Link: http://217.57.86.186:13030/acutmobile/main.mob Client IP Address: 192.168.0.200 Client Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0 Username: -- Form Vars:----------------------------------- &nKeyCode=&nButton=1&nShiftAltCtrl=0&nXcoord=97&nYcoord=46&nRow=394&nCol=188&lastKey=0&version=2.26.1&sync=false&vpw=1583&vph=763&userID=55B10D7GG&reqID=1262_56W12T3Z7-001&nInet=0.000&nCli=

Here is the link to state tables received

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  May 7, 2018 @ 07:47am

Method or procedure cr_query(): error #3 ("File is in use") at code line #136

What code do you have at this line?

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  May 7, 2018 @ 07:51am

The last error message is wrong...This is the correct one... Excuse me...

05/04/18 05:35:55 PM
awajax.lSuccess(.f.): Error detected at code line #14,545 of method 'awajax.propchangedhtml_grid'
"Method or procedure gethtml_grd_aw_cscript_dynprops(): error #2071 ("User Thrown Error - Method or procedure gethtml_grd_aw_cscript_dynprops(): error #1234 ("Subscript is outside defined range") at code line #12,170") at code line #12,386"

Exe: "C:\Program Files (x86)\AcutMobile\mobtest.exe", version 11.2.245 of 04/18/18 04:50:18 PM Process ID: 10372
URL: http://217.57.86.186/acutMobile/DOMEvent.mob?&Event=click&ObjAddr=main_scx-_pageframe1-page1-_commandbutton2&UserID=56O14H73S&PageInit=&nReq=105
Client: 151.18.78.155
userID: 56O14H73S
Form variables:   &nKeyCode=  &nButton=1  &nShiftAltCtrl=0  &nXcoord=44  &nYcoord=90  &nRow=60  &nCol=113  &lastKey=0  &version=2.26.1  &sync=false  &vpw=1280  &vph=679  &userID=56O14H73S  &reqID=1037_56Y0ZQ5CK-001  &nInet=0.000  &nCli=0.003
Call stack: 1_.processhit (561) > 2_.process (894) > 3_.routerequest (913) > 4_mobprocess.process (2678) > 5_wwprocess.process (272) > 6_mobprocess.domevent (4548) > 7_mobprocess.ajaxformrequest (4564) > 8_awajax.formrequest (8794) > 9_awajax.formrequestcomplete (8832) > 10_awajax.xmlpropschangedadd (15483) > 11_awajax.propschangedhtml (13966) > 12_awajax.propchangedhtml_grid (14546) FAS version: 2.26.1 of 2018‑02‑15 04:43:29 PM GMT (3 months ago) Table New: 'C:\Program Files (x86)\AcutMobile\Temp\56O14H73S\_56o14h73s_main_scx_New.DBF' can't be found

------------------------------------------------
     Query String: &Event=click&ObjAddr=main_scx-_pageframe1-page1-_commandbutton2&UserID=56O14H73S&PageInit=&nReq=105
    DLL or Script: /acutMobile/DOMEvent.mob
                 : C:\inetpub\wwwroot\AcutMobile\DOMEvent.mob
 Host Server Name: 217.57.86.186
     Machine Name: SRV1
   Referring Link: http://217.57.86.186:13030/acutMobile/Main.mob
Client IP Address: 151.18.78.155
   Client Browser: Mozilla/5.0 (Linux; Android 4.4.4; SM-T561 Build/KTU84P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.126 Safari/537.36
         Username: 
-- Form Vars:-----------------------------------
&nKeyCode=&nButton=1&nShiftAltCtrl=0&nXcoord=44&nYcoord=90&nRow=60&nCol=113&lastKey=0&version=2.26.1&sync=false&vpw=1280&vph=679&userID=56O14H73S&reqID=1037_56Y0ZQ5CK-001&nInet=0.000&nCli=0.003

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  May 7, 2018 @ 08:18am

Here is the link to state tables received

no link found below…

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  May 7, 2018 @ 08:30am

wrong form, main_scx expected… thanks

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  May 7, 2018 @ 08:47am

This is the error

05/07/18 05:12:19 PM
awajax.lSuccess(.f.): Error detected at code line #14,545 of method 'awajax.propchangedhtml_grid'
"Method or procedure gethtml_grd_aw_cscript_dynprops(): error #2071 ("User Thrown Error - Method or procedure gethtml_grd_aw_cscript_dynprops(): error #1234 ("Subscript is outside defined range") at code line #12,170") at code line #12,386"

Exe: "C:\Program Files (x86)\AcutMobile\mobtest.exe", version 11.2.245 of 04/18/18 04:50:18 PM Process ID: 10616
URL: http://217.57.86.186/acutmobile/MethExec.mob?&MethAddr=wformcallback1&ObjAddr=main_scx&UserID=55D0TWVQR&PageInit=&nReq=203&Value=null&ValueType=object
Client: 151.82.68.122
userID: 55D0TWVQR
Form variables:   &nKeyCode=  &nButton=-1  &nShiftAltCtrl=0  &ValueType=object  &Value=null  &lastKey=0  &version=2.26.1  &sync=false  &vpw=1280  &vph=671  &userID=55D0TWVQR  &reqID=1061_57110VGN0-001  &nInet=0.030  &nCli=0.388
Call stack: 1_.processhit (561) > 2_.process (894) > 3_.routerequest (913) > 4_mobprocess.process (2678) > 5_wwprocess.process (272) > 6_mobprocess.methexec (4557) > 7_mobprocess.ajaxformrequest (4564) > 8_awajax.formrequest (8794) > 9_awajax.formrequestcomplete (8832) > 10_awajax.xmlpropschangedadd (15483) > 11_awajax.propschangedhtml (13966) > 12_awajax.propchangedhtml_grid (14546) FAS version: 2.26.1 of 2018‑02‑15 04:43:29 PM GMT (3 months ago) Table New: 'C:\Program Files (x86)\AcutMobile\Temp\55D0TWVQR\_55d0twvqr_main_scx_New.DBF' can't be found

------------------------------------------------
     Query String: &MethAddr=wformcallback1&ObjAddr=main_scx&UserID=55D0TWVQR&PageInit=&nReq=203&Value=null&ValueType=object
    DLL or Script: /acutmobile/MethExec.mob
                 : C:\inetpub\wwwroot\AcutMobile\MethExec.mob
 Host Server Name: 217.57.86.186
     Machine Name: SRV1
   Referring Link: http://217.57.86.186:13030/acutmobile/main.mob
Client IP Address: 151.82.68.122
   Client Browser: Mozilla/5.0 (Android 4.4.4; Tablet; rv:59.0) Gecko/59.0 Firefox/59.0
         Username: 
-- Form Vars:-----------------------------------
&nKeyCode=&nButton=-1&nShiftAltCtrl=0&ValueType=object&Value=null&lastKey=0&version=2.26.1&sync=false&vpw=1280&vph=671&userID=55D0TWVQR&reqID=1061_57110VGN0-001&nInet=0.030&nCli=0.388

And the files are the same of the message

ftp://159.8.14.218/State_Tables.Zip

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  May 7, 2018 @ 09:01am

Relevant files now, thks

Nothing obviously wrong in awHTML code

I see you have _pageframe1.page1.contain.grid1.Column12.dynamicCurrentControl="IIF(_Tip=1,'Bt1','Bt2')"

  1. Is it the only .dynamic* expression for this grid?
  2. does your code add or remove .dynamic* expressions and/or columns?
  3. Can you reproduce the error? IOW do you know the process that provokes the error?
Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  May 7, 2018 @ 09:06am
  1. For this grid yes... In the same form i have another grid in another page with a dynamic.backcolor
  2. I set .Column12.Visible = .F. in the same grid where i have DynamicCurrentControl ( i can modify it if this is the problem)
  3. No. I saw this error, but i am not able to reproduce it...
Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  May 8, 2018 @ 09:20am

nothing special in code depending on column.visible

please install V 2.26.2 and let's wait until the problem occurs so that we have the exact code line number

we will then setup a try…catch around this line (2.27.0-beta.*) to get all the details to understand the cause

and we'll end up finding it, whatever time it takes

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  Jun 6, 2018 @ 12:56am

This is the complete error message on a customer with Foxincloud 2.26.2

06/05/18 05:00:27 PM
awajax.lSuccess(.f.): Error detected at code line #14,661 of method 'awajax.propchangedhtml_grid'
"Method or procedure gethtml_grd_aw_cscript_dynprops(): error #2071 ("User Thrown Error - Method or procedure gethtml_grd_aw_cscript_dynprops(): error #1234 ("Subscript is outside defined range") at code line #12,197") at code line #12,413"

Exe: "C:\Program Files (x86)\AcutMobile\mobtest.exe", version 11.2.246 of 2018-05-24 09:40:22 AM (2 weeks ago) Process ID: 13104
URL: http://posta.siantel.com:9988/acutMobile/MethExec.mob?&MethAddr=InitControlsInet&ObjAddr=main_scx&UserID=&PageInit=true&nReq=1
Client: 35.158.72.39
userID: 56B0Z3SU2
Form variables:   &lastKey=0  &version=2.26.2  &sync=false  &vpw=320  &vph=450  &userID=  &reqID=  &nInet=0.000  &nCli=0.000
Call stack: 1_.processhit (561) > 2_.process (894) > 3_.routerequest (913) > 4_mobprocess.process (2689) > 5_wwprocess.process (272) > 6_mobprocess.methexec (4587) > 7_mobprocess.ajaxformrequest (4594) > 8_awajax.formrequest (8861) > 9_awajax.formrequestcomplete (8899) > 10_awajax.xmlpropschangedadd (15599) > 11_awajax.propschangedhtml (14080) > 12_awajax.propchangedhtml_grid (14662) FAS version: 2.26.2 of 2018‑04‑20 07:50:16 AM GMT (2 months ago) Table New: 'C:\Program Files (x86)\AcutMobile\Temp\56B0Z3SU2\_56b0z3su2_main_scx_New.DBF' can't be found

------------------------------------------------
     Query String: &MethAddr=InitControlsInet&ObjAddr=main_scx&UserID=&PageInit=true&nReq=1
    DLL or Script: /acutMobile/MethExec.mob
                 : C:\inetpub\wwwroot\AcutMobile\MethExec.mob
 Host Server Name: posta.siantel.com
     Machine Name: SRVACUT
   Referring Link: http://posta.siantel.com:9988/acutMobile/Main.mob
Client IP Address: 35.158.72.39
   Client Browser: Mozilla/5.0 (iPhone; CPU iPhone OS 11_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.0 Mobile/15E148 Safari/604.1
         Username: 
-- Form Vars:-----------------------------------
&lastKey=0&version=2.26.2&sync=false&vpw=320&vph=450&userID=&reqID=&nInet=0.000&nCli=0.000

At the moment i have different installation with this kind of problem in the same situation..

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  Jun 6, 2018 @ 05:33am

Ciao Michele,

Can you confirm you have this code at line #12,197 of modify command awHTML?

oJS.cellTemplates[m.liCol] = m.oJS.cellTemplates[m.liCol];
  + Textmerge(Iif(varSet(@m.oCol, m.paDynProp[m.liProp, 06]) and !Empty(m.oCol.Item(m.luProp)), m.oCol.Item(m.luProp), ''), .F., '<%', '%>') && templates collection indexed by Lower(control name)
Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  Jun 6, 2018 @ 06:10am

No. That code is at 12338

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  Jun 6, 2018 @ 06:11am

do you use 2.26.2 source code? If so, what code do you have at line 12,197?

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  Jun 6, 2018 @ 06:13am

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  Jun 6, 2018 @ 06:15am

Thanks, what code do you have at line 12,197?

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  Jun 6, 2018 @ 06:17am

Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  FoxInCloud Support - Thierry N.
  Michele
  Jun 6, 2018 @ 06:34am

OK, I see, in your case, because grd.column.controlSource are empty, we can't get the column types.

Please replace

, m.paType[m.liCol+1]; && type

by

, Iif(Alen(paType) > m.liCol, m.paType[m.liCol+1], 'C'); && type
Gravatar is a globally recognized avatar based on your email address. re: Error in app moving on a grid
  Michele
  FoxInCloud Support - Thierry N.
  Jun 6, 2018 @ 08:35am

Ok. In next days i'll try it..

© 1996-2024