Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / Re: Crash - PLEASE HELP!
« on: August 18, 2015, 10:37:15 PM »
Hi Rodrigo,
>> How can I change the sql lockin time, I think it could be that my sql locks and that causes de web server to get so slow...
Do you have any evidence for this, or are you just guessing? (guessing is ok, but it's useful to know if it's a stronger feeling than that.)
From the performance stats you can see that currently 11 threads a re running. By looking a the Get/Post log you will be able to see what the last request for each of those threads are, and when they occurred. Perhaps you have an endless loop in your code, or an especially expensive process or report or something, that swamps the server.
In other words, let's say you have a report which takes 5 minutes to generate. A large number of request for that report would slow down the system a lot, and inhibit other requests.
However I notice you have 11 threads, but only 3 connections, which implies the others maybe abandoned the request. Which may indicate that it's a never-ending process which is happening. But not just never-ending quiet (which is what I would expect from a SQL lock) but never-ending-busy which I would expect from a simple code bug nor breaking out of a loop correctly.
You'll also see from the stats that you have a fair number of requests (274) which have a high response time. This might be a report (which makes sense) or it might be for something else you are not expecting to take long. So more investigation there is useful.
I'd start with the 11 threads though - that's where the biggest clue lies.
cheers
Bruce
>> How can I change the sql lockin time, I think it could be that my sql locks and that causes de web server to get so slow...
Do you have any evidence for this, or are you just guessing? (guessing is ok, but it's useful to know if it's a stronger feeling than that.)
From the performance stats you can see that currently 11 threads a re running. By looking a the Get/Post log you will be able to see what the last request for each of those threads are, and when they occurred. Perhaps you have an endless loop in your code, or an especially expensive process or report or something, that swamps the server.
In other words, let's say you have a report which takes 5 minutes to generate. A large number of request for that report would slow down the system a lot, and inhibit other requests.
However I notice you have 11 threads, but only 3 connections, which implies the others maybe abandoned the request. Which may indicate that it's a never-ending process which is happening. But not just never-ending quiet (which is what I would expect from a SQL lock) but never-ending-busy which I would expect from a simple code bug nor breaking out of a loop correctly.
You'll also see from the stats that you have a fair number of requests (274) which have a high response time. This might be a report (which makes sense) or it might be for something else you are not expecting to take long. So more investigation there is useful.
I'd start with the 11 threads though - that's where the biggest clue lies.
cheers
Bruce
2
Web Server - Ask For Help / Re: Locators stopped working on my project in 7.17
« on: August 01, 2013, 05:15:56 AM »
>> I assume that these changes will be incorporated in 7.19?
nah... I just sent them to show you I have the power to fix it if I choose <evil laugh mwahahahah>
nah... I just sent them to show you I have the power to fix it if I choose <evil laugh mwahahahah>
3
Web Server - Ask For Help / Re: File upload problem
« on: April 17, 2013, 11:56:41 PM »
Hi Ashley,
unfortunately those log files are not helpful because they contain way too much information.
Those are "NetTalk" log files, which is a low-level diagnostic used for debugging the TCP/IP level, whereas for what you're doing we need to see what's happening at a very high level.
So first step - turn off the logging options on the NetTalk global extension.
Also, I think you've maybe gotton a bit stuck, so perhaps now is the time to email me (or post here) your apps & dict etc so I (or others) can take a look at what you are doing, aand perhaps more fully understand the problem you're in. I think the actual problem is probably very simple, but it's hard to debug someone else's program when you can't see the code.
cheers
Bruce
unfortunately those log files are not helpful because they contain way too much information.
Those are "NetTalk" log files, which is a low-level diagnostic used for debugging the TCP/IP level, whereas for what you're doing we need to see what's happening at a very high level.
So first step - turn off the logging options on the NetTalk global extension.
Also, I think you've maybe gotton a bit stuck, so perhaps now is the time to email me (or post here) your apps & dict etc so I (or others) can take a look at what you are doing, aand perhaps more fully understand the problem you're in. I think the actual problem is probably very simple, but it's hard to debug someone else's program when you can't see the code.
cheers
Bruce
4
Web Server - Ask For Help / Re: Server doesn't respond
« on: March 18, 2013, 07:35:07 PM »
The most useful information on a GPF is provided by GPF Reporter. That tells you the line of code that GPF'd and the code leading up to that code. In my experience it's the most effective way to find a GPF.
Cheers
Bruce
Cheers
Bruce
5
Web Server - Ask For Help / Re: WebService Problem
« on: March 14, 2013, 10:58:19 PM »
For CaseAsIs to work, the fields in the structure need an External Name, with the correct case.
otherwise the "label" is used (which to the compiler is always uppercase)
eg
Forecast_date string(20),name('Forecast_Date')
PinNumber long,name('PinNumber')
Cheers
Bruce
otherwise the "label" is used (which to the compiler is always uppercase)
eg
Forecast_date string(20),name('Forecast_Date')
PinNumber long,name('PinNumber')
Cheers
Bruce
6
Web Server - Ask For Help / Re: NT7 attaching browse to Browse
« on: March 14, 2013, 01:20:01 AM »
no, probably not the next update.
I've spent the last 2 weeks refactoring the object generation system we use, along with the approach for multi-dll apps, and also support for C8 multi-Proj across the tools. It's been a huge task but I think all the under-pinnings are ok now. I've completed 19 products so far, and I have about 8 or 9 more to do before they're all up to the same standard.
You've seen some of the results of that already with the StringTheory build causing NT apps to crash if the ST global extension is not added. So as soon as I've got this task complete I need to post an NT update (NT is one of the very few tools we make, that's shipped as objects in source code, but which is unaffected by the change) so that there is an error generated if ST is missing.
So I won't be making major changes for the next build, just the accumulated fixes, and the warning.
But hopefully I will be able to work on it a bit after that.
First I have to get my big app to build so I can be sure the new underlying system is actually working and I can release all the changes I've made to the other products.
It's been a huge job, and it sweeps across almost all the products, but the result is a much more consistent experience, and also some consistency for the products going forward.
Cheers
Bruce
I've spent the last 2 weeks refactoring the object generation system we use, along with the approach for multi-dll apps, and also support for C8 multi-Proj across the tools. It's been a huge task but I think all the under-pinnings are ok now. I've completed 19 products so far, and I have about 8 or 9 more to do before they're all up to the same standard.
You've seen some of the results of that already with the StringTheory build causing NT apps to crash if the ST global extension is not added. So as soon as I've got this task complete I need to post an NT update (NT is one of the very few tools we make, that's shipped as objects in source code, but which is unaffected by the change) so that there is an error generated if ST is missing.
So I won't be making major changes for the next build, just the accumulated fixes, and the warning.
But hopefully I will be able to work on it a bit after that.
First I have to get my big app to build so I can be sure the new underlying system is actually working and I can release all the changes I've made to the other products.
It's been a huge job, and it sweeps across almost all the products, but the result is a much more consistent experience, and also some consistency for the products going forward.
Cheers
Bruce
7
Web Server - Ask For Help / Re: Runtime Language Translation Issues and more.
« on: March 04, 2013, 11:35:51 PM »
we gotta keep these threads shorter <g>.
this forum software doesn't like long threads for some reason.
But no, you didn't cloud the issue, and the issue has been fixed for 7.07.
(I did it in a slightly different way to you, but the result is the same, well the same in the sense that mine works without the \ being displayed.)
>> ... and if user text is being included then p_web.jsParm method must be applied.
In very specific cases yes, but in all cases no. One of the fun bits of HTML, and JavaScript is the various encodings used in various places.
Cheers
Bruce
this forum software doesn't like long threads for some reason.
But no, you didn't cloud the issue, and the issue has been fixed for 7.07.
(I did it in a slightly different way to you, but the result is the same, well the same in the sense that mine works without the \ being displayed.)
>> ... and if user text is being included then p_web.jsParm method must be applied.
In very specific cases yes, but in all cases no. One of the fun bits of HTML, and JavaScript is the various encodings used in various places.
Cheers
Bruce
8
Web Server - Ask For Help / Re: Conditionaly change the color of a browse cell.
« on: February 05, 2013, 09:36:15 PM »
>> I forgot to ask, in one of the previous posts to this thread you said "... maybe you might change your mind if you could see what's coming."
>> Did you mean in the next version of CSS/HTML5 or Nettalk?
No I meant what's coming in your learning curve. ie you'll get to a place where you want to get serious about styling, maybe change the visuals, maybe see a new theme you like, maybe make a whole new app and have it use the same "look" as this one.
As you go further down the web-app road you'll see the power of CSS come into play. It's not something that makes a lot of sense, but you'll get to an ah-ha point down the road where you go "oh wow".
cheers
Bruce
>> Did you mean in the next version of CSS/HTML5 or Nettalk?
No I meant what's coming in your learning curve. ie you'll get to a place where you want to get serious about styling, maybe change the visuals, maybe see a new theme you like, maybe make a whole new app and have it use the same "look" as this one.
As you go further down the web-app road you'll see the power of CSS come into play. It's not something that makes a lot of sense, but you'll get to an ah-ha point down the road where you go "oh wow".
cheers
Bruce
9
Web Server - Ask For Help / Re: Conditionaly change the color of a browse cell.
« on: February 05, 2013, 09:48:20 AM »
ok, add this to your custom classes;
.currency:before{
content: "$";
float:left;
}
then add currency to the list of classes attached to the total.
hint: it won't make the column wider, so if you need to make the column wider by making the header longer, or setting a min-width for the header etc.
cheers
BRuce
.currency:before{
content: "$";
float:left;
}
then add currency to the list of classes attached to the total.
hint: it won't make the column wider, so if you need to make the column wider by making the header longer, or setting a min-width for the header etc.
cheers
BRuce
10
Web Server - Ask For Help / Re: NT 6 to NT 7 app upgrades
« on: December 18, 2012, 05:30:32 AM »
yeah, I thought maybe it was. Ok, remember that we removed the "logout" line from the Login page? That means that just going to the logout page no longer logs you out. You'd need to go to an actual "logout" page to do that.
So maybe make a netwebpage.
Put a "thanks for coming" type message on it.
and move the p_web.SetSessionLoggedIn(0) call there.
Then you'll probably need to adjust the Header on that page so that it shows a reduced set of menu options.
cheers
Bruce
So maybe make a netwebpage.
Put a "thanks for coming" type message on it.
and move the p_web.SetSessionLoggedIn(0) call there.
Then you'll probably need to adjust the Header on that page so that it shows a reduced set of menu options.
cheers
Bruce
11
Web Server - Ask For Help / Re: Web Browse - "Range" not working
« on: November 25, 2012, 09:18:49 PM »
Hi Peter,
>> What did I miss
you're setting your local variable as
Loc:MailBox = 'Peter'
you should set it as
p_web.SSV('Loc:MailBox','Peter')
Browses are multi-entrant, so work on Session Values.
cheers
Bruce
>> What did I miss
you're setting your local variable as
Loc:MailBox = 'Peter'
you should set it as
p_web.SSV('Loc:MailBox','Peter')
Browses are multi-entrant, so work on Session Values.
cheers
Bruce
12
E-Mail - Ask For Help / Re: GPF When Sending Emails Pt3
« on: October 03, 2012, 07:02:47 AM »
I haven't had a chance to revisit the email thing yet. The tests in C8 seem ok, so I need to fire up the old C6 install to see if there's something different there. It might just be a timing thing, or it may be more than that.
One tip with the other forums is not to open multiple tabs to the forums at the same time. doing that can cause interesting behaviours.
One tip with the other forums is not to open multiple tabs to the forums at the same time. doing that can cause interesting behaviours.
13
E-Mail - Ask For Help / Re: GPF when sending emails on multiple threads
« on: September 19, 2012, 02:58:22 AM »
Hi Richard,
I think it's unlikely that the thread number is going wrong. We have a number of highly threaded apps, and none have ever shown signs of getting the numbers wrong.
Obviously though there is a disconnect between the one view of your thread number, and the other. It might be worth examining the class to see if there's a reason why it might be getting it wrong.
It might be time for you to post a small example app of what you are trying to do, so we can see if we get the same effect as you.
cheers
Bruce
I think it's unlikely that the thread number is going wrong. We have a number of highly threaded apps, and none have ever shown signs of getting the numbers wrong.
Obviously though there is a disconnect between the one view of your thread number, and the other. It might be worth examining the class to see if there's a reason why it might be getting it wrong.
It might be time for you to post a small example app of what you are trying to do, so we can see if we get the same effect as you.
cheers
Bruce
14
Web Server - Ask For Help / Re: Photo Thumbnail - resize proportionally
« on: July 18, 2012, 09:37:24 PM »
what build of NetTalk are you on Ian?
the current build of the example is attached, but it's been in NetTalk a while, so if you don't have it then either you're using a very old build, or you're not looking for your examples in the right place.
Cheers
Bruce
[attachment deleted by admin]
the current build of the example is attached, but it's been in NetTalk a while, so if you don't have it then either you're using a very old build, or you're not looking for your examples in the right place.
Cheers
Bruce
[attachment deleted by admin]
15
Web Server - Ask For Help / Re: Error in Javascript Web9 SSL Example (cont)
« on: July 12, 2012, 05:47:45 AM »
>> C:\Clarion6\3rdParty\bin exists, jsmin.exe and gzip.exe exist in this folder as well.
ok, that's good. but strange.
One thing, I assumed was a typo, but worth a check - earlier you posted;
>> from the gzipall.bat file there is this line
>> C:\CLARION6\3rdparty\bin\gzip" -9 -n -f -c web\scripts\all.js > "web\scripts\all.js.gz
>> when its run manually the response is
>> The system cannot find the path specified.
the line in the bat file actually starts and ends with a " - and that's important - so try
"C:\CLARION6\3rdparty\bin\gzip" -9 -n -f -c web\scripts\all.js > "web\scripts\all.js.gz"
and let me know if that reports an error.
You should be in your app folder when you run this line, because the command is relative to the web\scripts folder. ie it's expecting to be run from one folder up from web - ie the app folder.
also I'm presuming that web\scripts\all.js exists at this point.
cheers
Bruce
ok, that's good. but strange.
One thing, I assumed was a typo, but worth a check - earlier you posted;
>> from the gzipall.bat file there is this line
>> C:\CLARION6\3rdparty\bin\gzip" -9 -n -f -c web\scripts\all.js > "web\scripts\all.js.gz
>> when its run manually the response is
>> The system cannot find the path specified.
the line in the bat file actually starts and ends with a " - and that's important - so try
"C:\CLARION6\3rdparty\bin\gzip" -9 -n -f -c web\scripts\all.js > "web\scripts\all.js.gz"
and let me know if that reports an error.
You should be in your app folder when you run this line, because the command is relative to the web\scripts folder. ie it's expecting to be run from one folder up from web - ie the app folder.
also I'm presuming that web\scripts\all.js exists at this point.
cheers
Bruce