QTP rollback & commit

[Bill D Michael]

This thread is of interest because we're hitting the same type of
problems... QTP 8.20D6, Oracle 8, on VMS. We may have a batch process with
two or three multi-request QTPs, followed by some Quizes; we'll get an
Oracle "attach failure" in the middle of one of the QTPs that terminates
the request or run. Anything running after this is getting garbage, or
nothing; we can work around that part easily enough (though it will require
code & DCL changes), but since the _first_ part of the QTP(s) were
successful, our data is now in an "in between" state. With 7.10 and RMS
files, failures "mid run" were exceedingly rare (a CPU crash or running out
of disk space) - now we're getting failures several times a week, and we're
spending all our time analyzing and fixing data.

One thought we've had - subfile off the tables that are _about_ to be
changed by the process. Check for overall success of the process at the end
(preferably programmatically). If there was a failure, truncate the table
and reload it from the subfile, then try the process again. Not ideal, by
far, but it's got to be better than the current "randomly works or not"
situation! Doing a "subfile first, then if it's good, the real data" won't
work, because the subfile might work fine, then the real run still fail; we
need to validate the 'real run'.

At least we've gotten past the "a failure locks up all PH users until
fixed" problem (subdict=search) with workarounds!

Bill





"Ohmes, Matt" <Matt.Ohmes@COGNOS.com>@cube.swau.edu on 05/18/2001 09:07:10
AM

Sent by:  powerh-l-admin@cube.swau.edu



To:   powerh-l@lists.swau.edu
cc:
Subject:  RE: QTP rollback & commit


QTP is essentially a batch process without much allowance for "visual
review" before proceeding.  Once it goes, it goes.

To do what you want, I would go with Bob's suggestion on using Subfiles. In
a pre-pass, create a subfile of all the transactions you want to process.
You could do this with QTP (my personal favorite for creating subfiles) but
it might make more sense to use Quiz. Regardless, I'd produce a report in
Quiz for the subfile to let the users "visually review" it.  Then, if it
passes their review, have the users fire off the QTP pass that picks up the
subfile and use that subfile to drive the process of deleting (updating,
whatever) the processing.

Matt

Matt.Ohmes@Cognos.Com
Cognos Corporation
909 E. Las Colinas Blvd.
Suite 1900
Irving, TX  75039
214-259-6200
"Matt doesn't really know anything.  He just likes to pontificate a lot.
We refuse to acknowledge that he works for Cognos or that we have ever
met him or anyone with whom he's ever been associated.  Don't lend him
money and don't let him talk to your sister!" ;-)


-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@cognos.com]
Sent: Friday, May 18, 2001 7:51 AM
To: powerh-l@lists.swau.edu
Subject: RE: QTP rollback & commit


I don't know of any way to commit conditionally, but I'm curious as to the
requirement. I would expect that if the data is correct and the update
logic
is correct that the processing would be correct and the commit should
happen.

If it's otherwise, I'd suggest doing something with subfiles as output just
to see the process works and if so, do the real thing.

Bob Deskin
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: GGrimm@pcc-structurals.com [mailto:GGrimm@pcc-structurals.com]
Sent: Thursday, May 17, 2001 5:36 PM
To: powerh-l@lists.swau.edu
Subject: QTP rollback & commit


     I'm looking for a way to easily do a commit or a rollback in a
     dynamically run QTP based on a visual review of the run statistics for
     "reasonableness". Anybody have an idea how?  I have seen QTP do a
     rollback when "badness" happens so know there is a way:=) I've tried a
     COMMIT at RUN and then done a Ctrl Y which sometimes causes an abort
     but nothing much happened.
     (PowerHouse  8.13.D3)/Oracle 8.0.5.0.0/HP-UX B.11.00
     See my simple code:

     > access *TA_one  link to TIME_ATTEND link to TIME_ATTEND_2
     Access TIME_ATTEND viaindex TIME_ATTEND_EMPLOYEENO_1.
     Access TIME_ATTEND_2 viaindex TIME_ATTEND_2_PK.
     > output TIME_ATTEND delete
     > output TIME_ATTEND_2 delete
     > go

     Executing request 1 ...

     Records read:
       TA_ONE                    1
       TIME_ATTEND             134
       TIME_ATTEND_2           134

     Transactions processed:   134

     Records processed:      Added  Updated Unchanged  Deleted
       TIME_ATTEND               0        0         0      134
       TIME_ATTEND_2             0        0         0      134

     Finished.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.