QTP 8.19C1 Bug???

John Pearce jpearce@rmi.net
Thu, 28 Jan 1999 22:36:14 -0700


I have spent more hours trying to fix a QTP problem than I care to think
about and now I believe the problem is a bug in 8.19C1 QTP.  Here's a
snippet of the code.

access *sfgla

use convtu1  ; this is a file containing a case statement to convert GL
acct numbers
             ; it's USEd by six different pieces of QTP code.  convtu1
looks like this-
             ;   temporary t-old-acct char*12
             ;   define t-new-acct char*12 = case of t-old-acct & 
             ;     when "1210" then "10110" else &  etc.

temporary t-new-dept1 char*12
temporary t-new-labor char*12

item t-old-acct = dept1 of sfgla
item t-new-dept1 = t-new-acct
item t-old-acct = labor of sfgla
item t-new-labor = t-new-acct

output gla add
item dept1 initial t-new-dept1
item labor initial t-new-labor
item pension initial "21151"

The code sample above has been used successfully to create detail sets and
automatic masters.  However it does not work correctly with with manual
masters.  In one production run, the output in GLA is literally scrambled
garbage.  The GLA file has twelve records and the data is easily
identified.  I have found parts of different records from the subfile
combined into a single record in the manual master.  Another interesting
point is that record #5 of the twelve records in GLA is ALWAYS blank.  It's
blank even if the input file is sorted.

The work around is to create a new subfile with the new data values, e.g.
subfile sfnewgla keep include t-new-dept1, t-new-labor, etc. then run a
separate request to read the subfile sfglanew and load the manual master
file gla.

Obviously, at 10 pm MST I'm not planning to call Cognos support until
tomorrow morning.  I'm curious if anyone has seen or knows about this
problem.  I've revised the code for all the manual masters since the
production conversion run will be done Friday.

Thanks.

------------------------------------------------------------------
John Pearce  <jpearce@rmi.net>       | Bethesda Management Company 
Speaking for only myself             | Colorado Springs, CO  USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.