Search the web
Sign In
New User? Sign Up
toaddb2beta
  • Members Only
  • Post
  • Files
  • Photos
  • Links
  • Database
  • Polls
  • Members
  • Calendar
  • Promote
  • Groups Labs (Beta)
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

   Messages Help
Message #
Search:
Advanced
Messages 2998 - 3027 of 3027   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#3027 From: marc_rink@...
Date: Thu Nov 26, 2009 8:40 am
Subject: Locks held on tables... 		docjones999
Offline Offline
Send Email Send Email
 

Heyas,

my database administrator complains that since i am using TOAD Beta the number of locks held on the database increase.
Here is the output he gave me:

----------------------------------------------------
(*]09:12:33,refresh=3!secs(0,084)                                       Sessions                                          AIX,part=[1/1],DB2ADM:LOGISTIK
[d=Y,a=N,e=N,p=ALL]                                                                                                                             [qp=off]

C0A8648A.M607.091126070016 (10.2.2.140 15652], UOW Waiting in the application

           ConnDate..:       2009/11/26    ConnTime..:         08:01:00    UOW Start.:         09:10:48    Appl name.:         Toad.exe
           DB2 user..:         QUENTIA     OS user...:            MRINK    Agent id..:             1245    Coord DBP.:                0
           Coord pid.:           520628    Client pid:             3052    Cost est..:          1064718    Card est..:           261422
           CurPoolSz.:             960K    Hash joins:                0    Hash loops:                0    HJoin ovf.:                0
           SQL Stmts.:              111    Sorts.....:               26    Sort time.:            0.000    Sorts ovf.:                0
           Rows fetch:            1.528    Rows read.:          303.240    Rows sel..:            3.114    Select/Rd%:               1%
           Rows wrtn.:          279.272    Rows instd:                0    Rows updtd:                7    Rows deltd:                0
           Locks held:                5    MaxCPU-DBP:            0.000

  Sub          Cpu  Cpu  Row         Rows         Rows       TqRows       TqRows         Tq          Busy   Exec # of         SubSection    Waiting
  Sec    (Sys+Usr) Skew Skew         Read      Written         Read      Written     Spills   Memory  DBP   Time  DBP Ag.         Status     TQueue
  --- ------------ ---- ---- ------------ ------------ ------------ ------------ ---------- -------- ---- ------ ---- --- -------------- ----------
      1245(i) Toad.exe             UOW Waiting in the application      Internal Plan                            S     Plan       Granted           0
      1245(i) Toad.exe             UOW Waiting in the application      Internal Variation                       S     Variation  Granted           0
      1245(i) Toad.exe             UOW Waiting in the application      CADIS.SENDUNG                            IN    Table      Granted           0
----------------------------

Here is a screenshot of what i was doing at that time:


I have configured the Isolation level in the advanced connection configuration to UR (uncommitted read)



and autocommit is on. Is there a possibility to find out why those locks are being held?

I am using the TOAD B46 CLI, as far as i know. Is there a possibility to switch the CLI to TOAD C45 to test this issue?

I am not that technically skilled DBA unfortunately, so please be gentle if i am mixing stuff that one shouldn't mix.

regards
Marc

IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

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

"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.

Reply | Forward | Messages in this Topic (1)
#3026 From: Henrik Johnson <Henrik.Johnson@...>
Date: Wed Nov 25, 2009 9:01 pm
Subject: RE: Toad hangs 		hpj_globecom_se
Online Now Online Now
Send Email Send Email
 

What are you doing at the time when this happens?

 

/Mauritz

From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On Behalf Of el28787
Sent: Wednesday, November 25, 2009 1:12 AM
To: toaddb2beta@yahoogroups.com
Subject: [toaddb2beta] Toad hangs

 

 

Hi,

We observe that Toad hangs now and then for anything upto 60 seconds before starting to respond again. It seems to happen when the editor window is open. No error messages are thrown up and everything is ok when Toad starts to respond again. We noticed something similar in the first GA of 4.5 but the problem seemed to be resolved in a later drop.
Will try to get some more info next time the problem occurs.

Regards,
John.


Reply | Forward | Messages in this Topic (3)
#3025 From: "kenryan20072000" <Kenneth.Ryan@...>
Date: Wed Nov 25, 2009 2:29 pm
Subject: Re: Toad hangs 		kenryan20072000
Offline Offline
Send Email Send Email
  
John,

If you turn on Tools->Execution Trace->To Output, it may help you/us identify
the SQL running when Toad appears to hang in the Editor.  Thanks

Ken Ryan
Toad for DB2 Development
Quest Software

--- In toaddb2beta@yahoogroups.com, "el28787" <john.enevoldson@...> wrote:
>
> Hi,
>
> We observe that Toad hangs now and then for anything upto 60 seconds before
starting to respond again. It seems to happen when the editor window is open. No
error messages are thrown up and everything is ok when Toad starts to respond
again. We noticed something similar in the first GA of 4.5 but the problem
seemed to be resolved in a later drop.
> Will try to get some more info next time the problem occurs.
>
> Regards,
> John.
>

Reply | Forward | Messages in this Topic (3)
#3024 From: "el28787" <john.enevoldson@...>
Date: Wed Nov 25, 2009 9:11 am
Subject: Toad hangs 		el28787
Offline Offline
Send Email Send Email
  
Hi,

We observe that Toad hangs now and then for anything upto 60 seconds before
starting to respond again. It seems to happen when the editor window is open. No
error messages are thrown up and everything is ok when Toad starts to respond
again. We noticed something similar in the first GA of 4.5 but the problem
seemed to be resolved in a later drop.
Will try to get some more info next time the problem occurs.

Regards,
John.

Reply | Forward | Messages in this Topic (3)
#3023 From: "kenryan20072000" <Kenneth.Ryan@...>
Date: Tue Nov 24, 2009 3:27 pm
Subject: Antwort: Re: Importwizard 		kenryan20072000
Offline Offline
Send Email Send Email
  
Marc,

I am able to recreate this issue.  I have entered cr68999 to track this issue. 
Thank you for reporting this.

Ken Ryan
Toad for DB2 Development
Quest Software

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Hi Ken,
>
> All rows have been imported. It seems that just the counter is wrong.
>
> regards
> Marc
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet:    http://www.ids-logistik.de
> E-Mail:      marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ------------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>
>
>
>
> Von:
> "kenryan20072000" <Kenneth.Ryan@...>
> An:
> toaddb2beta@yahoogroups.com
> Datum:
> 24.11.2009 15:52
> Betreff:
> [toaddb2beta] Re: Importwizard
> Gesendet von:
> toaddb2beta@yahoogroups.com
>
>
>
>
> Marc,
>
> How many rows actually get imported into the table? I'm not sure if the
> "Imported Row" count is wrong or if Import is rejecting most of the rows.
>
> If Import is rejecting all those rows, you might try using the Right
> Click->Utilities->Import on a Table in the Object Browser. This may help
> you see any warning messages from DB2 which might explain the rejected
> rows.
>
> Ken Ryan
> Toad for DB2 Development
> Quest Software
>
> --- In toaddb2beta@yahoogroups.com, marc_rink@ wrote:
> >
> > Heyas,
> >
> > After importing roughtly 80k rows, the "Read Rows" and "Imported Rows"
> > Information in the wizard result window differs:
> >
> >
> > Find attached the DDL, the import script and the import file.
> >
> > HTH :)
> >
> > Marc
> >
> > SET SCHEMA = 'STAT';
> >
> > CREATE TABLE "STAT"."CADIS_BELOG_VDID" (
> > "SDGNR" VARCHAR(35) NOT NULL,
> > "SDGDATUM" DATE NOT NULL,
> > "C_ADID" VARCHAR(10) NOT NULL,
> > "C_VDID" VARCHAR(10) NOT NULL,
> > "C_EDID" VARCHAR(10),
> > "C_VLDKZ" INTEGER,
> > "C_IMPORT" VARCHAR(1),
> > "Z_EDID" VARCHAR(10)
> > )
> > IN "USERSPACE1";
> >
> > ALTER TABLE "STAT"."CADIS_BELOG_VDID"
> > DATA CAPTURE NONE
> > LOCKSIZE ROW
> > APPEND OFF
> > NOT VOLATILE;
> >
> >
> >
> >
> >
> > IDS Logistik GmbH
> > Marc Rink
> > - Software Development Manager -
> > Saaläckerstrasse 8
> > 63801 Kleinostheim
> >
> > Tel: +49(6027)40903-13
> > Fax: +49(6027)40903-9013
> > MOB: +49(170)9672528
> >
> > Internet: http://www.ids-logistik.de
> > E-Mail: marc_rink@
> >
> > Sitz der Gesellschaft: Kleinostheim
> > Amtsgericht Aschaffenburg - HRB 10253
> > Geschäftsführer: Dr. Michael Bargl
> > Vorsitzender des Beirates: Mathias Krage
> >
> > ----------------------------------------------------------
> > "Computer games don't affect kids. I mean if Pac-Man affected us as
> kids,
> > we'd all be running around in darkened rooms, munching magic pills and
> > listening to repetitive electronic music."
> > --Kristian Wilson, Nintendo 1989.
> >
>

Reply | Forward | Messages in this Topic (5)
#3022 From: "kenryan20072000" <Kenneth.Ryan@...>
Date: Tue Nov 24, 2009 3:27 pm
Subject: Antwort: Re: Importwizard 		kenryan20072000
Offline Offline
Send Email Send Email
  
Marc,

I am able to recreate this issue.  I have entered cr68999 to track this issue. 
Thank you for reporting this.

Ken Ryan
Toad for DB2 Development
Quest Software

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Hi Ken,
>
> All rows have been imported. It seems that just the counter is wrong.
>
> regards
> Marc
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet:    http://www.ids-logistik.de
> E-Mail:      marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ------------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>
>
>
>
> Von:
> "kenryan20072000" <Kenneth.Ryan@...>
> An:
> toaddb2beta@yahoogroups.com
> Datum:
> 24.11.2009 15:52
> Betreff:
> [toaddb2beta] Re: Importwizard
> Gesendet von:
> toaddb2beta@yahoogroups.com
>
>
>
>
> Marc,
>
> How many rows actually get imported into the table? I'm not sure if the
> "Imported Row" count is wrong or if Import is rejecting most of the rows.
>
> If Import is rejecting all those rows, you might try using the Right
> Click->Utilities->Import on a Table in the Object Browser. This may help
> you see any warning messages from DB2 which might explain the rejected
> rows.
>
> Ken Ryan
> Toad for DB2 Development
> Quest Software
>
> --- In toaddb2beta@yahoogroups.com, marc_rink@ wrote:
> >
> > Heyas,
> >
> > After importing roughtly 80k rows, the "Read Rows" and "Imported Rows"
> > Information in the wizard result window differs:
> >
> >
> > Find attached the DDL, the import script and the import file.
> >
> > HTH :)
> >
> > Marc
> >
> > SET SCHEMA = 'STAT';
> >
> > CREATE TABLE "STAT"."CADIS_BELOG_VDID" (
> > "SDGNR" VARCHAR(35) NOT NULL,
> > "SDGDATUM" DATE NOT NULL,
> > "C_ADID" VARCHAR(10) NOT NULL,
> > "C_VDID" VARCHAR(10) NOT NULL,
> > "C_EDID" VARCHAR(10),
> > "C_VLDKZ" INTEGER,
> > "C_IMPORT" VARCHAR(1),
> > "Z_EDID" VARCHAR(10)
> > )
> > IN "USERSPACE1";
> >
> > ALTER TABLE "STAT"."CADIS_BELOG_VDID"
> > DATA CAPTURE NONE
> > LOCKSIZE ROW
> > APPEND OFF
> > NOT VOLATILE;
> >
> >
> >
> >
> >
> > IDS Logistik GmbH
> > Marc Rink
> > - Software Development Manager -
> > Saaläckerstrasse 8
> > 63801 Kleinostheim
> >
> > Tel: +49(6027)40903-13
> > Fax: +49(6027)40903-9013
> > MOB: +49(170)9672528
> >
> > Internet: http://www.ids-logistik.de
> > E-Mail: marc_rink@
> >
> > Sitz der Gesellschaft: Kleinostheim
> > Amtsgericht Aschaffenburg - HRB 10253
> > Geschäftsführer: Dr. Michael Bargl
> > Vorsitzender des Beirates: Mathias Krage
> >
> > ----------------------------------------------------------
> > "Computer games don't affect kids. I mean if Pac-Man affected us as
> kids,
> > we'd all be running around in darkened rooms, munching magic pills and
> > listening to repetitive electronic music."
> > --Kristian Wilson, Nintendo 1989.
> >
>

Reply | Forward | Messages in this Topic (5)
#3021 From: marc_rink@...
Date: Tue Nov 24, 2009 2:55 pm
Subject: Antwort: Re: Importwizard 		docjones999
Offline Offline
Send Email Send Email
 

Hi Ken,

All rows have been imported. It seems that just the counter is wrong.

regards
Marc

IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.


Von: "kenryan20072000" <Kenneth.Ryan@...>
An: toaddb2beta@yahoogroups.com
Datum: 24.11.2009 15:52
Betreff: [toaddb2beta] Re: Importwizard
Gesendet von: toaddb2beta@yahoogroups.com




 

Marc,

How many rows actually get imported into the table? I'm not sure if the "Imported Row" count is wrong or if Import is rejecting most of the rows.

If Import is rejecting all those rows, you might try using the Right Click->Utilities->Import on a Table in the Object Browser. This may help you see any warning messages from DB2 which might explain the rejected rows.

Ken Ryan
Toad for DB2 Development
Quest Software

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Heyas,
>
> After importing roughtly 80k rows, the "Read Rows" and "Imported Rows"
> Information in the wizard result window differs:
>
>
> Find attached the DDL, the import script and the import file.
>
> HTH :)
>
> Marc
>
> SET SCHEMA = 'STAT';
>
> CREATE TABLE "STAT"."CADIS_BELOG_VDID" (
> "SDGNR" VARCHAR(35) NOT NULL,
> "SDGDATUM" DATE NOT NULL,
> "C_ADID" VARCHAR(10) NOT NULL,
> "C_VDID" VARCHAR(10) NOT NULL,
> "C_EDID" VARCHAR(10),
> "C_VLDKZ" INTEGER,
> "C_IMPORT" VARCHAR(1),
> "Z_EDID" VARCHAR(10)
> )
> IN "USERSPACE1";
>
> ALTER TABLE "STAT"."CADIS_BELOG_VDID"
> DATA CAPTURE NONE
> LOCKSIZE ROW
> APPEND OFF
> NOT VOLATILE;
>
>
>
>
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet: http://www.ids-logistik.de
> E-Mail: marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ----------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>




Reply | Forward | Messages in this Topic (5)
#3020 From: "kenryan20072000" <Kenneth.Ryan@...>
Date: Tue Nov 24, 2009 2:52 pm
Subject: Re: Importwizard 		kenryan20072000
Offline Offline
Send Email Send Email
  
Marc,

How many rows actually get imported into the table?  I'm not sure if the
"Imported Row" count is wrong or if Import is rejecting most of the rows.

If Import is rejecting all those rows, you might try using the Right
Click->Utilities->Import on a Table in the Object Browser.  This may help you
see any warning messages from DB2 which might explain the rejected rows.

Ken Ryan
Toad for DB2 Development
Quest Software

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Heyas,
>
> After importing roughtly 80k rows, the "Read Rows" and "Imported Rows"
> Information in the wizard result window differs:
>
>
> Find attached the DDL, the import script and the import file.
>
> HTH :)
>
> Marc
>
> SET SCHEMA = 'STAT';
>
> CREATE TABLE "STAT"."CADIS_BELOG_VDID" (
>   "SDGNR"       VARCHAR(35)     NOT NULL,
>   "SDGDATUM"    DATE    NOT NULL,
>   "C_ADID"      VARCHAR(10)     NOT NULL,
>   "C_VDID"      VARCHAR(10)     NOT NULL,
>   "C_EDID"      VARCHAR(10),
>   "C_VLDKZ"     INTEGER,
>   "C_IMPORT"    VARCHAR(1),
>   "Z_EDID"      VARCHAR(10)
> )
>   IN "USERSPACE1";
>
> ALTER TABLE "STAT"."CADIS_BELOG_VDID"
>   DATA CAPTURE NONE
>   LOCKSIZE ROW
>   APPEND OFF
>   NOT VOLATILE;
>
>
>
>
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet:    http://www.ids-logistik.de
> E-Mail:      marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ------------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>

Reply | Forward | Messages in this Topic (5)
#3019 From: marc_rink@...
Date: Tue Nov 24, 2009 12:49 pm
Subject: Importwizard 		docjones999
Offline Offline
Send Email Send Email
 

Heyas,

After importing roughtly 80k rows, the "Read Rows" and "Imported Rows" Information in the wizard result window differs:


Find attached the DDL, the import script and the import file.

HTH :)

Marc

SET SCHEMA = 'STAT';

CREATE TABLE "STAT"."CADIS_BELOG_VDID" (
  "SDGNR"        VARCHAR(35)        NOT NULL,
  "SDGDATUM"        DATE        NOT NULL,
  "C_ADID"        VARCHAR(10)        NOT NULL,
  "C_VDID"        VARCHAR(10)        NOT NULL,
  "C_EDID"        VARCHAR(10),
  "C_VLDKZ"        INTEGER,
  "C_IMPORT"        VARCHAR(1),
  "Z_EDID"        VARCHAR(10)
)
  IN "USERSPACE1";

ALTER TABLE "STAT"."CADIS_BELOG_VDID"
  DATA CAPTURE NONE
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;





IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.

2 of 2 File(s)


Reply | Forward | Messages in this Topic (5)
#3018 From: "jeff_podlasek" <Jeff.Podlasek@...>
Date: Mon Nov 23, 2009 5:08 pm
Subject: Antwort: Re: Export script via automation 		jeff_podlasek
Offline Offline
Send Email Send Email
  
Marc
Thanks for the information.
I will add this information to the CR we created to track this issue.
Jeff

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Hello Jeff,
>
> here are the DDL's. SDGACCESS contains approx 9m records. with ~450000 to
> be expected in the export.
> ELIX.DEPOT (the table on which ELIX.IDS depends upon) cas about 500
> records with ~50 records with IS_IDS=1.
>
> My machine has 4GB of memory (running XP). As you see by the timestamps,
> the error occurs after the export.
> I already filed a similar issue with SystemOutOfMemory Exception
> previously, i was in contact with Debbie Peabody
>
> Anything i can provide you with?
>
> regards
> Marc
>
> -- Script created by Quest Extract DDL at 23.11.2009 09:47:19 for LOGI_LS
> (quentia)
> -- System Objects may have been excluded from this script.
> SET SCHEMA = 'QUENTIA';
>
> CREATE TABLE "ELIX"."SDGACCESS" (
>   "SDGNR"       VARCHAR(35)     NOT NULL,
>   "SDGJAHR"     SMALLINT        NOT NULL,
>   "BORDDAT"     TIMESTAMP,
>   "SDGDATUM"    TIMESTAMP,
>   "VERID"       VARCHAR(35),
>   "VERNAME1"    VARCHAR(35),
>   "EMPNAME1"    VARCHAR(35),
>   "EMPLAND"     VARCHAR(3),
>   "EMPZIP"      VARCHAR(10),
>   "EMPORT"      VARCHAR(35),
>   "VDID"        VARCHAR(10),
>   "EDID"        VARCHAR(10),
>   "ADID"        VARCHAR(10),
>   "DEPOTLISTE"  VARCHAR(500),
>   "DONE"        SMALLINT        DEFAULT ,
>   "STATUSLISTE" VARCHAR(500),
>   "QUITTUNG"    SMALLINT        DEFAULT ,
>   "MP05DATE"    TIMESTAMP,
>   "STATUS"      SMALLINT        DEFAULT ,
>   "EMPSTR1"     VARCHAR(35),
>   "GEWICHT"     DECIMAL(12,3),
>   "COLLIANZAHL" INTEGER,
>   "EMPID"       VARCHAR(35),
>   "BORDNR"      VARCHAR(35),
>   "VERLAND"     VARCHAR(3),
>   "VERZIP"      VARCHAR(10),
>   "VERORT"      VARCHAR(35),
>   "REFERENZ"    VARCHAR(350),
>   "RECID"       SMALLINT,
>   "VERSTR1"     VARCHAR(35),
>   "MPLISTE"     VARCHAR(500),
>   "THESOURCE"   VARCHAR(5),
>   "DRINGLICHKEIT"       VARCHAR(3),
>   "WRTDAT"      TIMESTAMP       DEFAULT ,
>   "TYP" VARCHAR(1),
>   "TERMINKEY"   VARCHAR(20),
>   "TERMIN"      TIMESTAMP,
>   "HINWKEYLISTE"        VARCHAR(500),
>   "AUFID"       VARCHAR(35),
>   "Z"   SMALLINT        NOT NULL        DEFAULT ,
>   "O"   SMALLINT        NOT NULL        DEFAULT ,
>   "C"   SMALLINT        NOT NULL        DEFAULT
> )
>   IN "USERSPACE2_D";
>
> ALTER TABLE "ELIX"."SDGACCESS"
>   DATA CAPTURE NONE
>   LOCKSIZE ROW
>   APPEND OFF
>   NOT VOLATILE;
>
> COMMENT ON "ELIX"."SDGACCESS" (
>         "AUFID" IS 'Kundennummer Auftraggebender Kunde',
>         "Z" IS 'TYP ZAS',
>         "O" IS 'TYP ORDER',
>         "C" IS 'TYP CADIS' );
>
> ALTER TABLE "ELIX"."SDGACCESS"
>   ADD CONSTRAINT "PK_SDGACCESS" PRIMARY KEY
>     ("SDGNR", "SDGJAHR");
>
> CREATE VIEW ELIX.SDGACCESS_TOD_FP (SDGNR, SDGJAHR, TODKEY, BORDDAT,
> SDGDATUM, VERID, VERNAME1, EMPNAME1, EMPLAND, EMPZIP, EMPORT, VDID, EDID,
> ADID, DEPOTLISTE, DONE, STATUSLISTE, QUITTUNG, MP05DATE, STATUS, EMPSTR1,
> GEWICHT, FPGEWICHT_INT, FPGEWICHT_NAT, COLLIANZAHL, EMPID, BORDNR,
> VERLAND, VERZIP, VERORT, REFERENZ, RECID, VERSTR1, MPLISTE, THESOURCE,
> DRINGLICHKEIT, WRTDAT, TYP, TERMINKEY, TERMIN, ZONE) AS
>   SELECT SDGNR, SDGJAHR, ELIX.GETTOD(SDGNR, SDGJAHR) AS TODKEY,BORDDAT,
> SDGDATUM, VERID, VERNAME1, EMPNAME1, EMPLAND, EMPZIP, EMPORT, VDID, EDID,
> ADID, DEPOTLISTE, DONE, STATUSLISTE, QUITTUNG, MP05DATE, STATUS, EMPSTR1,
> GEWICHT, ELIX.GETFPGEWICHT(sdgnr,sdgjahr,250,125,250,250)AS fpgewicht_int,
> ELIX.GETFPGEWICHT(sdgnr,sdgjahr,150,75,150,150) AS fpgewicht_nat,
> COLLIANZAHL, EMPID, BORDNR, VERLAND, VERZIP, VERORT, REFERENZ, RECID,
> VERSTR1, MPLISTE, THESOURCE, DRINGLICHKEIT, WRTDAT, TYP, TERMINKEY,
> TERMIN, ELIX.GETZONE(sdgnr,sdgjahr,CHAR('E'),CAST(NULL AS CHAR)) AS ZONE
>   FROM ELIX.SDGACCESS;
>
>
> CREATE VIEW ELIX.IDS ( DEPOTID ) AS
>   SELECT depotid
>   from elix.depot
>   where is_ids = 1;^
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet:    http://www.ids-logistik.de
> E-Mail:      marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ------------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>
>
>
>
> Von:
> "jeff_podlasek" <Jeff.Podlasek@...>
> An:
> toaddb2beta@yahoogroups.com
> Datum:
> 20.11.2009 23:11
> Betreff:
> [toaddb2beta] Re: Export script via automation
> Gesendet von:
> toaddb2beta@yahoogroups.com
>
>
>
>
> Marc
> we have not been able to recreate this issue.
> Can you send in the DDL for the two tables in your query?
> Can you let us know how much memory is on your machine?
> Can you get automation to run with a query that returns a smaller result
> set?
> I have opened CR 68943 to track this.Jeff
>
> --- In toaddb2beta@yahoogroups.com, marc_rink@ wrote:
> >
> > Heyas,
> >
> > while i was running an automation script with a simple export to excel
> > within, i got the following error in the report summary:
> > ----------------------------------------------------------
> > Category Timestamp Message
> > Automation Logging 19.11.2009 15:08:52 Build started
> > Automation Logging 19.11.2009 15:08:58 Warnung bei Überprüfung
> > von Aktivität 'ExceptionEmail': Text of message body is not specified
> > Automation Logging 19.11.2009 15:08:58 Build Completed
> > Automation Logging 19.11.2009 15:08:58 Connecting to LOGI_LS
> > (ELIX)
> > Automation Logging 19.11.2009 15:08:58 Connection successful.
> > Automation Logging 19.11.2009 15:08:58 Running export template
> > C:\Dokumente und Einstellungen\MRink\Desktop\sdg.txp
> > Statusbar 19.11.2009 17:27:47 Export Finished [11], errors
> > detected, click <link> for summary.
> > Automation Logging 19.11.2009 17:27:47 Attempted export 450204
> > rows.
> > Automation Logging 19.11.2009 17:27:47 Successfully exported
> > 450203 rows.
> > Automation Logging 19.11.2009 17:27:47 Export Finished, click <
> > link> to view file.
> > Automation Logging 19.11.2009 17:27:47 Eine Ausnahme vom Typ
> > "System.OutOfMemoryException" wurde ausgelöst.
> > Automation Logging 19.11.2009 17:27:47 Start error email
> > Automation Logging 19.11.2009 17:27:47 Failed
> > ----------------------------------------------------------
> > Please note:
> > There is a slight difference between "Attempted export..." and
> > "Successfully exported..." number of rows. Possibly caused by the
> > exceptions.
> >
> > Second <link> was:
> > ToadExport2009-11-19 15-08-59.xlsx, which i cant found on my machine
> > (hasn't been written, apparently).
> >
> >
> > The log first <link> itself looks like the exception occured after
> > successfully exporting:
> > ----------------------------------------------------------
> > Export Started [19.11.2009 15:08:58]
> > Export Wizard: Building object list
> > Exporting Data
> > Object SQL Query started.
> > InternalReadBackground - start
> > InternalReadBackground - after ExecuteReader - command SELECT * FROM
> > ELIX.SDGACCESS_tod_fp where vdid in (select * from elix.ids) and edid in
>
> > (select * from elix.ids) and borddat between '2009-10-01 00:00:00.0000'
> > and '2009-11-01 00:00:00.0000' with ur
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows5000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 5000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows10000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 10000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows15000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 15000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows20000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 20000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows25000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 25000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows30000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 30000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows35000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 35000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows40000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 40000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows45000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 45000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows50000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 50000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows55000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 55000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows60000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 60000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows65000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 65000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows70000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 70000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows75000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 75000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows80000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 80000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows85000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 85000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows90000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 90000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows95000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 95000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows100000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 100000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows105000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 105000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows110000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 110000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows115000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 115000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows120000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 120000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows125000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 125000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows130000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 130000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows135000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 135000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows140000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 140000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows145000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 145000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows150000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 150000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows155000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 155000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows160000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 160000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows165000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 165000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows170000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 170000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows175000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 175000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows180000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 180000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows185000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 185000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows190000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 190000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows195000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 195000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows200000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 200000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows205000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 205000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows210000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 210000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows215000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 215000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows220000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 220000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows225000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 225000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows230000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 230000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows235000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 235000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows240000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 240000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows245000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 245000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows250000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 250000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows255000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 255000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows260000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 260000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows265000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 265000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows270000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 270000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows275000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 275000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows280000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 280000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows285000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 285000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows290000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 290000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows295000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 295000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows300000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 300000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows305000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 305000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows310000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 310000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows315000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 315000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows320000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 320000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows325000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 325000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows330000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 330000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows335000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 335000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows340000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 340000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows345000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 345000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows350000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 350000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows355000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 355000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows360000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 360000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows365000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 365000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows370000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 370000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows375000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 375000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows380000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 380000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows385000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 385000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows390000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 390000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows395000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 395000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows400000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 400000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows405000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 405000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows410000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 410000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows415000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 415000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows420000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 420000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows425000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 425000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows430000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 430000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows435000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 435000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows440000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 440000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows445000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 445000
> > InternalReadBackground - after RaisePausingRead
> > InternalReadBackground - before Wait()
> > PausingReadThreadWriter after WriteRows - Cancel False
> > PausingReadThreadWriter finally - Read Rows450000
> > PausingReadThreadWriter finally - CancelTableWrite False
> > PausingReadThreadWriter finally - adapter.RowsRead 450000
> > InternalReadBackground - exception ERROR [58005] [IBM][DB2.NET] SQL0902
> An
> > unexpected exception has occurred in Process: 5120 Thread 52 AppDomain:
> > Name:Toad.exe
> > Keine Kontextrichtlinien vorhanden.
> > Function: DB2DataReader.Read()
> > CallStack: bei System.Environment.GetStackTrace(Exception e, Boolean
> > needFileInfo)
> > bei System.Environment.get_StackTrace()
> > bei IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg,
> > Exception exception, Boolean bThrow)
> > bei IBM.Data.DB2.DB2DataReader.Read()
> > bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
> > bei Quest.Toad.Db.ToadDataAdapter.InternalFillBackground()
> > bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
> > bei System.Threading.ExecutionContext.runTryCode(Object userData)
> > bei
> >
>
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(\
TryCode
>
> > code, CleanupCode backoutCode, Object userData)
> > bei System.Threading.ExecutionContext.RunInternal(ExecutionContext
> > executionContext, ContextCallback callback, Object state)
> > bei System.Threading.ExecutionContext.Run(ExecutionContext
> > executionContext, ContextCallback callback, Object state)
> > bei System.Threading.ThreadHelper.ThreadStart() InnerException Message:
> > Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Check
> > InnerException property for more detail. SQLSTATE=58005
> > InternalReadBackground - stack bei
> > IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception
>
> > exception, Boolean bThrow)
> > bei IBM.Data.DB2.DB2DataReader.Read()
> > bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
> > DoneReadTreadWriter
> > User cancelled
> > DoneReadThreadWriter finally - adapter.RowsRead 453151
> > Object SQL Query finished with error: Eine Ausnahme vom Typ
> > "System.OutOfMemoryException" wurde ausgelöst.
> > bei System.Collections.Generic.List`1.ToArray()
> > bei System.RuntimeType.GetPropertyCandidates(String name, BindingFlags
> > bindingAttr, Type[] types, Boolean allowPrefixLookup)
> > bei System.RuntimeType.GetPropertyImpl(String name, BindingFlags
> > bindingAttr, Binder binder, Type returnType, Type[] types,
> > ParameterModifier[] modifiers)
> > bei System.Type.GetProperty(String name)
> > bei Quest.Toad.ImportExport.Writers.WriterExcel.WriteRow(Object row)
> > bei Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable
> > fastTable)
> > bei Quest.Toad.ImportExport.ExportObjectData.DoneReadThreadWriter()
> > Export Finished [19.11.2009 17:27:47]
> > ----------------------------------------------------------
> > SDGACCESS_TOD_FP is a view.
> >
> >
> > Afterwards i got four exception windows raised:
> > ----------------------------------------------------------
> > System.OutOfMemoryException
> > Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> > Stack Trace:
> > bei System.Windows.Forms.Control.ThreadMethodEntry..ctor(Control
> > caller, Delegate method, Object[] args, Boolean synchronous,
> > ExecutionContext executionContext)
> > bei System.Windows.Forms.Control.MarshaledInvoke(Control caller,
> > Delegate method, Object[] args, Boolean synchronous)
> > bei System.Windows.Forms.Control.BeginInvoke(Delegate method, Object[]
> > args)
> > bei Quest.Toad.Util.Global.BeginInvoke(Delegate handler, Object[] args)
> > bei Quest.Toad.VersionControl.RepositoryManager.ResumeNotifications()
> > bei Quest.Toad.VersionControl.Actions.UpdateStatusIdle(BarItem item)
> > ----------------------------------------------------------
> >
> > ----------------------------------------------------------
> > System.OutOfMemoryException
> > Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> > Stack Trace:
> > bei System.String.ToCharArray()
> > bei System.Text.Encoding.GetBytes(String s)
> > bei Quest.Toad.Util.Global.EncodedHash(String str)
> > bei Quest.Toad.Settings.TrlContextCollection.Trl2Path(ITrl trl)
> > bei Quest.Toad.Settings.FilterContextCollection.get_Item(ITrl trl)
> > bei Quest.Toad.Dov.TableDataViewControl.DefineFilterIdle(BarItem item)
> > ----------------------------------------------------------
> >
> > ----------------------------------------------------------
> > System.OutOfMemoryException
> > Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> > Stack Trace:
> > bei
> >
>
Quest.Toad.Util.DevExpressBarMessageFilterHack.ToadBarManagerMessageFilter.Syste\
m.Windows.Forms.IMessageFilter.PreFilterMessage(Message&
>
> > m)
> > ----------------------------------------------------------
> >
> > ----------------------------------------------------------
> > System.OutOfMemoryException
> > Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> > Stack Trace:
> > bei
> >
>
System.RuntimeType.RuntimeTypeCache.MemberInfoCache`1.AddMethod(RuntimeTypeHandl\
e
>
> > declaringType, RuntimeMethodHandle method, CacheType cacheType)
> > bei System.RuntimeType.RuntimeTypeCache.GetMethod(RuntimeTypeHandle
> > declaringType, RuntimeMethodHandle method)
> > bei System.RuntimeType.GetMethodBase(RuntimeTypeHandle
> > reflectedTypeHandle, RuntimeMethodHandle methodHandle)
> > bei System.Delegate.DynamicInvokeImpl(Object[] args)
> > bei
> > System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry
>
> > tme)
> > bei System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object
> > obj)
> > bei System.Threading.ExecutionContext.runTryCode(Object userData)
> > bei
> >
>
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(\
TryCode
>
> > code, CleanupCode backoutCode, Object userData)
> > bei System.Threading.ExecutionContext.RunInternal(ExecutionContext
> > executionContext, ContextCallback callback, Object state)
> > bei System.Threading.ExecutionContext.Run(ExecutionContext
> > executionContext, ContextCallback callback, Object state)
> > bei
> > System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry
> > tme)
> > bei System.Windows.Forms.Control.InvokeMarshaledCallbacks()
> > ----------------------------------------------------------
> >
> > Attached are the automation script, the export script and the automation
>
> > log as well as the exception log.
> >
> > Hope this helps :)
> >
> > regards
> > Marc
> >
> >
> > IDS Logistik GmbH
> > Marc Rink
> > - Software Development Manager -
> > Saaläckerstrasse 8
> > 63801 Kleinostheim
> >
> > Tel: +49(6027)40903-13
> > Fax: +49(6027)40903-9013
> > MOB: +49(170)9672528
> >
> > Internet: http://www.ids-logistik.de
> > E-Mail: marc_rink@
> >
> > Sitz der Gesellschaft: Kleinostheim
> > Amtsgericht Aschaffenburg - HRB 10253
> > Geschäftsführer: Dr. Michael Bargl
> > Vorsitzender des Beirates: Mathias Krage
> >
> > ----------------------------------------------------------
> > "Computer games don't affect kids. I mean if Pac-Man affected us as
> kids,
> > we'd all be running around in darkened rooms, munching magic pills and
> > listening to repetitive electronic music."
> > --Kristian Wilson, Nintendo 1989.
> >
>

Reply | Forward | Messages in this Topic (4)
#3017 From: marc_rink@...
Date: Mon Nov 23, 2009 8:58 am
Subject: Antwort: Re: Export script via automation 		docjones999
Offline Offline
Send Email Send Email
 

Hello Jeff,

here are the DDL's. SDGACCESS contains approx 9m records. with ~450000 to be expected in the export.
ELIX.DEPOT (the table on which ELIX.IDS depends upon) cas about 500 records with ~50 records with IS_IDS=1.

My machine has 4GB of memory (running XP). As you see by the timestamps, the error occurs after the export.
I already filed a similar issue with SystemOutOfMemory Exception previously, i was in contact with Debbie Peabody

Anything i can provide you with?

regards
Marc

-- Script created by Quest Extract DDL at 23.11.2009 09:47:19 for LOGI_LS (quentia)
-- System Objects may have been excluded from this script.
SET SCHEMA = 'QUENTIA';

CREATE TABLE "ELIX"."SDGACCESS" (
  "SDGNR"        VARCHAR(35)        NOT NULL,
  "SDGJAHR"        SMALLINT        NOT NULL,
  "BORDDAT"        TIMESTAMP,
  "SDGDATUM"        TIMESTAMP,
  "VERID"        VARCHAR(35),
  "VERNAME1"        VARCHAR(35),
  "EMPNAME1"        VARCHAR(35),
  "EMPLAND"        VARCHAR(3),
  "EMPZIP"        VARCHAR(10),
  "EMPORT"        VARCHAR(35),
  "VDID"        VARCHAR(10),
  "EDID"        VARCHAR(10),
  "ADID"        VARCHAR(10),
  "DEPOTLISTE"        VARCHAR(500),
  "DONE"        SMALLINT        DEFAULT ,
  "STATUSLISTE"        VARCHAR(500),
  "QUITTUNG"        SMALLINT        DEFAULT ,
  "MP05DATE"        TIMESTAMP,
  "STATUS"        SMALLINT        DEFAULT ,
  "EMPSTR1"        VARCHAR(35),
  "GEWICHT"        DECIMAL(12,3),
  "COLLIANZAHL"        INTEGER,
  "EMPID"        VARCHAR(35),
  "BORDNR"        VARCHAR(35),
  "VERLAND"        VARCHAR(3),
  "VERZIP"        VARCHAR(10),
  "VERORT"        VARCHAR(35),
  "REFERENZ"        VARCHAR(350),
  "RECID"        SMALLINT,
  "VERSTR1"        VARCHAR(35),
  "MPLISTE"        VARCHAR(500),
  "THESOURCE"        VARCHAR(5),
  "DRINGLICHKEIT"        VARCHAR(3),
  "WRTDAT"        TIMESTAMP        DEFAULT ,
  "TYP"        VARCHAR(1),
  "TERMINKEY"        VARCHAR(20),
  "TERMIN"        TIMESTAMP,
  "HINWKEYLISTE"        VARCHAR(500),
  "AUFID"        VARCHAR(35),
  "Z"        SMALLINT        NOT NULL        DEFAULT ,
  "O"        SMALLINT        NOT NULL        DEFAULT ,
  "C"        SMALLINT        NOT NULL        DEFAULT
)
  IN "USERSPACE2_D";

ALTER TABLE "ELIX"."SDGACCESS"
  DATA CAPTURE NONE
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;

COMMENT ON "ELIX"."SDGACCESS" (
        "AUFID" IS 'Kundennummer Auftraggebender Kunde',
        "Z" IS 'TYP ZAS',
        "O" IS 'TYP ORDER',
        "C" IS 'TYP CADIS' );

ALTER TABLE "ELIX"."SDGACCESS"
  ADD CONSTRAINT "PK_SDGACCESS" PRIMARY KEY
    ("SDGNR", "SDGJAHR");

CREATE VIEW ELIX.SDGACCESS_TOD_FP (SDGNR, SDGJAHR, TODKEY, BORDDAT, SDGDATUM, VERID, VERNAME1, EMPNAME1, EMPLAND, EMPZIP, EMPORT, VDID, EDID, ADID, DEPOTLISTE, DONE, STATUSLISTE, QUITTUNG, MP05DATE, STATUS, EMPSTR1, GEWICHT, FPGEWICHT_INT, FPGEWICHT_NAT, COLLIANZAHL, EMPID, BORDNR, VERLAND, VERZIP, VERORT, REFERENZ, RECID, VERSTR1, MPLISTE, THESOURCE, DRINGLICHKEIT, WRTDAT, TYP, TERMINKEY, TERMIN, ZONE) AS
  SELECT SDGNR, SDGJAHR, ELIX.GETTOD(SDGNR, SDGJAHR) AS TODKEY,BORDDAT, SDGDATUM, VERID, VERNAME1, EMPNAME1, EMPLAND, EMPZIP, EMPORT, VDID, EDID, ADID, DEPOTLISTE, DONE, STATUSLISTE, QUITTUNG, MP05DATE, STATUS, EMPSTR1, GEWICHT, ELIX.GETFPGEWICHT(sdgnr,sdgjahr,250,125,250,250)AS fpgewicht_int, ELIX.GETFPGEWICHT(sdgnr,sdgjahr,150,75,150,150) AS fpgewicht_nat, COLLIANZAHL, EMPID, BORDNR, VERLAND, VERZIP, VERORT, REFERENZ, RECID, VERSTR1, MPLISTE, THESOURCE, DRINGLICHKEIT, WRTDAT, TYP, TERMINKEY, TERMIN, ELIX.GETZONE(sdgnr,sdgjahr,CHAR('E'),CAST(NULL AS CHAR)) AS ZONE
  FROM ELIX.SDGACCESS;


CREATE VIEW ELIX.IDS ( DEPOTID ) AS
  SELECT depotid
  from elix.depot
  where is_ids = 1;^

IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.


Von: "jeff_podlasek" <Jeff.Podlasek@...>
An: toaddb2beta@yahoogroups.com
Datum: 20.11.2009 23:11
Betreff: [toaddb2beta] Re: Export script via automation
Gesendet von: toaddb2beta@yahoogroups.com




 

Marc
we have not been able to recreate this issue.
Can you send in the DDL for the two tables in your query?
Can you let us know how much memory is on your machine?
Can you get automation to run with a query that returns a smaller result set?
I have opened CR 68943 to track this.Jeff

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Heyas,
>
> while i was running an automation script with a simple export to excel
> within, i got the following error in the report summary:
> ----------------------------------------------------------
> Category Timestamp Message
> Automation Logging 19.11.2009 15:08:52 Build started
> Automation Logging 19.11.2009 15:08:58 Warnung bei Überprüfung
> von Aktivität 'ExceptionEmail': Text of message body is not specified
> Automation Logging 19.11.2009 15:08:58 Build Completed
> Automation Logging 19.11.2009 15:08:58 Connecting to LOGI_LS
> (ELIX)
> Automation Logging 19.11.2009 15:08:58 Connection successful.
> Automation Logging 19.11.2009 15:08:58 Running export template
> C:\Dokumente und Einstellungen\MRink\Desktop\sdg.txp
> Statusbar 19.11.2009 17:27:47 Export Finished [11], errors
> detected, click <link> for summary.
> Automation Logging 19.11.2009 17:27:47 Attempted export 450204
> rows.
> Automation Logging 19.11.2009 17:27:47 Successfully exported
> 450203 rows.
> Automation Logging 19.11.2009 17:27:47 Export Finished, click <
> link> to view file.
> Automation Logging 19.11.2009 17:27:47 Eine Ausnahme vom Typ
> "System.OutOfMemoryException" wurde ausgelöst.
> Automation Logging 19.11.2009 17:27:47 Start error email
> Automation Logging 19.11.2009 17:27:47 Failed
> ----------------------------------------------------------
> Please note:
> There is a slight difference between "Attempted export..." and
> "Successfully exported..." number of rows. Possibly caused by the
> exceptions.
>
> Second <link> was:
> ToadExport2009-11-19 15-08-59.xlsx, which i cant found on my machine
> (hasn't been written, apparently).
>
>
> The log first <link> itself looks like the exception occured after
> successfully exporting:
> ----------------------------------------------------------
> Export Started [19.11.2009 15:08:58]
> Export Wizard: Building object list
> Exporting Data
> Object SQL Query started.
> InternalReadBackground - start
> InternalReadBackground - after ExecuteReader - command SELECT * FROM
> ELIX.SDGACCESS_tod_fp where vdid in (select * from elix.ids) and edid in
> (select * from elix.ids) and borddat between '2009-10-01 00:00:00.0000'
> and '2009-11-01 00:00:00.0000' with ur
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows5000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 5000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows10000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 10000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows15000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 15000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows20000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 20000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows25000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 25000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows30000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 30000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows35000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 35000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows40000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 40000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows45000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 45000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows50000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 50000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows55000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 55000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows60000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 60000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows65000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 65000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows70000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 70000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows75000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 75000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows80000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 80000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows85000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 85000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows90000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 90000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows95000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 95000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows100000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 100000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows105000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 105000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows110000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 110000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows115000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 115000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows120000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 120000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows125000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 125000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows130000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 130000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows135000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 135000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows140000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 140000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows145000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 145000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows150000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 150000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows155000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 155000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows160000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 160000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows165000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 165000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows170000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 170000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows175000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 175000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows180000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 180000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows185000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 185000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows190000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 190000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows195000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 195000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows200000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 200000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows205000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 205000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows210000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 210000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows215000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 215000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows220000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 220000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows225000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 225000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows230000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 230000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows235000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 235000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows240000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 240000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows245000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 245000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows250000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 250000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows255000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 255000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows260000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 260000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows265000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 265000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows270000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 270000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows275000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 275000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows280000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 280000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows285000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 285000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows290000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 290000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows295000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 295000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows300000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 300000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows305000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 305000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows310000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 310000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows315000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 315000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows320000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 320000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows325000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 325000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows330000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 330000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows335000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 335000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows340000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 340000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows345000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 345000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows350000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 350000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows355000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 355000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows360000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 360000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows365000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 365000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows370000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 370000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows375000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 375000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows380000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 380000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows385000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 385000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows390000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 390000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows395000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 395000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows400000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 400000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows405000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 405000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows410000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 410000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows415000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 415000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows420000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 420000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows425000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 425000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows430000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 430000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows435000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 435000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows440000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 440000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows445000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 445000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows450000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 450000
> InternalReadBackground - exception ERROR [58005] [IBM][DB2.NET] SQL0902 An
> unexpected exception has occurred in Process: 5120 Thread 52 AppDomain:
> Name:Toad.exe
> Keine Kontextrichtlinien vorhanden.
> Function: DB2DataReader.Read()
> CallStack: bei System.Environment.GetStackTrace(Exception e, Boolean
> needFileInfo)
> bei System.Environment.get_StackTrace()
> bei IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg,
> Exception exception, Boolean bThrow)
> bei IBM.Data.DB2.DB2DataReader.Read()
> bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
> bei Quest.Toad.Db.ToadDataAdapter.InternalFillBackground()
> bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
> bei System.Threading.ExecutionContext.runTryCode(Object userData)
> bei
> System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode
> code, CleanupCode backoutCode, Object userData)
> bei System.Threading.ExecutionContext.RunInternal(ExecutionContext
> executionContext, ContextCallback callback, Object state)
> bei System.Threading.ExecutionContext.Run(ExecutionContext
> executionContext, ContextCallback callback, Object state)
> bei System.Threading.ThreadHelper.ThreadStart() InnerException Message:
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst. Check
> InnerException property for more detail. SQLSTATE=58005
> InternalReadBackground - stack bei
> IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception
> exception, Boolean bThrow)
> bei IBM.Data.DB2.DB2DataReader.Read()
> bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
> DoneReadTreadWriter
> User cancelled
> DoneReadThreadWriter finally - adapter.RowsRead 453151
> Object SQL Query finished with error: Eine Ausnahme vom Typ
> "System.OutOfMemoryException" wurde ausgelöst.
> bei System.Collections.Generic.List`1.ToArray()
> bei System.RuntimeType.GetPropertyCandidates(String name, BindingFlags
> bindingAttr, Type[] types, Boolean allowPrefixLookup)
> bei System.RuntimeType.GetPropertyImpl(String name, BindingFlags
> bindingAttr, Binder binder, Type returnType, Type[] types,
> ParameterModifier[] modifiers)
> bei System.Type.GetProperty(String name)
> bei Quest.Toad.ImportExport.Writers.WriterExcel.WriteRow(Object row)
> bei Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable
> fastTable)
> bei Quest.Toad.ImportExport.ExportObjectData.DoneReadThreadWriter()
> Export Finished [19.11.2009 17:27:47]
> ----------------------------------------------------------
> SDGACCESS_TOD_FP is a view.
>
>
> Afterwards i got four exception windows raised:
> ----------------------------------------------------------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
> bei System.Windows.Forms.Control.ThreadMethodEntry..ctor(Control
> caller, Delegate method, Object[] args, Boolean synchronous,
> ExecutionContext executionContext)
> bei System.Windows.Forms.Control.MarshaledInvoke(Control caller,
> Delegate method, Object[] args, Boolean synchronous)
> bei System.Windows.Forms.Control.BeginInvoke(Delegate method, Object[]
> args)
> bei Quest.Toad.Util.Global.BeginInvoke(Delegate handler, Object[] args)
> bei Quest.Toad.VersionControl.RepositoryManager.ResumeNotifications()
> bei Quest.Toad.VersionControl.Actions.UpdateStatusIdle(BarItem item)
> ----------------------------------------------------------
>
> ----------------------------------------------------------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
> bei System.String.ToCharArray()
> bei System.Text.Encoding.GetBytes(String s)
> bei Quest.Toad.Util.Global.EncodedHash(String str)
> bei Quest.Toad.Settings.TrlContextCollection.Trl2Path(ITrl trl)
> bei Quest.Toad.Settings.FilterContextCollection.get_Item(ITrl trl)
> bei Quest.Toad.Dov.TableDataViewControl.DefineFilterIdle(BarItem item)
> ----------------------------------------------------------
>
> ----------------------------------------------------------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
> bei
> Quest.Toad.Util.DevExpressBarMessageFilterHack.ToadBarManagerMessageFilter.System.Windows.Forms.IMessageFilter.PreFilterMessage(Message&
> m)
> ----------------------------------------------------------
>
> ----------------------------------------------------------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
> bei
> System.RuntimeType.RuntimeTypeCache.MemberInfoCache`1.AddMethod(RuntimeTypeHandle
> declaringType, RuntimeMethodHandle method, CacheType cacheType)
> bei System.RuntimeType.RuntimeTypeCache.GetMethod(RuntimeTypeHandle
> declaringType, RuntimeMethodHandle method)
> bei System.RuntimeType.GetMethodBase(RuntimeTypeHandle
> reflectedTypeHandle, RuntimeMethodHandle methodHandle)
> bei System.Delegate.DynamicInvokeImpl(Object[] args)
> bei
> System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry
> tme)
> bei System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object
> obj)
> bei System.Threading.ExecutionContext.runTryCode(Object userData)
> bei
> System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode
> code, CleanupCode backoutCode, Object userData)
> bei System.Threading.ExecutionContext.RunInternal(ExecutionContext
> executionContext, ContextCallback callback, Object state)
> bei System.Threading.ExecutionContext.Run(ExecutionContext
> executionContext, ContextCallback callback, Object state)
> bei
> System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry
> tme)
> bei System.Windows.Forms.Control.InvokeMarshaledCallbacks()
> ----------------------------------------------------------
>
> Attached are the automation script, the export script and the automation
> log as well as the exception log.
>
> Hope this helps :)
>
> regards
> Marc
>
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet: http://www.ids-logistik.de
> E-Mail: marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ----------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>




Reply | Forward | Messages in this Topic (4)
#3016 From: marc_rink@...
Date: Mon Nov 23, 2009 8:42 am
Subject: Export Wizard 		docjones999
Offline Offline
Send Email Send Email
 

Heyas,

I was trying to export some Tables/Views using the Export Wizard. When selecting "Schemas", i noticed the "Background Process " Window flashes a certain query every few seconds. After some time, TOAD gets very unresponsive and need to be killed.

I can try to provide screenies from the query showing up in the background process window if needed.

regards
Marc

IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.

Reply | Forward | Messages in this Topic (1)
#3015 From: "jeff_podlasek" <Jeff.Podlasek@...>
Date: Fri Nov 20, 2009 10:08 pm
Subject: Re: Export script via automation 		jeff_podlasek
Offline Offline
Send Email Send Email
  
Marc
we have not been able to recreate this issue.
Can you send in the DDL for the two tables in your query?
Can you let us know how much memory is on your machine?
Can you get automation to run with a query that returns a smaller result set?
I have opened CR 68943 to track this.Jeff

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Heyas,
>
> while i was running an automation script with a simple export to excel
> within, i got the following error in the report summary:
>
--------------------------------------------------------------------------------\
-------
> Category        Timestamp       Message
> Automation Logging      19.11.2009 15:08:52     Build started
> Automation Logging      19.11.2009 15:08:58     Warnung bei Überprüfung
> von Aktivität 'ExceptionEmail': Text of message body is not specified
> Automation Logging      19.11.2009 15:08:58     Build Completed
> Automation Logging      19.11.2009 15:08:58     Connecting to LOGI_LS
> (ELIX)
> Automation Logging      19.11.2009 15:08:58     Connection successful.
> Automation Logging      19.11.2009 15:08:58     Running export template
> C:\Dokumente und Einstellungen\MRink\Desktop\sdg.txp
> Statusbar       19.11.2009 17:27:47     Export Finished [11], errors
> detected, click <link> for summary.
> Automation Logging      19.11.2009 17:27:47     Attempted export 450204
> rows.
> Automation Logging      19.11.2009 17:27:47     Successfully exported
> 450203 rows.
> Automation Logging      19.11.2009 17:27:47     Export Finished, click <
> link> to view file.
> Automation Logging      19.11.2009 17:27:47     Eine Ausnahme vom Typ
> "System.OutOfMemoryException" wurde ausgelöst.
> Automation Logging      19.11.2009 17:27:47     Start error email
> Automation Logging      19.11.2009 17:27:47     Failed
>
--------------------------------------------------------------------------------\
-------
> Please note:
> There is a slight difference between "Attempted export..." and
> "Successfully exported..." number of rows. Possibly caused by the
> exceptions.
>
> Second <link> was:
> ToadExport2009-11-19 15-08-59.xlsx, which i cant found on my machine
> (hasn't been written, apparently).
>
>
> The log first <link> itself looks like the exception occured after
> successfully exporting:
>
--------------------------------------------------------------------------------\
-------
> Export Started [19.11.2009 15:08:58]
> Export Wizard: Building object list
> Exporting Data
> Object SQL Query started.
> InternalReadBackground - start
> InternalReadBackground - after ExecuteReader - command SELECT * FROM
> ELIX.SDGACCESS_tod_fp where vdid in (select * from elix.ids) and edid in
> (select * from elix.ids) and borddat between '2009-10-01 00:00:00.0000'
> and '2009-11-01 00:00:00.0000' with ur
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows5000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 5000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows10000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 10000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows15000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 15000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows20000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 20000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows25000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 25000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows30000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 30000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows35000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 35000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows40000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 40000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows45000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 45000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows50000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 50000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows55000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 55000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows60000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 60000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows65000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 65000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows70000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 70000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows75000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 75000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows80000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 80000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows85000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 85000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows90000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 90000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows95000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 95000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows100000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 100000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows105000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 105000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows110000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 110000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows115000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 115000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows120000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 120000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows125000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 125000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows130000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 130000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows135000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 135000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows140000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 140000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows145000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 145000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows150000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 150000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows155000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 155000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows160000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 160000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows165000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 165000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows170000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 170000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows175000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 175000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows180000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 180000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows185000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 185000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows190000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 190000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows195000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 195000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows200000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 200000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows205000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 205000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows210000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 210000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows215000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 215000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows220000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 220000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows225000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 225000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows230000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 230000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows235000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 235000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows240000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 240000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows245000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 245000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows250000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 250000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows255000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 255000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows260000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 260000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows265000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 265000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows270000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 270000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows275000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 275000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows280000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 280000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows285000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 285000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows290000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 290000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows295000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 295000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows300000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 300000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows305000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 305000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows310000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 310000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows315000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 315000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows320000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 320000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows325000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 325000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows330000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 330000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows335000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 335000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows340000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 340000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows345000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 345000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows350000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 350000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows355000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 355000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows360000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 360000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows365000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 365000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows370000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 370000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows375000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 375000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows380000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 380000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows385000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 385000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows390000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 390000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows395000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 395000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows400000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 400000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows405000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 405000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows410000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 410000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows415000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 415000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows420000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 420000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows425000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 425000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows430000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 430000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows435000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 435000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows440000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 440000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows445000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 445000
> InternalReadBackground - after RaisePausingRead
> InternalReadBackground - before Wait()
> PausingReadThreadWriter after WriteRows - Cancel False
> PausingReadThreadWriter finally - Read Rows450000
> PausingReadThreadWriter finally - CancelTableWrite False
> PausingReadThreadWriter finally - adapter.RowsRead 450000
> InternalReadBackground - exception ERROR [58005] [IBM][DB2.NET] SQL0902 An
> unexpected exception has occurred in  Process: 5120 Thread 52 AppDomain:
> Name:Toad.exe
> Keine Kontextrichtlinien vorhanden.
>  Function: DB2DataReader.Read()
>  CallStack:    bei System.Environment.GetStackTrace(Exception e, Boolean
> needFileInfo)
>    bei System.Environment.get_StackTrace()
>    bei IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg,
> Exception exception, Boolean bThrow)
>    bei IBM.Data.DB2.DB2DataReader.Read()
>    bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
>    bei Quest.Toad.Db.ToadDataAdapter.InternalFillBackground()
>    bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
>    bei System.Threading.ExecutionContext.runTryCode(Object userData)
>    bei
>
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(\
TryCode
> code, CleanupCode backoutCode, Object userData)
>    bei System.Threading.ExecutionContext.RunInternal(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>    bei System.Threading.ExecutionContext.Run(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>    bei System.Threading.ThreadHelper.ThreadStart() InnerException Message:
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst. Check
> InnerException property for more detail.  SQLSTATE=58005
> InternalReadBackground - stack    bei
> IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception
> exception, Boolean bThrow)
>    bei IBM.Data.DB2.DB2DataReader.Read()
>    bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
> DoneReadTreadWriter
> User cancelled
> DoneReadThreadWriter finally - adapter.RowsRead 453151
> Object SQL Query finished with error: Eine Ausnahme vom Typ
> "System.OutOfMemoryException" wurde ausgelöst.
>    bei System.Collections.Generic.List`1.ToArray()
>    bei System.RuntimeType.GetPropertyCandidates(String name, BindingFlags
> bindingAttr, Type[] types, Boolean allowPrefixLookup)
>    bei System.RuntimeType.GetPropertyImpl(String name, BindingFlags
> bindingAttr, Binder binder, Type returnType, Type[] types,
> ParameterModifier[] modifiers)
>    bei System.Type.GetProperty(String name)
>    bei Quest.Toad.ImportExport.Writers.WriterExcel.WriteRow(Object row)
>    bei Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable
> fastTable)
>    bei Quest.Toad.ImportExport.ExportObjectData.DoneReadThreadWriter()
> Export Finished [19.11.2009 17:27:47]
>
--------------------------------------------------------------------------------\
-------
> SDGACCESS_TOD_FP is a view.
>
>
> Afterwards i got four exception windows raised:
>
--------------------------------------------------------------------------------\
-------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
>    bei System.Windows.Forms.Control.ThreadMethodEntry..ctor(Control
> caller, Delegate method, Object[] args, Boolean synchronous,
> ExecutionContext executionContext)
>    bei System.Windows.Forms.Control.MarshaledInvoke(Control caller,
> Delegate method, Object[] args, Boolean synchronous)
>    bei System.Windows.Forms.Control.BeginInvoke(Delegate method, Object[]
> args)
>    bei Quest.Toad.Util.Global.BeginInvoke(Delegate handler, Object[] args)
>    bei Quest.Toad.VersionControl.RepositoryManager.ResumeNotifications()
>    bei Quest.Toad.VersionControl.Actions.UpdateStatusIdle(BarItem item)
>
--------------------------------------------------------------------------------\
-------
>
>
--------------------------------------------------------------------------------\
-------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
>    bei System.String.ToCharArray()
>    bei System.Text.Encoding.GetBytes(String s)
>    bei Quest.Toad.Util.Global.EncodedHash(String str)
>    bei Quest.Toad.Settings.TrlContextCollection.Trl2Path(ITrl trl)
>    bei Quest.Toad.Settings.FilterContextCollection.get_Item(ITrl trl)
>    bei Quest.Toad.Dov.TableDataViewControl.DefineFilterIdle(BarItem item)
>
--------------------------------------------------------------------------------\
-------
>
>
--------------------------------------------------------------------------------\
-------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
>    bei
>
Quest.Toad.Util.DevExpressBarMessageFilterHack.ToadBarManagerMessageFilter.Syste\
m.Windows.Forms.IMessageFilter.PreFilterMessage(Message&
> m)
>
--------------------------------------------------------------------------------\
-------
>
>
--------------------------------------------------------------------------------\
-------
> System.OutOfMemoryException
> Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
> Stack Trace:
>    bei
>
System.RuntimeType.RuntimeTypeCache.MemberInfoCache`1.AddMethod(RuntimeTypeHandl\
e
> declaringType, RuntimeMethodHandle method, CacheType cacheType)
>    bei System.RuntimeType.RuntimeTypeCache.GetMethod(RuntimeTypeHandle
> declaringType, RuntimeMethodHandle method)
>    bei System.RuntimeType.GetMethodBase(RuntimeTypeHandle
> reflectedTypeHandle, RuntimeMethodHandle methodHandle)
>    bei System.Delegate.DynamicInvokeImpl(Object[] args)
>    bei
> System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry
> tme)
>    bei System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object
> obj)
>    bei System.Threading.ExecutionContext.runTryCode(Object userData)
>    bei
>
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(\
TryCode
> code, CleanupCode backoutCode, Object userData)
>    bei System.Threading.ExecutionContext.RunInternal(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>    bei System.Threading.ExecutionContext.Run(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>    bei
> System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry
> tme)
>    bei System.Windows.Forms.Control.InvokeMarshaledCallbacks()
>
--------------------------------------------------------------------------------\
-------
>
> Attached are the automation script, the export script and the automation
> log as well as the exception log.
>
> Hope this helps :)
>
> regards
> Marc
>
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet:    http://www.ids-logistik.de
> E-Mail:      marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ------------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>

Reply | Forward | Messages in this Topic (4)
#3014 From: "jeff_podlasek" <Jeff.Podlasek@...>
Date: Fri Nov 20, 2009 7:56 pm
Subject: Re: view object at cursor 		jeff_podlasek
Offline Offline
Send Email Send Email
  
John
You are correct that today you can hit F4 and view procedures and objects at the
cursor. However toad will display the first proc or function found.  If there
are several procs or functions with the same name and differing only in their
signature, the first one found will be shown. So the CR 164917 remains open to
handle those situations.

Regarding support for additional datatypes, we plan to introduce improved
support for all datatypes in a future release.
Jeff


--- In toaddb2beta@yahoogroups.com, "el28787" <john.enevoldson@...> wrote:
>
> Hi,
> According to "known issues" view object at cursor doesn't show stored
procedures or functions (CR#164917). This appears incorrect - I seem to get
details for both these object types.
> Are there plans to add row and cursor data types to this function ? it would
be very useful from a Developers point of view to easily see the component items
in a row or cursor type.
> Regards,
> John.
>

Reply | Forward | Messages in this Topic (2)
#3013 From: marc_rink@...
Date: Fri Nov 20, 2009 7:16 am
Subject: Export script via automation 		docjones999
Offline Offline
Send Email Send Email
 

Heyas,

while i was running an automation script with a simple export to excel within, i got the following error in the report summary:
---------------------------------------------------------------------------------------
Category        Timestamp        Message
Automation Logging        19.11.2009 15:08:52        Build started
Automation Logging        19.11.2009 15:08:58        Warnung bei Überprüfung von Aktivität 'ExceptionEmail': Text of message body is not specified
Automation Logging        19.11.2009 15:08:58        Build Completed
Automation Logging        19.11.2009 15:08:58        Connecting to LOGI_LS (ELIX)
Automation Logging        19.11.2009 15:08:58        Connection successful.
Automation Logging        19.11.2009 15:08:58        Running export template C:\Dokumente und Einstellungen\MRink\Desktop\sdg.txp
Statusbar        19.11.2009 17:27:47        Export Finished [11], errors detected, click <link> for summary.
Automation Logging        19.11.2009 17:27:47        Attempted export 450204 rows.
Automation Logging        19.11.2009 17:27:47        Successfully exported 450203 rows.
Automation Logging        19.11.2009 17:27:47        Export Finished, click <link> to view file.
Automation Logging        19.11.2009 17:27:47        Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
Automation Logging        19.11.2009 17:27:47        Start error email
Automation Logging        19.11.2009 17:27:47        Failed
---------------------------------------------------------------------------------------
Please note:
There is a slight difference between "Attempted export..." and "Successfully exported..." number of rows. Possibly caused by the exceptions.

Second <link> was:
ToadExport2009-11-19 15-08-59.xlsx, which i cant found on my machine (hasn't been written, apparently).


The log first <link> itself looks like the exception occured after successfully exporting:
---------------------------------------------------------------------------------------
Export Started [19.11.2009 15:08:58]
Export Wizard: Building object list
Exporting Data
Object SQL Query started.
InternalReadBackground - start
InternalReadBackground - after ExecuteReader - command SELECT * FROM ELIX.SDGACCESS_tod_fp where vdid in (select * from elix.ids) and edid in (select * from elix.ids) and borddat between '2009-10-01 00:00:00.0000' and '2009-11-01 00:00:00.0000' with ur
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows5000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 5000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows10000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 10000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows15000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 15000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows20000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 20000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows25000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 25000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows30000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 30000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows35000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 35000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows40000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 40000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows45000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 45000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows50000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 50000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows55000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 55000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows60000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 60000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows65000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 65000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows70000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 70000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows75000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 75000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows80000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 80000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows85000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 85000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows90000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 90000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows95000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 95000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows100000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 100000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows105000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 105000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows110000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 110000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows115000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 115000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows120000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 120000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows125000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 125000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows130000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 130000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows135000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 135000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows140000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 140000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows145000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 145000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows150000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 150000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows155000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 155000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows160000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 160000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows165000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 165000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows170000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 170000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows175000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 175000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows180000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 180000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows185000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 185000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows190000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 190000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows195000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 195000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows200000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 200000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows205000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 205000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows210000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 210000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows215000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 215000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows220000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 220000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows225000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 225000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows230000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 230000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows235000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 235000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows240000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 240000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows245000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 245000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows250000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 250000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows255000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 255000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows260000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 260000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows265000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 265000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows270000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 270000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows275000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 275000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows280000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 280000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows285000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 285000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows290000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 290000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows295000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 295000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows300000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 300000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows305000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 305000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows310000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 310000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows315000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 315000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows320000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 320000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows325000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 325000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows330000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 330000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows335000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 335000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows340000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 340000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows345000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 345000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows350000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 350000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows355000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 355000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows360000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 360000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows365000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 365000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows370000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 370000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows375000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 375000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows380000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 380000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows385000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 385000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows390000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 390000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows395000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 395000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows400000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 400000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows405000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 405000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows410000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 410000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows415000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 415000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows420000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 420000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows425000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 425000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows430000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 430000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows435000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 435000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows440000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 440000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows445000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 445000
InternalReadBackground - after RaisePausingRead
InternalReadBackground - before Wait()
PausingReadThreadWriter after WriteRows - Cancel False
PausingReadThreadWriter finally - Read Rows450000
PausingReadThreadWriter finally - CancelTableWrite False
PausingReadThreadWriter finally - adapter.RowsRead 450000
InternalReadBackground - exception ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in  Process: 5120 Thread 52 AppDomain: Name:Toad.exe
Keine Kontextrichtlinien vorhanden.
 Function: DB2DataReader.Read()
 CallStack:    bei System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   bei System.Environment.get_StackTrace()
   bei IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception exception, Boolean bThrow)
   bei IBM.Data.DB2.DB2DataReader.Read()
   bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
   bei Quest.Toad.Db.ToadDataAdapter.InternalFillBackground()
   bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   bei System.Threading.ExecutionContext.runTryCode(Object userData)
   bei System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   bei System.Threading.ThreadHelper.ThreadStart() InnerException Message: Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst. Check InnerException property for more detail.  SQLSTATE=58005
InternalReadBackground - stack    bei IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception exception, Boolean bThrow)
   bei IBM.Data.DB2.DB2DataReader.Read()
   bei Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
DoneReadTreadWriter
User cancelled
DoneReadThreadWriter finally - adapter.RowsRead 453151
Object SQL Query finished with error: Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
   bei System.Collections.Generic.List`1.ToArray()
   bei System.RuntimeType.GetPropertyCandidates(String name, BindingFlags bindingAttr, Type[] types, Boolean allowPrefixLookup)
   bei System.RuntimeType.GetPropertyImpl(String name, BindingFlags bindingAttr, Binder binder, Type returnType, Type[] types, ParameterModifier[] modifiers)
   bei System.Type.GetProperty(String name)
   bei Quest.Toad.ImportExport.Writers.WriterExcel.WriteRow(Object row)
   bei Quest.Toad.ImportExport.Writers.WriterBase.WriteRows(FastTable fastTable)
   bei Quest.Toad.ImportExport.ExportObjectData.DoneReadThreadWriter()
Export Finished [19.11.2009 17:27:47]
---------------------------------------------------------------------------------------
SDGACCESS_TOD_FP is a view.


Afterwards i got four exception windows raised:
---------------------------------------------------------------------------------------
System.OutOfMemoryException
Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
Stack Trace:
   bei System.Windows.Forms.Control.ThreadMethodEntry..ctor(Control caller, Delegate method, Object[] args, Boolean synchronous, ExecutionContext executionContext)
   bei System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
   bei System.Windows.Forms.Control.BeginInvoke(Delegate method, Object[] args)
   bei Quest.Toad.Util.Global.BeginInvoke(Delegate handler, Object[] args)
   bei Quest.Toad.VersionControl.RepositoryManager.ResumeNotifications()
   bei Quest.Toad.VersionControl.Actions.UpdateStatusIdle(BarItem item)
---------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------
System.OutOfMemoryException
Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
Stack Trace:
   bei System.String.ToCharArray()
   bei System.Text.Encoding.GetBytes(String s)
   bei Quest.Toad.Util.Global.EncodedHash(String str)
   bei Quest.Toad.Settings.TrlContextCollection.Trl2Path(ITrl trl)
   bei Quest.Toad.Settings.FilterContextCollection.get_Item(ITrl trl)
   bei Quest.Toad.Dov.TableDataViewControl.DefineFilterIdle(BarItem item)
---------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------
System.OutOfMemoryException
Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
Stack Trace:
   bei Quest.Toad.Util.DevExpressBarMessageFilterHack.ToadBarManagerMessageFilter.System.Windows.Forms.IMessageFilter.PreFilterMessage(Message& m)
---------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------
System.OutOfMemoryException
Eine Ausnahme vom Typ "System.OutOfMemoryException" wurde ausgelöst.
Stack Trace:
   bei System.RuntimeType.RuntimeTypeCache.MemberInfoCache`1.AddMethod(RuntimeTypeHandle declaringType, RuntimeMethodHandle method, CacheType cacheType)
   bei System.RuntimeType.RuntimeTypeCache.GetMethod(RuntimeTypeHandle declaringType, RuntimeMethodHandle method)
   bei System.RuntimeType.GetMethodBase(RuntimeTypeHandle reflectedTypeHandle, RuntimeMethodHandle methodHandle)
   bei System.Delegate.DynamicInvokeImpl(Object[] args)
   bei System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   bei System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   bei System.Threading.ExecutionContext.runTryCode(Object userData)
   bei System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   bei System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   bei System.Windows.Forms.Control.InvokeMarshaledCallbacks()
---------------------------------------------------------------------------------------

Attached are the automation script, the export script and the automation log as well as the exception log.

Hope this helps :)

regards
Marc


IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.

4 of 4 File(s)


Reply | Forward | Messages in this Topic (4)
#3012 From: "el28787" <john.enevoldson@...>
Date: Fri Nov 20, 2009 8:07 am
Subject: Re: code completion slow if schema not added 		el28787
Offline Offline
Send Email Send Email
  
Hi,

I don't think the query should be as slow as it seems to be. Perhpas you could
review this.

Regards,

John.


--- In toaddb2beta@yahoogroups.com, Henrik Johnson <Henrik.Johnson@...> wrote:
>
> The reason for this is that when you preface the schema we don't have to look
up available schemas. When you don't prefix with the schema we also need to get
the list of schemas and I am guessing this query is slow.
>
> /Mauritz
> Quest Software
> From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On
Behalf Of el28787
> Sent: Wednesday, November 18, 2009 22:18
> To: toaddb2beta@yahoogroups.com
> Subject: [toaddb2beta] code completion slow if schema not added
>
>
>
> Hi,
> We note that code completion is very slow if schema is not coded:
>
> select ftg,fok
> from pxx.xprm ctrl+.
>
> responds very quickly with the list of possible hits, whereas:
>
> select ftg,fok
> from xprm ctrl+.
>
> takes ages to respond.
>
> Regards,
> John.
>

Reply | Forward | Messages in this Topic (3)
#3011 From: marc_rink@...
Date: Fri Nov 20, 2009 7:36 am
Subject: Rebinding Packages 		docjones999
Offline Offline
Send Email Send Email
 

Heyas,

while rebinding a bunch of packages i got the following error:



Can't really say if thats an toad related issue.

regards
Marc

IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.

Reply | Forward | Messages in this Topic (1)
#3010 From: Henrik Johnson <Henrik.Johnson@...>
Date: Thu Nov 19, 2009 7:42 am
Subject: RE: code completion slow if schema not added 		hpj_globecom_se
Online Now Online Now
Send Email Send Email
 

The reason for this is that when you preface the schema we don't have to look up available schemas. When you don't prefix with the schema we also need to get the list of schemas and I am guessing this query is slow.

 

/Mauritz

Quest Software

From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On Behalf Of el28787
Sent: Wednesday, November 18, 2009 22:18
To: toaddb2beta@yahoogroups.com
Subject: [toaddb2beta] code completion slow if schema not added

 

 

Hi,
We note that code completion is very slow if schema is not coded:

select ftg,fok
from pxx.xprm ctrl+.

responds very quickly with the list of possible hits, whereas:

select ftg,fok
from xprm ctrl+.

takes ages to respond.

Regards,
John.


Reply | Forward | Messages in this Topic (3)
#3009 From: "el28787" <john.enevoldson@...>
Date: Thu Nov 19, 2009 6:17 am
Subject: code completion slow if schema not added 		el28787
Offline Offline
Send Email Send Email
  
Hi,
We note that code completion is very slow if schema is not coded:

select ftg,fok
from pxx.xprm ctrl+.

responds very quickly with the list of possible hits, whereas:

select ftg,fok
from xprm ctrl+.

takes ages to respond.

Regards,
John.

Reply | Forward | Messages in this Topic (3)
#3008 From: "el28787" <john.enevoldson@...>
Date: Thu Nov 19, 2009 5:38 am
Subject: view object at cursor 		el28787
Offline Offline
Send Email Send Email
  
Hi,
According to "known issues" view object at cursor doesn't show stored procedures
or functions (CR#164917). This appears incorrect - I seem to get details for
both these object types.
Are there plans to add row and cursor data types to this function ? it would be
very useful from a Developers point of view to easily see the component items in
a row or cursor type.
Regards,
John.

Reply | Forward | Messages in this Topic (2)
#3007 From: Nancy Alsip <nancy.alsip@...>
Date: Wed Nov 18, 2009 3:15 pm
Subject: RE: dbms_output 		nalsip
Offline Offline
Send Email Send Email
 

John,

We have a request on file (cr 57,791)  to support SET SERVEROUTPUT within procedures.  It is currently scheduled for our next release.  

Thanks,

Nancy

 

From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On Behalf Of el28787
Sent: Wednesday, November 18, 2009 12:51 AM
To: toaddb2beta@yahoogroups.com
Subject: [toaddb2beta] dbms_output

 

 

Hi,
It would be nice to see the dbms_output supported (SET SERVEROUTPUT ON) when executing a stored procedure. Any plans to add this ?
Regards,
John.


Reply | Forward | Messages in this Topic (2)
#3006 From: "el28787" <john.enevoldson@...>
Date: Wed Nov 18, 2009 6:51 am
Subject: dbms_output 		el28787
Offline Offline
Send Email Send Email
  
Hi,
It would be nice to see the dbms_output supported (SET SERVEROUTPUT ON) when
executing a stored procedure. Any plans to add this ?
Regards,
John.

Reply | Forward | Messages in this Topic (2)
#3005 From: "jeff_podlasek" <Jeff.Podlasek@...>
Date: Tue Nov 17, 2009 10:03 pm
Subject: Re: Table creation wizard 		jeff_podlasek
Offline Offline
Send Email Send Email
  
Marc
We recreated the issue and have created CR 68811 to track this.
thanks

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Heyas,
>
> the table creation wizard supports user defined types as column
> definition, which isn't supported (according to IBM documentation here:
>
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.r\
ef.doc/doc/r0000927.html
> )
>
> CREATE TABLE "MISC".PAL_ARRAY (
>   line_no       BIGINT,
>   line_ar       "MISC"."LINE"
> );
>
> MISC.LINE has been defined as INTEGER ARRAY[].
>
> regards
> Marc
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet:    http://www.ids-logistik.de
> E-Mail:      marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ------------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>

Reply | Forward | Messages in this Topic (3)
#3004 From: "jeff_podlasek" <Jeff.Podlasek@...>
Date: Tue Nov 17, 2009 7:51 pm
Subject: Toad for DB2 4.5.2 is now GA 		jeff_podlasek
Offline Offline
Send Email Send Email
  
We are happy to announce the latest release of Toad for DB2 4.5.2.
To view release notes and download the release see:
http://toadsoft.com/toaddb2/db2_landing.htm

Reply | Forward | Messages in this Topic (1)
#3003 From: "jeff_podlasek" <Jeff.Podlasek@...>
Date: Tue Nov 17, 2009 1:49 pm
Subject: Re: Table creation wizard 		jeff_podlasek
Offline Offline
Send Email Send Email
  
Marc
Thanks for the informaiton. We will investigate this.

--- In toaddb2beta@yahoogroups.com, marc_rink@... wrote:
>
> Heyas,
>
> the table creation wizard supports user defined types as column
> definition, which isn't supported (according to IBM documentation here:
>
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.r\
ef.doc/doc/r0000927.html
> )
>
> CREATE TABLE "MISC".PAL_ARRAY (
>   line_no       BIGINT,
>   line_ar       "MISC"."LINE"
> );
>
> MISC.LINE has been defined as INTEGER ARRAY[].
>
> regards
> Marc
>
> IDS Logistik GmbH
> Marc Rink
> - Software Development Manager -
> Saaläckerstrasse 8
> 63801 Kleinostheim
>
> Tel: +49(6027)40903-13
> Fax: +49(6027)40903-9013
> MOB: +49(170)9672528
>
> Internet:    http://www.ids-logistik.de
> E-Mail:      marc_rink@...
>
> Sitz der Gesellschaft: Kleinostheim
> Amtsgericht Aschaffenburg - HRB 10253
> Geschäftsführer: Dr. Michael Bargl
> Vorsitzender des Beirates: Mathias Krage
>
> ------------------------------------------------------------
> "Computer games don't affect kids. I mean if Pac-Man affected us as kids,
> we'd all be running around in darkened rooms, munching magic pills and
> listening to repetitive electronic music."
> --Kristian Wilson, Nintendo 1989.
>

Reply | Forward | Messages in this Topic (3)
#3002 From: marc_rink@...
Date: Tue Nov 17, 2009 11:41 am
Subject: Table creation wizard 		docjones999
Offline Offline
Send Email Send Email
 

Heyas,

the table creation wizard supports user defined types as column definition, which isn't supported (according to IBM documentation here: http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000927.html)

CREATE TABLE "MISC".PAL_ARRAY (
  line_no        BIGINT,
  line_ar        "MISC"."LINE"
);

MISC.LINE has been defined as INTEGER ARRAY[].

regards
Marc

IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.

Reply | Forward | Messages in this Topic (3)
#3001 From: "jeff_podlasek" <Jeff.Podlasek@...>
Date: Mon Nov 16, 2009 10:22 pm
Subject: The Toad for DB2 4.6.0 Beta has started 		jeff_podlasek
Offline Offline
Send Email Send Email
  
We have started the Toad for DB2 4.6 Beta program.
You can get information on the beta, read the beta release notes and download
the beta installer from:
http://www.toadsoft.com/toaddb2/toaddb2beta.html

Reply | Forward | Messages in this Topic (1)
#3000 From: "toadbeta" <jim.wankowski@...>
Date: Fri Sep 18, 2009 8:58 pm
Subject: Toad for DB2 4.5.1 is now GA 		toadbeta
Offline Offline
Send Email Send Email
 

We are happy to announce the availability of the latest release of Toad for DB2 4.5.1.  To download a trial copy please go to:

http://toadsoft.com/toaddb2/

 

 


Reply | Forward | Messages in this Topic (1)
#2999 From: Jeff Positano <jeff.positano@...>
Date: Tue Sep 15, 2009 12:09 am
Subject: RE: How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT 		questdev_jmp
Offline Offline
Send Email Send Email
 

Padma –

 

Could you send a screen shot of the entry for the database and the node from the Toad command prompt?.  Also, can you try connecting to the database from the Toad command prompt?

 

Thank you

Jeff

 

 

 

From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On Behalf Of Padma Addagada
Sent: Monday, September 14, 2009 4:16 PM
To: toaddb2beta@yahoogroups.com
Subject: RE: [toaddb2beta] How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT

 

 

I used toad's configuration wizard. I tried both server and server_encrypt. no luck...

Padma

--- On Mon, 9/14/09, Jeff Positano <jeff.positano@...> wrote:


From: Jeff Positano <jeff.positano@...>
Subject: RE: [toaddb2beta] How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT
To: "toaddb2beta@yahoogroups.com" <toaddb2beta@yahoogroups.com>
Date: Monday, September 14, 2009, 3:50 PM

 

Did you catalog the connection with Toad’s configuration wizard, or DB2’s?

 

If DB2, catalog the connection via Toad’s configuration wizard, making sure to specify “Server Encrypt†for Authentication, and see if that corrects the problem.

 

From: toaddb2beta@ yahoogroups. com [mailto:toaddb2beta @yahoogroups. com] On Behalf Of addagada19
Sent: Monday, September 14, 2009 1:50 PM
To: toaddb2beta@ yahoogroups. com
Subject: [toaddb2beta] How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT

 

 

Hi,

I am trying to setup a new connection using client configuration wizard.
Now on this aix server and db2 instance my authentication is server_encrypt.

db2 "get dbm cfg" | grep AUTH

gives
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER_ENCRYPT
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO

and this is my catalog command

CATALOG DATABASE TESTDB6
AS TESTDB6
AT NODE TESTL01
AUTHENTICATION SERVER_ENCRYPT
WITH 'TESTDB6 db';

When i try to connect to the database i get this error in toad. v4.5

ERROR [08001] [IBM] SQL30082N Security processing failed with reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001
This is what reason 17 means,but not sure how to relate it to my problem.

17 (UNSUPPORTED FUNCTION)
the security mechanism specified by the client is invalid for this server. Some typical examples:

* The client sent a new password value to a server that does not support the change password function.
* The client sent SERVER_ENCRYPT authentication information to a server that does not support password encryption. Authentication type catalog information must be the same at the server and the client.
* The client sent a userid (but no password) to a server that does not support authentication by userid only.
* The client has not specified an authentication type, and the server has not responded with a supported type. This might include the server returning multiple types from which the client is unable to choose.

Can anyone help with what i am doing wrong??

 


Reply | Forward | Messages in this Topic (5)
#2998 From: Jeff Positano <jeff.positano@...>
Date: Mon Sep 14, 2009 9:36 pm
Subject: RE: How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT 		questdev_jmp
Offline Offline
Send Email Send Email
 

We will investigate this further and get back to you.

 

 

From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On Behalf Of Padma Addagada
Sent: Monday, September 14, 2009 4:16 PM
To: toaddb2beta@yahoogroups.com
Subject: RE: [toaddb2beta] How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT

 

 

I used toad's configuration wizard. I tried both server and server_encrypt. no luck...

Padma

--- On Mon, 9/14/09, Jeff Positano <jeff.positano@...> wrote:


From: Jeff Positano <jeff.positano@...>
Subject: RE: [toaddb2beta] How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT
To: "toaddb2beta@yahoogroups.com" <toaddb2beta@yahoogroups.com>
Date: Monday, September 14, 2009, 3:50 PM

 

Did you catalog the connection with Toad’s configuration wizard, or DB2’s?

 

If DB2, catalog the connection via Toad’s configuration wizard, making sure to specify “Server Encrypt†for Authentication, and see if that corrects the problem.

 

From: toaddb2beta@ yahoogroups. com [mailto:toaddb2beta @yahoogroups. com] On Behalf Of addagada19
Sent: Monday, September 14, 2009 1:50 PM
To: toaddb2beta@ yahoogroups. com
Subject: [toaddb2beta] How to Setup a new connection using cc where (AUTHENTICATION) = SERVER_ENCRYPT

 

 

Hi,

I am trying to setup a new connection using client configuration wizard.
Now on this aix server and db2 instance my authentication is server_encrypt.

db2 "get dbm cfg" | grep AUTH

gives
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER_ENCRYPT
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO

and this is my catalog command

CATALOG DATABASE TESTDB6
AS TESTDB6
AT NODE TESTL01
AUTHENTICATION SERVER_ENCRYPT
WITH 'TESTDB6 db';

When i try to connect to the database i get this error in toad. v4.5

ERROR [08001] [IBM] SQL30082N Security processing failed with reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001
This is what reason 17 means,but not sure how to relate it to my problem.

17 (UNSUPPORTED FUNCTION)
the security mechanism specified by the client is invalid for this server. Some typical examples:

* The client sent a new password value to a server that does not support the change password function.
* The client sent SERVER_ENCRYPT authentication information to a server that does not support password encryption. Authentication type catalog information must be the same at the server and the client.
* The client sent a userid (but no password) to a server that does not support authentication by userid only.
* The client has not specified an authentication type, and the server has not responded with a supported type. This might include the server returning multiple types from which the client is unable to choose.

Can anyone help with what i am doing wrong??

 


Reply | Forward | Messages in this Topic (5)
Messages 2998 - 3027 of 3027   Newest  |  < Newer  |  Older >  |  Oldest
Message #
Search:
Advanced
Add to My Yahoo!      XML What's This?
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help