Catastrophic failure

[miqbal]

IM getting this error when i try to run Teecharts ActiveX control in asp.net
environment

can some one help me in it

Regards Moid Iqbal

Catastrophic failure
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Catastrophic
failure

Source Error:

Line 59: dr = com.ExecuteReader
Line 60: Dim tchart As New TeeChart.TChart()
Line 61: tchart.Series(0).DataSource = dr
Line 62: tchart.Series(0).YValues.ValueSource = "tons"
Line 63: tchart.Series(0).LabelsSource = "shift date"

Source File: D:\Inetpub\wwwroot\Accuweigh\subreports\teechartpr eview.aspx.vb
Line: 61

Stack Trace:

[COMException (0x8000ffff): Catastrophic failure]
TeeChart.TChartClass.Series(Int32 SeriesIndex) +0
Accuweigh.teechartpreview.assd() in
D:\Inetpub\wwwroot\Accuweigh\subreports\teechartpr eview.aspx.vb:61
Accuweigh.teechartpreview.Page_Load(Object sender, EventArgs e) in
D:\Inetpub\wwwroot\Accuweigh\subreports\teechartpr eview.aspx.vb:46
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724





----------------------------------------------------------------------------
----

Version Information: Microsoft .NET Framework Version:1.0.3705.288; ASP.NET
Version:1.0.3705.288


Dim con As New OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver}; SERVER=
localhost; DATABASE = accuweigh ; UID = root; PASSWORD=;")
Dim dr As OdbcDataReader
con.open()
Dim com As New OdbcCommand("select date_format(chronology.shiftdate,'%b
%d,%x') as 'shift date',round(sum(draglinecycles.tons),2) as 'tons' from
chronology left join draglinecycles on draglinecycles.excavator =
chronology.excavator and draglinecycles.recindx = chronology.recindx group
by 'excavator' order by 'excavator'", con)
dr = com.ExecuteReader
Dim tchart As New TeeChart.TChart()
tchart.Series(0).DataSource = dr
tchart.Series(0).YValues.ValueSource = "tons"
tchart.Series(0).LabelsSource = "shift date"
Response.BinaryWrite(tchart.Export.asPNG.SaveToStr eam())



Ive Also used this code but the error was the same as given above

Dim con As New ADODB.Connection()
Dim rs As New ADODB.Recordset()
con.ConnectionString = "DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=accuweigh;UID=ro otPASSWORD=;"
con.Open()
rs.Open("select date_format(chronology.shiftdate,'%b %d,%x') as 'shift
date',round(sum(draglinecycles.tons),2) as 'tons' from chronology left join
draglinecycles on draglinecycles.excavator = chronology.excavator and
draglinecycles.recindx = chronology.recindx group by 'excavator' order by
'excavator'", con)
Dim tchart As New TeeChart.TChart()
tchart.Series(0).DataSource = rs
tchart.Series(0).YValues.ValueSource = "tons"
'tchart.Series(0).LabelsSource = "shift date"
'Response.BinaryWrite(tchart.Export.asPNG.SaveToSt ream())

[Agustín Caballero]

I have an application that periodically (every 10 minutes) connects to an
informix server and uploads/downloads some data.

When I connect using ADO and ODBC the machine uses an increasing amount of
memory, until it reaches even 70 Mb. I already have checked that I'm closing
all recordsets, destroy objects, close connection, etc.

When I use OLEDB, it works fine until, after a varying number of
connection/disconnection, I get a "Catastrophic Failure" and from that
moment each try to connect results in the same error. When I close the
program and start it again it connects again until the problem repeats.

Any help? Thanks in advance

[Jack A]

I have seen a similiar scenario but with a different database. The JDBC
driver we used had a bad memory leak. With each connection some memory would
be leaked out. Consequently, this add up to a big amount. It looks like the
same thing is happenning with your box.

What OS is Informix running on ? Can you check memory using some tool on it
?

"Agustín Caballero" <agustincb@ono.com> wrote in message
news:fsc0b.38756$FN3.2676469@news.ono.com...

> I have an application that periodically (every 10 minutes) connects to an
> informix server and uploads/downloads some data.
>
> When I connect using ADO and ODBC the machine uses an increasing amount of
> memory, until it reaches even 70 Mb. I already have checked that I'm

closing

> all recordsets, destroy objects, close connection, etc.
>
> When I use OLEDB, it works fine until, after a varying number of
> connection/disconnection, I get a "Catastrophic Failure" and from that
> moment each try to connect results in the same error. When I close the
> program and start it again it connects again until the problem repeats.
>
> Any help? Thanks in advance
>
>

[Sathyanesh Krishnan]

Hi Agustin,

Probably I may be able to help you if you can give me some more information
regarding the problem.
What CSDK version you are using.
What kind of ADO application this is, I mean, is it a plain VB Ado
application or
a three-tier application executing with in MTS host process ?.

Regards,
Satyan.



|---------+---------------------------->
| | "Agustín |
| | Caballero" |
| | <agustincb@ono.co|
| | m> |
| | Sent by: |
| | owner-informix-li|
| | [email]st@iiug.org[/email] |
| | |
| | |
| | 08/18/2003 05:30 |
| | PM |
| | Please respond to|
| | "Agustín |
| | Caballero" |
|---------+---------------------------->

>------------------------------------------------------------------------------------------------------------------------------|

| |
| To: [email]informix-list@iiug.org[/email] |
| cc: |
| Subject: Catastrophic failure |

>------------------------------------------------------------------------------------------------------------------------------|

I have an application that periodically (every 10 minutes) connects to an
informix server and uploads/downloads some data.

When I connect using ADO and ODBC the machine uses an increasing amount of
memory, until it reaches even 70 Mb. I already have checked that I'm
closing
all recordsets, destroy objects, close connection, etc.

When I use OLEDB, it works fine until, after a varying number of
connection/disconnection, I get a "Catastrophic Failure" and from that
moment each try to connect results in the same error. When I close the
program and start it again it connects again until the problem repeats.

Any help? Thanks in advance




sending to informix-list

[Mattfe]

Hello,

Every now and then we are getting a 'error executing database query.
Catastrophic failure' on various sites on the server. This server runs cfmx
7.0.2 with jrockit as the jvm, 2 gigs of ram, heap size at 1024. A cf restart
fixes the issue for a period of time. Has anyone ever run into anything
similar?

[robisen@gmail.com]

Have you turned on ODBC logging? Can you tell us what page and what
lines of code are showing the error?

If you do not know how to correlate the error to a page and lines of
code try

1. adding a cflog entry in your application.cfm (if you use it and if
not add the file) where you log the time, date, and page being run
2. add cfcatch try that dumps a stack trace for DB errors.


Mattfe wrote:

> Hello,
>
> Every now and then we are getting a 'error executing database query.
> Catastrophic failure' on various sites on the server. This server runs cfmx
> 7.0.2 with jrockit as the jvm, 2 gigs of ram, heap size at 1024. A cf restart
> fixes the issue for a period of time. Has anyone ever run into anything
> similar?