| | "Agustín | | | Caballero" | | | | | | Sent by: | | | owner-informix-li| | | [email]st@iiug.org[/email] | | | | | | | | | 08/18/2003 05:30 | | | PM | | | Please respond to| | | "Agustín | | | Caballero" | |---------+---------------------------->[quote] >------------------------------------------------------------------------------------------------------------------------------|[/quote] | | | To: [email]informix-list@iiug.org[/email] | | cc: | | Subject: Catastrophic failure |[quote] >------------------------------------------------------------------------------------------------------------------------------|[/quote] 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 [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Sathyanesh Krishnan [ip] => satyan@us.ibm.c [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 4 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> Catastrophic failure - Informix

Catastrophic failure - Informix

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 ...

  1. #1

    Default Catastrophic failure

    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())





    miqbal Guest

  2. #2

    Default 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


    Agustín Caballero Guest

  3. #3

    Default Re: Catastrophic failure

    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" <agustincbono.com> wrote in message
    news:fsc0b.38756$FN3.2676469news.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
    >
    >

    Jack A Guest

  4. #4

    Default Re: Catastrophic failure






    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" |
    | | <agustincbono.co|
    | | m> |
    | | Sent by: |
    | | owner-informix-li|
    | | [email]stiiug.org[/email] |
    | | |
    | | |
    | | 08/18/2003 05:30 |
    | | PM |
    | | Please respond to|
    | | "Agustín |
    | | Caballero" |
    |---------+---------------------------->
    >------------------------------------------------------------------------------------------------------------------------------|
    | |
    | To: [email]informix-listiiug.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
    Sathyanesh Krishnan Guest

  5. #5

    Default Catastrophic Failure

    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?

    Mattfe Guest

  6. #6

    Default Re: Catastrophic Failure

    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?
    robisen@gmail.com Guest

Similar Threads

  1. Debugging - Catastrophic Failure :( !!!
    By Alek in forum ASP.NET General
    Replies: 2
    Last Post: June 30th, 06:42 AM
  2. 1.8.1 failure
    By Daniel Berger in forum Ruby
    Replies: 7
    Last Post: November 1st, 03:25 PM
  3. Replies: 0
    Last Post: October 2nd, 07:31 PM
  4. Catastrophic Failure.
    By zorro69 webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 3
    Last Post: August 7th, 01:54 PM
  5. Replies: 1
    Last Post: July 24th, 05:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •