Jump to content
Software FX Community

Stress test crashing with simplest possible script -- please help!


User (Legacy)

Recommended Posts

Hi,

This is an update to my question of January 4th (which never received a

reply).

What should I tell my customers who are considering upgrading to ChartFX

6.2??? For years they have used 2000/5.5 reliably with at most one crash per

year, generating millions and millions of charts.

Now I cannot even run a simple stress test of 6.2 without it starting to

intermittently crash after 100-200 charts are generated. Here is the error I

get:

ChartFX.ASP.Server.62 error '80020009'

Win32Exception: 80

/fxstress7.asp, line 27

******************************

Here is the stress test script -- note that it does not even load any data

into the chart! (I will include an ADO stress test below that does load a

simple set of data):

<%@ Language=VBScript %>

<% Option Explicit %>

<%

call Main()

sub Main()

dim i

response.write("<html>")

response.write("<head>")

response.write("<META http-equiv=REFRESH content=1>")

response.write("</head>")

response.write("<body>")

for i=1 to 20

call BuildChart()

response.write("<BR>")

next

response.write("</body></html>")

end sub

sub BuildChart()

dim objChart

response.write("Version 7a stress: " & Now() & "<BR>")

set objChart = Server.CreateObject("ChartFX.ASP.Server")

response.write objChart.GetHtmlTag(600,350,"Image")

set objChart = nothing

end sub

%>

**********************

Putting this script into \inetpub\wwwroot, and running 5 copies of IE with

http://localhost/fxstress7.asp, after 30 seconds or so I start getting the

intermittent error for individual charts.

******************************************************************************

Here is a slightly more complicated stress script, it uses ADO to connect to

SQL Server, and then a simple SELECT to generate the data:

<%@ Language=VBScript %>

<% Option Explicit %>

<%

call Main()

sub Main()

dim i

response.write("<html>")

response.write("<head>")

response.write("<META http-equiv=REFRESH content=1>")

response.write("</head>")

response.write("<body>")

for i=1 to 20

call BuildChart()

response.write("<BR>")

next

response.write("</body></html>")

end sub

sub BuildChart()

dim cnx

dim strSQL

dim rst

dim objChart

response.write("Version 6a stress: " & Now() & "<BR>")

Set cnx = server.createobject("ADODB.Connection")

set objChart = Server.CreateObject("ChartFX.ASP.Server")

cnx.open "Driver={SQL Server}; Server=127.0.0.1; Database=tempdb; uid=SA;

pwd=_mysapassword_;"

strSQL = "SELECT 'Joe',3 UNION ALL SELECT 'Ted',5 UNION ALL SELECT

'Susan',10"

set rst = cnx.Execute(strSQL)

' Not 3d

objChart.Chart3D = FALSE

' Assign recordset to data object.

objChart.DataSource = rst

' colors

objchart.Series(0).Color = RGB(255,0,0)

response.write objChart.GetHtmlTag(600,350,"Image")

set objChart = nothing

rst.close

set rst = nothing

cnx.close

set cnx = nothing

end sub

**************

The script above also crashes intermittently on the GetHTMLTag line.

Server info:

Windows 2003 Server, IIS 6.0.

ChartFX Developer Studio.

ChartFX.ASP.Core.dll version: 6.2.2089.25183

***************

I see from Francisco's message that there should be a later SP available:

"Yes the article is relevant but the bug was fixed. You need to download the

latest SP. As of today, the latest SP is: 6.2.2118 Francisco Padron"

But when I go to the support site:

http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

I see this:

Chart FX Internet 6.2 Service Pack

Update Service Pack Online

or

Download Installer

File Name: CfxIE62ServicePack.zip

Date: 9/30/2005

Version: 6.2.2089.25183

And this version is the same as what I have -- where is the 6.2.2118 service

pack???

Do I have something wrong in the ADO code? If so why does the simplest test

also crash with the same error? Do I need to reboot or stop/restart IIS

between stress tests? If it's not something I'm doing wrong, is there a SP

that fixes this?

Please help!

-Frank.

Link to comment
Share on other sites

Hi,

This is an update to my question of January 4th (which never received a

reply).

What should I tell my customers who are considering upgrading to ChartFX

6.2??? For years they have used 2000/5.5 reliably with at most one crash per

year, generating millions and millions of charts.

Now I cannot even run a simple stress test of 6.2 without it starting to

intermittently crash after 100-200 charts are generated. Here is the error I

get:

ChartFX.ASP.Server.62 error '80020009'

Win32Exception: 80

/fxstress7.asp, line 27

******************************

Here is the stress test script -- note that it does not even load any data

into the chart! (I will include an ADO stress test below that does load a

simple set of data):

<%@ Language=VBScript %>

<% Option Explicit %>

<%

call Main()

sub Main()

dim i

response.write("<html>")

response.write("<head>")

response.write("<META http-equiv=REFRESH content=1>")

response.write("</head>")

response.write("<body>")

for i=1 to 20

call BuildChart()

response.write("<BR>")

next

response.write("</body></html>")

end sub

sub BuildChart()

dim objChart

response.write("Version 7a stress: " & Now() & "<BR>")

set objChart = Server.CreateObject("ChartFX.ASP.Server")

response.write objChart.GetHtmlTag(600,350,"Image")

set objChart = nothing

end sub

%>

**********************

Putting this script into \inetpub\wwwroot, and running 5 copies of IE with

http://localhost/fxstress7.asp, after 30 seconds or so I start getting the

intermittent error for individual charts.

******************************************************************************

Here is a slightly more complicated stress script, it uses ADO to connect to

SQL Server, and then a simple SELECT to generate the data:

<%@ Language=VBScript %>

<% Option Explicit %>

<%

call Main()

sub Main()

dim i

response.write("<html>")

response.write("<head>")

response.write("<META http-equiv=REFRESH content=1>")

response.write("</head>")

response.write("<body>")

for i=1 to 20

call BuildChart()

response.write("<BR>")

next

response.write("</body></html>")

end sub

sub BuildChart()

dim cnx

dim strSQL

dim rst

dim objChart

response.write("Version 6a stress: " & Now() & "<BR>")

Set cnx = server.createobject("ADODB.Connection")

set objChart = Server.CreateObject("ChartFX.ASP.Server")

cnx.open "Driver={SQL Server}; Server=127.0.0.1; Database=tempdb; uid=SA;

pwd=_mysapassword_;"

strSQL = "SELECT 'Joe',3 UNION ALL SELECT 'Ted',5 UNION ALL SELECT

'Susan',10"

set rst = cnx.Execute(strSQL)

' Not 3d

objChart.Chart3D = FALSE

' Assign recordset to data object.

objChart.DataSource = rst

' colors

objchart.Series(0).Color = RGB(255,0,0)

response.write objChart.GetHtmlTag(600,350,"Image")

set objChart = nothing

rst.close

set rst = nothing

cnx.close

set cnx = nothing

end sub

**************

The script above also crashes intermittently on the GetHTMLTag line.

Server info:

Windows 2003 Server, IIS 6.0.

ChartFX Developer Studio.

ChartFX.ASP.Core.dll version: 6.2.2089.25183

***************

I see from Francisco's message that there should be a later SP available:

"Yes the article is relevant but the bug was fixed. You need to download the

latest SP. As of today, the latest SP is: 6.2.2118 Francisco Padron"

But when I go to the support site:

http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

I see this:

Chart FX Internet 6.2 Service Pack

Update Service Pack Online

or

Download Installer

File Name: CfxIE62ServicePack.zip

Date: 9/30/2005

Version: 6.2.2089.25183

And this version is the same as what I have -- where is the 6.2.2118 service

pack???

Do I have something wrong in the ADO code? If so why does the simplest test

also crash with the same error? Do I need to reboot or stop/restart IIS

between stress tests? If it's not something I'm doing wrong, is there a SP

that fixes this?

Please help!

-Frank.

Link to comment
Share on other sites

We are uploading a new service pack (2202) that fixes the Win32Exception: 80 

issue, we have been unable to duplicate the 123 issue. If you experience

this when executing specific chart settings please include any additional

details.

I apologize for the inconvenience and our delay getting back to you.

--

JC

Software FX Support

"Frank" <fdc2005@gmail.com> wrote in message

news:cMBiQMbFGHA.2580@webserver3.softwarefx.com...

> Hi,

>

> This is an update to my question of January 4th (which never received a

> reply).

>

> What should I tell my customers who are considering upgrading to ChartFX

> 6.2??? For years they have used 2000/5.5 reliably with at most one crash

> per year, generating millions and millions of charts.

>

> Now I cannot even run a simple stress test of 6.2 without it starting to

> intermittently crash after 100-200 charts are generated. Here is the error

> I get:

>

> ChartFX.ASP.Server.62 error '80020009'

> Win32Exception: 80

>

> /fxstress7.asp, line 27

>

> ******************************

>

> Here is the stress test script -- note that it does not even load any data

> into the chart! (I will include an ADO stress test below that does load a

> simple set of data):

>

> <%@ Language=VBScript %>

> <% Option Explicit %>

> <%

>

> call Main()

>

> sub Main()

> dim i

>

> response.write("<html>")

> response.write("<head>")

> response.write("<META http-equiv=REFRESH content=1>")

> response.write("</head>")

> response.write("<body>")

> for i=1 to 20

> call BuildChart()

> response.write("<BR>")

> next

> response.write("</body></html>")

> end sub

>

> sub BuildChart()

> dim objChart

>

> response.write("Version 7a stress: " & Now() & "<BR>")

> set objChart = Server.CreateObject("ChartFX.ASP.Server")

> response.write objChart.GetHtmlTag(600,350,"Image")

> set objChart = nothing

>

> end sub

>

> %>

>

> **********************

>

> Putting this script into \inetpub\wwwroot, and running 5 copies of IE with

> http://localhost/fxstress7.asp, after 30 seconds or so I start getting the

> intermittent error for individual charts.

>

> ******************************************************************************

>

> Here is a slightly more complicated stress script, it uses ADO to connect

> to SQL Server, and then a simple SELECT to generate the data:

>

> <%@ Language=VBScript %>

> <% Option Explicit %>

> <%

>

>

> call Main()

>

> sub Main()

> dim i

>

> response.write("<html>")

> response.write("<head>")

> response.write("<META http-equiv=REFRESH content=1>")

> response.write("</head>")

> response.write("<body>")

> for i=1 to 20

> call BuildChart()

> response.write("<BR>")

> next

> response.write("</body></html>")

> end sub

>

> sub BuildChart()

> dim cnx

> dim strSQL

> dim rst

> dim objChart

>

> response.write("Version 6a stress: " & Now() & "<BR>")

>

> Set cnx = server.createobject("ADODB.Connection")

> set objChart = Server.CreateObject("ChartFX.ASP.Server")

>

> cnx.open "Driver={SQL Server}; Server=127.0.0.1; Database=tempdb; uid=SA;

> pwd=_mysapassword_;"

>

> strSQL = "SELECT 'Joe',3 UNION ALL SELECT 'Ted',5 UNION ALL SELECT

> 'Susan',10"

> set rst = cnx.Execute(strSQL)

> ' Not 3d

> objChart.Chart3D = FALSE

> ' Assign recordset to data object.

> objChart.DataSource = rst

> ' colors

> objchart.Series(0).Color = RGB(255,0,0)

>

> response.write objChart.GetHtmlTag(600,350,"Image")

> set objChart = nothing

> rst.close

> set rst = nothing

> cnx.close

> set cnx = nothing

>

> end sub

>

> **************

>

> The script above also crashes intermittently on the GetHTMLTag line.

>

> Server info:

>

> Windows 2003 Server, IIS 6.0.

>

> ChartFX Developer Studio.

>

> ChartFX.ASP.Core.dll version: 6.2.2089.25183

>

> ***************

>

> I see from Francisco's message that there should be a later SP available:

>

> "Yes the article is relevant but the bug was fixed. You need to download

> the

> latest SP. As of today, the latest SP is: 6.2.2118 Francisco Padron"

>

> But when I go to the support site:

> http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

>

> I see this:

>

> Chart FX Internet 6.2 Service Pack

> Update Service Pack Online

> or

> Download Installer

>

> File Name: CfxIE62ServicePack.zip

> Date: 9/30/2005

>

> Version: 6.2.2089.25183

>

> And this version is the same as what I have -- where is the 6.2.2118

> service pack???

>

> Do I have something wrong in the ADO code? If so why does the simplest

> test also crash with the same error? Do I need to reboot or stop/restart

> IIS between stress tests? If it's not something I'm doing wrong, is there

> a SP that fixes this?

>

> Please help!

>

> -Frank.

>

>

>

>

Link to comment
Share on other sites

We are uploading a new service pack (2202) that fixes the Win32Exception: 80 

issue, we have been unable to duplicate the 123 issue. If you experience

this when executing specific chart settings please include any additional

details.

I apologize for the inconvenience and our delay getting back to you.

--

JC

Software FX Support

"Frank" <fdc2005@gmail.com> wrote in message

news:cMBiQMbFGHA.2580@webserver3.softwarefx.com...

> Hi,

>

> This is an update to my question of January 4th (which never received a

> reply).

>

> What should I tell my customers who are considering upgrading to ChartFX

> 6.2??? For years they have used 2000/5.5 reliably with at most one crash

> per year, generating millions and millions of charts.

>

> Now I cannot even run a simple stress test of 6.2 without it starting to

> intermittently crash after 100-200 charts are generated. Here is the error

> I get:

>

> ChartFX.ASP.Server.62 error '80020009'

> Win32Exception: 80

>

> /fxstress7.asp, line 27

>

> ******************************

>

> Here is the stress test script -- note that it does not even load any data

> into the chart! (I will include an ADO stress test below that does load a

> simple set of data):

>

> <%@ Language=VBScript %>

> <% Option Explicit %>

> <%

>

> call Main()

>

> sub Main()

> dim i

>

> response.write("<html>")

> response.write("<head>")

> response.write("<META http-equiv=REFRESH content=1>")

> response.write("</head>")

> response.write("<body>")

> for i=1 to 20

> call BuildChart()

> response.write("<BR>")

> next

> response.write("</body></html>")

> end sub

>

> sub BuildChart()

> dim objChart

>

> response.write("Version 7a stress: " & Now() & "<BR>")

> set objChart = Server.CreateObject("ChartFX.ASP.Server")

> response.write objChart.GetHtmlTag(600,350,"Image")

> set objChart = nothing

>

> end sub

>

> %>

>

> **********************

>

> Putting this script into \inetpub\wwwroot, and running 5 copies of IE with

> http://localhost/fxstress7.asp, after 30 seconds or so I start getting the

> intermittent error for individual charts.

>

> ******************************************************************************

>

> Here is a slightly more complicated stress script, it uses ADO to connect

> to SQL Server, and then a simple SELECT to generate the data:

>

> <%@ Language=VBScript %>

> <% Option Explicit %>

> <%

>

>

> call Main()

>

> sub Main()

> dim i

>

> response.write("<html>")

> response.write("<head>")

> response.write("<META http-equiv=REFRESH content=1>")

> response.write("</head>")

> response.write("<body>")

> for i=1 to 20

> call BuildChart()

> response.write("<BR>")

> next

> response.write("</body></html>")

> end sub

>

> sub BuildChart()

> dim cnx

> dim strSQL

> dim rst

> dim objChart

>

> response.write("Version 6a stress: " & Now() & "<BR>")

>

> Set cnx = server.createobject("ADODB.Connection")

> set objChart = Server.CreateObject("ChartFX.ASP.Server")

>

> cnx.open "Driver={SQL Server}; Server=127.0.0.1; Database=tempdb; uid=SA;

> pwd=_mysapassword_;"

>

> strSQL = "SELECT 'Joe',3 UNION ALL SELECT 'Ted',5 UNION ALL SELECT

> 'Susan',10"

> set rst = cnx.Execute(strSQL)

> ' Not 3d

> objChart.Chart3D = FALSE

> ' Assign recordset to data object.

> objChart.DataSource = rst

> ' colors

> objchart.Series(0).Color = RGB(255,0,0)

>

> response.write objChart.GetHtmlTag(600,350,"Image")

> set objChart = nothing

> rst.close

> set rst = nothing

> cnx.close

> set cnx = nothing

>

> end sub

>

> **************

>

> The script above also crashes intermittently on the GetHTMLTag line.

>

> Server info:

>

> Windows 2003 Server, IIS 6.0.

>

> ChartFX Developer Studio.

>

> ChartFX.ASP.Core.dll version: 6.2.2089.25183

>

> ***************

>

> I see from Francisco's message that there should be a later SP available:

>

> "Yes the article is relevant but the bug was fixed. You need to download

> the

> latest SP. As of today, the latest SP is: 6.2.2118 Francisco Padron"

>

> But when I go to the support site:

> http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

>

> I see this:

>

> Chart FX Internet 6.2 Service Pack

> Update Service Pack Online

> or

> Download Installer

>

> File Name: CfxIE62ServicePack.zip

> Date: 9/30/2005

>

> Version: 6.2.2089.25183

>

> And this version is the same as what I have -- where is the 6.2.2118

> service pack???

>

> Do I have something wrong in the ADO code? If so why does the simplest

> test also crash with the same error? Do I need to reboot or stop/restart

> IIS between stress tests? If it's not something I'm doing wrong, is there

> a SP that fixes this?

>

> Please help!

>

> -Frank.

>

>

>

>

Link to comment
Share on other sites

Hi JC,

Thanks for the info, good to know that I'm not going crazy.

Will the service pack be here when it is uploaded?

http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

Right now (Wednesday evening), it still looks like the 6.2.2089.25183 build

from September 30th.

Please let me know if I am looking in the wrong place!

Thanks,

-Frank.

"Software FX Support" <none@noreply.com> wrote in message

news:fdTFnBwFGHA.3756@webserver3.softwarefx.com...

> We are uploading a new service pack (2202) that fixes the Win32Exception:

> 80 issue, we have been unable to duplicate the 123 issue. If you

> experience this when executing specific chart settings please include any

> additional details.

>

> I apologize for the inconvenience and our delay getting back to you.

>

> --

> JC

> Software FX Support

> "Frank" <fdc2005@gmail.com> wrote in message

> news:cMBiQMbFGHA.2580@webserver3.softwarefx.com...

>> Hi,

>>

>> This is an update to my question of January 4th (which never received a

>> reply).

>>

>> What should I tell my customers who are considering upgrading to ChartFX

>> 6.2??? For years they have used 2000/5.5 reliably with at most one crash

>> per year, generating millions and millions of charts.

>>

>> Now I cannot even run a simple stress test of 6.2 without it starting to

>> intermittently crash after 100-200 charts are generated. Here is the

>> error I get:

>>

>> ChartFX.ASP.Server.62 error '80020009'

>> Win32Exception: 80

>>

>> /fxstress7.asp, line 27

>>

>> ******************************

>>

>> Here is the stress test script -- note that it does not even load any

>> data into the chart! (I will include an ADO stress test below that does

>> load a simple set of data):

>>

>> <%@ Language=VBScript %>

>> <% Option Explicit %>

>> <%

>>

>> call Main()

>>

>> sub Main()

>> dim i

>>

>> response.write("<html>")

>> response.write("<head>")

>> response.write("<META http-equiv=REFRESH content=1>")

>> response.write("</head>")

>> response.write("<body>")

>> for i=1 to 20

>> call BuildChart()

>> response.write("<BR>")

>> next

>> response.write("</body></html>")

>> end sub

>>

>> sub BuildChart()

>> dim objChart

>>

>> response.write("Version 7a stress: " & Now() & "<BR>")

>> set objChart = Server.CreateObject("ChartFX.ASP.Server")

>> response.write objChart.GetHtmlTag(600,350,"Image")

>> set objChart = nothing

>>

>> end sub

>>

>> %>

>>

>> **********************

>>

>> Putting this script into \inetpub\wwwroot, and running 5 copies of IE

>> with http://localhost/fxstress7.asp, after 30 seconds or so I start

>> getting the intermittent error for individual charts.

>>

>> ******************************************************************************

>>

>> Here is a slightly more complicated stress script, it uses ADO to connect

>> to SQL Server, and then a simple SELECT to generate the data:

>>

>> <%@ Language=VBScript %>

>> <% Option Explicit %>

>> <%

>>

>>

>> call Main()

>>

>> sub Main()

>> dim i

>>

>> response.write("<html>")

>> response.write("<head>")

>> response.write("<META http-equiv=REFRESH content=1>")

>> response.write("</head>")

>> response.write("<body>")

>> for i=1 to 20

>> call BuildChart()

>> response.write("<BR>")

>> next

>> response.write("</body></html>")

>> end sub

>>

>> sub BuildChart()

>> dim cnx

>> dim strSQL

>> dim rst

>> dim objChart

>>

>> response.write("Version 6a stress: " & Now() & "<BR>")

>>

>> Set cnx = server.createobject("ADODB.Connection")

>> set objChart = Server.CreateObject("ChartFX.ASP.Server")

>>

>> cnx.open "Driver={SQL Server}; Server=127.0.0.1; Database=tempdb; uid=SA;

>> pwd=_mysapassword_;"

>>

>> strSQL = "SELECT 'Joe',3 UNION ALL SELECT 'Ted',5 UNION ALL SELECT

>> 'Susan',10"

>> set rst = cnx.Execute(strSQL)

>> ' Not 3d

>> objChart.Chart3D = FALSE

>> ' Assign recordset to data object.

>> objChart.DataSource = rst

>> ' colors

>> objchart.Series(0).Color = RGB(255,0,0)

>>

>> response.write objChart.GetHtmlTag(600,350,"Image")

>> set objChart = nothing

>> rst.close

>> set rst = nothing

>> cnx.close

>> set cnx = nothing

>>

>> end sub

>>

>> **************

>>

>> The script above also crashes intermittently on the GetHTMLTag line.

>>

>> Server info:

>>

>> Windows 2003 Server, IIS 6.0.

>>

>> ChartFX Developer Studio.

>>

>> ChartFX.ASP.Core.dll version: 6.2.2089.25183

>>

>> ***************

>>

>> I see from Francisco's message that there should be a later SP available:

>>

>> "Yes the article is relevant but the bug was fixed. You need to download

>> the

>> latest SP. As of today, the latest SP is: 6.2.2118 Francisco Padron"

>>

>> But when I go to the support site:

>> http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

>>

>> I see this:

>>

>> Chart FX Internet 6.2 Service Pack

>> Update Service Pack Online

>> or

>> Download Installer

>>

>> File Name: CfxIE62ServicePack.zip

>> Date: 9/30/2005

>>

>> Version: 6.2.2089.25183

>>

>> And this version is the same as what I have -- where is the 6.2.2118

>> service pack???

>>

>> Do I have something wrong in the ADO code? If so why does the simplest

>> test also crash with the same error? Do I need to reboot or stop/restart

>> IIS between stress tests? If it's not something I'm doing wrong, is there

>> a SP that fixes this?

>>

>> Please help!

>>

>> -Frank.

>>

>>

>>

>>

>

>

Link to comment
Share on other sites

Hi JC,

Thanks for the info, good to know that I'm not going crazy.

Will the service pack be here when it is uploaded?

http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

Right now (Wednesday evening), it still looks like the 6.2.2089.25183 build

from September 30th.

Please let me know if I am looking in the wrong place!

Thanks,

-Frank.

"Software FX Support" <none@noreply.com> wrote in message

news:fdTFnBwFGHA.3756@webserver3.softwarefx.com...

> We are uploading a new service pack (2202) that fixes the Win32Exception:

> 80 issue, we have been unable to duplicate the 123 issue. If you

> experience this when executing specific chart settings please include any

> additional details.

>

> I apologize for the inconvenience and our delay getting back to you.

>

> --

> JC

> Software FX Support

> "Frank" <fdc2005@gmail.com> wrote in message

> news:cMBiQMbFGHA.2580@webserver3.softwarefx.com...

>> Hi,

>>

>> This is an update to my question of January 4th (which never received a

>> reply).

>>

>> What should I tell my customers who are considering upgrading to ChartFX

>> 6.2??? For years they have used 2000/5.5 reliably with at most one crash

>> per year, generating millions and millions of charts.

>>

>> Now I cannot even run a simple stress test of 6.2 without it starting to

>> intermittently crash after 100-200 charts are generated. Here is the

>> error I get:

>>

>> ChartFX.ASP.Server.62 error '80020009'

>> Win32Exception: 80

>>

>> /fxstress7.asp, line 27

>>

>> ******************************

>>

>> Here is the stress test script -- note that it does not even load any

>> data into the chart! (I will include an ADO stress test below that does

>> load a simple set of data):

>>

>> <%@ Language=VBScript %>

>> <% Option Explicit %>

>> <%

>>

>> call Main()

>>

>> sub Main()

>> dim i

>>

>> response.write("<html>")

>> response.write("<head>")

>> response.write("<META http-equiv=REFRESH content=1>")

>> response.write("</head>")

>> response.write("<body>")

>> for i=1 to 20

>> call BuildChart()

>> response.write("<BR>")

>> next

>> response.write("</body></html>")

>> end sub

>>

>> sub BuildChart()

>> dim objChart

>>

>> response.write("Version 7a stress: " & Now() & "<BR>")

>> set objChart = Server.CreateObject("ChartFX.ASP.Server")

>> response.write objChart.GetHtmlTag(600,350,"Image")

>> set objChart = nothing

>>

>> end sub

>>

>> %>

>>

>> **********************

>>

>> Putting this script into \inetpub\wwwroot, and running 5 copies of IE

>> with http://localhost/fxstress7.asp, after 30 seconds or so I start

>> getting the intermittent error for individual charts.

>>

>> ******************************************************************************

>>

>> Here is a slightly more complicated stress script, it uses ADO to connect

>> to SQL Server, and then a simple SELECT to generate the data:

>>

>> <%@ Language=VBScript %>

>> <% Option Explicit %>

>> <%

>>

>>

>> call Main()

>>

>> sub Main()

>> dim i

>>

>> response.write("<html>")

>> response.write("<head>")

>> response.write("<META http-equiv=REFRESH content=1>")

>> response.write("</head>")

>> response.write("<body>")

>> for i=1 to 20

>> call BuildChart()

>> response.write("<BR>")

>> next

>> response.write("</body></html>")

>> end sub

>>

>> sub BuildChart()

>> dim cnx

>> dim strSQL

>> dim rst

>> dim objChart

>>

>> response.write("Version 6a stress: " & Now() & "<BR>")

>>

>> Set cnx = server.createobject("ADODB.Connection")

>> set objChart = Server.CreateObject("ChartFX.ASP.Server")

>>

>> cnx.open "Driver={SQL Server}; Server=127.0.0.1; Database=tempdb; uid=SA;

>> pwd=_mysapassword_;"

>>

>> strSQL = "SELECT 'Joe',3 UNION ALL SELECT 'Ted',5 UNION ALL SELECT

>> 'Susan',10"

>> set rst = cnx.Execute(strSQL)

>> ' Not 3d

>> objChart.Chart3D = FALSE

>> ' Assign recordset to data object.

>> objChart.DataSource = rst

>> ' colors

>> objchart.Series(0).Color = RGB(255,0,0)

>>

>> response.write objChart.GetHtmlTag(600,350,"Image")

>> set objChart = nothing

>> rst.close

>> set rst = nothing

>> cnx.close

>> set cnx = nothing

>>

>> end sub

>>

>> **************

>>

>> The script above also crashes intermittently on the GetHTMLTag line.

>>

>> Server info:

>>

>> Windows 2003 Server, IIS 6.0.

>>

>> ChartFX Developer Studio.

>>

>> ChartFX.ASP.Core.dll version: 6.2.2089.25183

>>

>> ***************

>>

>> I see from Francisco's message that there should be a later SP available:

>>

>> "Yes the article is relevant but the bug was fixed. You need to download

>> the

>> latest SP. As of today, the latest SP is: 6.2.2118 Francisco Padron"

>>

>> But when I go to the support site:

>> http://support.softwarefx.com/ProductBase.aspx?Product=CfxInt62

>>

>> I see this:

>>

>> Chart FX Internet 6.2 Service Pack

>> Update Service Pack Online

>> or

>> Download Installer

>>

>> File Name: CfxIE62ServicePack.zip

>> Date: 9/30/2005

>>

>> Version: 6.2.2089.25183

>>

>> And this version is the same as what I have -- where is the 6.2.2118

>> service pack???

>>

>> Do I have something wrong in the ADO code? If so why does the simplest

>> test also crash with the same error? Do I need to reboot or stop/restart

>> IIS between stress tests? If it's not something I'm doing wrong, is there

>> a SP that fixes this?

>>

>> Please help!

>>

>> -Frank.

>>

>>

>>

>>

>

>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...