Messages

1

Web Server - Ask For Help / Stability of NetTalk apps with MySQL ODBC connection?

« on: September 18, 2014, 11:03:25 PM »

Hey all,

Just wondering if anyone else out there using NetTalk 8 or 9 with a MySQL database via MyODBC has had a history of GPFs ?

We don't do anything out of the ordinary with this app - all pretty basic NetWebBrowses and NetWebForms etc., but we seem to be getting an inordinate number of GPFs.  We installed GPFReporter, to get the logs, but the server does not always restart cleanly and seems to leave a prior running process in memory which means a manual shutdown and restart of the app is required.

We cannot seem to pin point exactly where the error is happening.  We've upgraded the ODBC drivers from the 3.x versions to the 5.x ones, but still the same.  Wonder if anyone else has experienced similar issues, and how you resolved it, if indeed you resolved it?

Here is a sample log dump from GPFReporter:

Code: [Select]

----------------------------------------------------------------------------------
Program : C:\Apps\StudentPortal\StudentPortal.exe
Version :
At : 13:32:05 on 2014/09/19
Workstation: : ip-0A976895
User Name: : Administrator
Reported error : EXCEPTION_ACCESS_VIOLATION - Error reading data at : 000003B0h
Windows : Win 2008-, Terminal Server 6.0.6002 Service Pack 2
Clarion : 0.801
Thread : 3 Field : 0 Event : 0 Keycode : 0
Error at address : 69A2C52Fh  no debug info, Module=C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll 5, 2, 5, 0
Stack Trace
[01] 69A198F9h no debug info, Module=C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll 5, 2, 5, 0
[02] 69A1993Bh no debug info, Module=C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll 5, 2, 5, 0
[03] 69A19CBBh no debug info, Module=C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll 5, 2, 5, 0
[04] 69A10333h no debug info, Module=C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll 5, 2, 5, 0
[05] 69A10971h no debug info, Module=C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll 5, 2, 5, 0
[06] 69A109C1h no debug info, Module=C:\Program Files\MySQL\Connector ODBC 5.2\myodbc5a.dll 5, 2, 5, 0
[07] 7365FFCDh no debug info, Module=C:\Windows\system32\ODBC32.dll 6.0.6002.18362 (vistasp2_gdr.101228-0237)
[08] 73699DB8h no debug info, Module=C:\Windows\system32\ODBC32.dll 6.0.6002.18362 (vistasp2_gdr.101228-0237)
[09] 00382C79h no debug info, Module=C:\Apps\StudentPortal\ClaODB.dll 8.0.9759
??? 0068E988h Line ?=42 no proc Src=Stude_nw.clw
??? 00407843h Line=493 Proc=FUNCTIONCALLED_@_FILECALLBACKINTERFACE_@_FILEMANAGER@F21FILECALLBACKINTERFACEl6PARAMSRscRsc  Src=ABFILE.CLW
??? 01120840h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E910h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E978h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E8A8h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E978h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E770h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E9E0h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E978h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112E5DCh Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112EBD0h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112EBD0h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 01125824h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0068E5E8h Line ?=42 no proc Src=Stude_nw.clw
??? 01120840h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
??? 0053A0E4h Line=3684 Proc=R$GENERATETABLEROWS  Src=StudentPortal001.clw
??? 0053A592h Line=4314 Proc=R$ADDPACKET Src=StudentPortal001.clw
[10] 0053AF3Eh Line=3611 Proc=R$BROWSETABLE Src=StudentPortal001.clw
[11] 0053C58Ah Line=3565 Proc=R$GENERATEBROWSE  Src=StudentPortal001.clw
??? 0067A4E4h Line ?=42 no proc Src=Stude_nw.clw
[12] 0053CC44h Line=3141 Proc=R$TAKEEVENT Src=StudentPortal001.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
??? 00672BD0h Line ?=42 no proc Src=Stude_nw.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[13] 0053DFDFh Line=3095 Proc=BROWSESTUDENTS@F18NETWEBSERVERWORKER  Src=StudentPortal001.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
??? 00677150h Line ?=42 no proc Src=Stude_nw.clw
??? 011004D2h Line=3342 Proc=9_PRINTDLG__SetVarProperty@FiP3Ufo  Src=wsl.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
[14] 0054E0ABh Line=1132 Proc=PROCESSTAG@F13THISNETWORKERsb  Src=StudentPortal001.clw
??? 00665D4Ch Line ?=42 no proc Src=Stude_nw.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[15] 00480EA3h Line=6389 Proc=_HANDLETAG@F18NETWEBSERVERWORKERsbOsb  Src=NetWeb.Clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[16] 0047DEA2h Line=6876 Proc=R$MIDDLEBIT Src=NetWeb.Clw
??? 00668908h Line ?=42 no proc Src=Stude_nw.clw
??? 00666AD0h Line ?=42 no proc Src=Stude_nw.clw
[17] 0047E292h Line=6838 Proc=PARSEHTML@F18NETWEBSERVERWORKERRsbllUc  Src=NetWeb.Clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[18] 0047E3D6h Line=6755 Proc=PARSEHTML@F18NETWEBSERVERWORKER12STRINGTHEORYllUc  Src=NetWeb.Clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[19] 004697E3h Line=7714 Proc=MAKEPAGE@F18NETWEBSERVERWORKEROsbllOsbOsbOsb  Src=NetWeb.Clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[20] 0054C85Ch Line=1467 Proc=R$CASE:BROWSESTUDENTS  Src=StudentPortal001.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[21] 0054D6D8h Line=1364 Proc=R$CASESTART:STUDENTPORTAL  Src=StudentPortal001.clw
[22] 0054D904h Line=1350 Proc=_SENDFILE@F13THISNETWORKERsbl  Src=StudentPortal001.clw
[23] 0047F3C9h Line=6198 Proc=_HANDLEGETREST@F18NETWEBSERVERWORKER  Src=NetWeb.Clw
??? 00672BD0h Line ?=42 no proc Src=Stude_nw.clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[24] 00488406h Line=2628 Proc=PROCESSREQUEST@F18NETWEBSERVERWORKERsb  Src=NetWeb.Clw
??? 0067F42Ch Line ?=42 no proc Src=Stude_nw.clw
[25] 0054EC2Eh Line=990 Proc=WEBHANDLER@Fsb  Src=StudentPortal001.clw
[26] 010BEF33h no line number Proc=15ThreadLaunch_EH$Run@F  Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 011349DCh Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 01116F2Ah Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
[27] 010BEC59h no line number no proc Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 01116F45h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 011349DCh Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 01134A5Ch Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 01129378h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112938Ch Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 011293A8h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 0112939Ch Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 011293C4h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
??? 011293B8h Line ?=26 no proc Src=wxeh.cpp Module=C:\Apps\StudentPortal\ClaRUN.dll 8.0.9759
[28] 77D416C3h no debug info, Module=C:\Windows\system32\ntdll.dll 6.0.6001.18000 (longhorn_rtm.080118-1840)
[29] 77D41696h no debug info, Module=C:\Windows\system32\ntdll.dll 6.0.6001.18000 (longhorn_rtm.080118-1840)


Thanks,
Devan

2

Web Server - Ask For Help / Re: LOG: This is dangerous?

« on: August 27, 2014, 11:36:17 PM »

Yeah,

On my public Nettalk webservers, I routinely see all sorts of calls made to phpmyadmin and other routes.  Tons of them.  Quite funny actually.  Oh well, I guess it is wasting processing time for some hacker, so I consider it a community service! 

Cheers,
Devan

3

Web Server - Ask For Help / Re: Browse behaviour using MySQL

« on: August 27, 2014, 11:33:50 PM »

Hi Rene,

I have problems with MySQL tables if I don't specify a truly unique index in the Browse procedure.  Sometimes I've tried using a non unique index and get some crazy things happening, so always have to resort to a unique primary index in the properties screen and do my other sorting under the 'Sort' tab.

Cheers,
Devan

4

Web Server - Ask For Help / Re: Printing a report with no detail lines

« on: August 18, 2014, 03:25:29 PM »

Thanks Kevin.

We have another project where I have a 'placeholder' PDF to serve up when there are no reports, as you suggested.   It worked well, but this particular site is a unique case where on occasion the customer can enter an order with just some comments, and no actual line items being selected.

In these cases, my client wants the order to still be emailed with the customer details in the header and the comments in the footer so their sales team can still chase up the customer.

I am thinking that most of the other workaround are based around 'normal' Clarion reports on Win32 using the Previewer.  In this case, I am generating a PDF directly in the background with no previewer at all, so not sure if those workaround will be effective??

Cheers,
Devan

5

Web Server - Ask For Help / Printing a report with no detail lines

« on: August 18, 2014, 12:05:48 AM »

This isn't technically a NetTalk issue directly, but it affects an NT7 site that we currently have (in Clarion 8 - We haven't upgraded this one to NT8 and Clarion 9 yet).

We have a routine in there that generates a PDF Order Confirmation report on disk and emails it to the user and our client's sales team on a background thread.  All works fine except that it used to NOT create the PDF whenever the user entered an order with no detail lines.

Our client has come back to us and said that even if the user does not enter any lines on the order, they still want the report to generate and be sent to the user and their sales team.  I've done a brief search, and it seems to be popular believe that if we embed:

ReturnValue = 0

on the ThisWindow.OpenReport embed point, it should print the report irrespective of whether it finds detail records or not, but it still does not seem to be working.

Any tips on how we can still get the report to forcibly print the header bands etc.?

Cheers,
Devan

6

Web Server - Ask For Help / NT8.10 - Adding a button to mobile header bar

« on: May 18, 2014, 02:39:22 PM »

We are designing a NetTalk based web app that will be called when a user scans a QR Code on bottles of medication that is supplied by our customer.

Basically, when the user scans a QR Code, they will be taken straight to a WebForm which displays information on that vial.

It works fine on the desktop and mobile versions of the site - HOWEVER, on the desktop version, the main menu is available, so the user can then go to the home page by clicking the first menu option, then navigating elsewhere on the portal.

On the mobile version of the site - the menu does not appear.  Not a big problem.  I was thinking to add a 'Home' button on the top bar of the mobile screen so that the user can go back and do other thing but I am not sure which is the best way to go about this?

At the moment, I have added a button at the bottom of the form, but ideally would like it to be on the top bar for a better mobile experience.

Thanks,
Devan

7

Web Server - Ask For Help / Redactor editor kaput?

« on: May 15, 2014, 06:48:54 PM »

Hi all,

Just starting a new project with Clarion 9.0 and NetTalk 8.10.

I have a form that has a Text edit area in it, and I left everything as per the default Redactor editor, but having a problem with it.

The editor box and controls are showing, along with the toolbar etc., but I cannot click within the editor window to make and changes to the content.  If I preload content in the database directly, it shows in the editor window, but I cannot change anything.

Tried it in Chrome and IE with the same results.

Have I missed something important?

I tried switching back to TinyMCE as the editor, but it gives me NO editor window - just a plain HTML text box.  Wondering if the template is broken, or there is another issue?

Thanks,
Devan

8

Web Server - Ask For Help / Re: Where to put user data?

« on: May 14, 2014, 04:40:45 PM »

Keith,

We went through a similar thought process here with a project a couple of years ago.  We went with the single SQL database with unique user IDs, and glad we did.

MySQL is our database solution for nearly all our NetTalk proejct now.  We only use MS-SQL whenever the clients specifically request it to suit their network requirements.  We never use TPS anymore for NetTalk sites.

One of the biggest benefits we found with a single database table, was that it made it really easy for US to administrate and to check user activity levels etc.  We could easily tell which users were more active than other, plus run other periodic metrics and statistics in the database because all the data was in one place.  Trying to do that over a thousand separate sets of data would have been a nightmare.

Hope this helps.

Devan

9

The Rest - Ask For Help / Re: Multiple page requests with NetWebClient

« on: March 27, 2014, 08:08:30 PM »

Thanks Bruce,

I did as you suggested and split the routine up into two parts, i.e. populate a queue from the SQL database, then run a process to 'run down' the queue and perform the fetches.

It still needed some deft timing to ensure that the processing didn't start a race condition.  I tried using the ThisNetWebClient.Busy property within the loop to see if the previous Fetch() was still working but didn't seem to have much luck with that, so I ended up creating a local BYTE variable called LOC:Busy which I set upon calling the Fetch() routine and cleared when ErrorTrap() and PageReceived() were called, and that seemed to work fine for my needs.

Cheers,
Devan

10

The Rest - Ask For Help / Multiple page requests with NetWebClient

« on: March 26, 2014, 08:43:37 PM »

I have a small Clarion applet which runs a NetWebClient Fetch() against a web service.  Sometime only one page, but often 3 or 4 pages depending on the results of a SQL query.

I have the Fetch()es in a loop, i.e.

Code: [Select]

Loop
  Next(SQLFile)
  If Error() Then Break.
  ThisNetWebClient.Fetch('http://mywebservice.com/getarecord?id=' & SQL:SomeID)
End
I thought with asynchronous Fetch()es, that the ThisNetWebClient.PageReceived will be called each time a Fetch() returned some data, but it doesn't seem to be doing that.  So far, I trace multiple Fetch() calls going out, but only one PageReceived() being called - for the first Fetch() only.

What is the best way to queue up multiple concurrent Fetch() calls?

Thanks,
Devan

11

Web Server - Ask For Help / Re: CSS hierarchy tool

« on: March 03, 2014, 10:02:17 PM »

I also use Chrome's Developer Tools option (F12 on the PC) for inspecting CSS.  Best thing ever for checking the hierarchy and also changing/removing/adding CSS code on the fly to see what will happen.

NOTE: It's all built into Chrome natively.  No need to install an extension.

12

Web Server - Ask For Help / NetTalk threads and open files

« on: March 03, 2014, 10:00:36 PM »

Hi all, just come across a curious situation here, and wondering if someone can shed some light on where the problem lies.

We have designed a small NetTalk app for a customer to register walk in members for a gym.  Really simple NetTalk site with a page that asks for the member ID (which is scanned at the terminal), then another Process that checks the number against a legacy database and then displays either a "Welcome" screen or a "Please Register" screen momentarily before going back to the main screen.

The only file access is during the CheckLogin procedure that gets called by the IndexPage.  The CheckLogin process opens up the user file on the legacy database using an ODBC driver, then closes the files straight afterwards.

I thought this would only momentarily touch the files and exit, leaving those files free from locks, however the customer's IT department is saying that they cannot backup the legacy database every night because it is saying the files are open in the NetTalk app.  Closing down or restarting the NetTalk app completely appears to clear the locks.

Now, I thought that once I deliberately closed the files in the Process, or the process thread ended, the files would be closed and any locks released?  Could there be phantom threads still running in the background?  Is the fault with the third party ODBC driver?  Or the Clarion ODBC driver architecture?

The files are defined in the main app dictionary, but the files are ONLY referenced in the CheckLogin NetWebPage - which is not actually a displayed page, but a snippet of embed code that then redirects the user depending on the check login status.

It's not a huge problem, but I'm curious to know where to start looking for the issue.

Thanks,
Devan

13

Web Server - Ask For Help / How many using C9 now?

« on: February 25, 2014, 05:02:12 PM »

Hey all - This is off topic I know, but I was wondering how many NetTalkers have moved up and are using C9.x for production code?

I am still on 8.0.9759 but am on the CSP and have C9 as well - just haven't bothered to upgrade all my myriad of 3rd party libraries etc. up to C9 to begin using it properly.  Been really happy with the stability of C8, so was wondering if there was any compelling reasons to step up to 9?

At this point in time, our app development word is around 60% NetTalk webapp projects and 40% Windows native projects.  All straight up Clarion, not Clarion.NET.

What are others using?  I'd be interested to hear if anyone is still on C7 or C6 even...

14

Web Server - Ask For Help / Re: Browse not saving data back to database?

« on: February 12, 2014, 12:21:58 AM »

EDIT: Actually, I just checked the NetWebForm, and I must have been getting really stressed at it not working, because I have the price calculation routine called on the:

Validate::LIN:Price (even though this field is read only)
Validate::LIN:ProductCode
Validate::LIN:Quantity
PreInsert
ValidateAll
ValidateInsert

embed points within the form !!!

15

Web Server - Ask For Help / Re: Browse not saving data back to database?

« on: February 12, 2014, 12:16:17 AM »

Bruce,

Your questions are actually GREAT, because they are leading me in the right track to find out what is happening.

I remember now that we DO have a calculation routine in the form to calculate the price and line total, but it never worked 100% of the time.  So I worked around this by putting the price calculation routine in the browse as well, forgetting that the Browse procedure DOESN'T ACTUALLY SAVE the line item data.  So in effect, I was just masking the fact that the problem was there, and caused by the NetWebForm in the first place!

Now, the NetWebForm really only has two changeable fields, the Product Code (which is always called from a lookup button), and the quantity.  I have set the code in the Validate::LIN:Quantity embed point to calculate the Price and LineTotal, but as I mentioned - it doesn't always seem to fire.  I think it may be depending on whether the user [Tabs] out of the quantity field, or whether they just hit the [Save] button immediately after keying in the quantity.

Need to find a better embed point to do the calculation, I think...

Cheers,
Devan