Powerhouse - Allbase problem
Noack, Andreas M.
Andreas.Noack@BetzDearborn.com
Thu, 20 May 1999 06:27:59 -0400
Hallo Jeff and all,
thanks for the quick reply. The solution seems to work, but we are now
afraid of follow-up problems. Having the default "lock file" we were always
sure that no commit was done if e.g. step 1 of the QTP succeeded, but step 2
failed. The rollback then always brought back the state before the QTP. If
we now set "lock record" what will be the behaviour in this case? Can we
also trust in a rollback for both steps or are actions from step 1 already
committed? Thanks again for pointing out.
Kind regards
Andreas Noack
BetzDearborn
A division of Hercules Inc.
Development Group Europe
Tel. : +32.16.395.290
Fax : +32.16.395.368
The opinions expressed above are my very own. Due to this fact they may
change anytime without further notice.
-----Original Message-----
From: Jeff Hoffman [mailto:J.Hoffman@cchs.usyd.edu.au]
Sent: Wednesday, May 19, 1999 10:53 PM
To: POWERH-L@lists.swau.edu
Subject: RE: Powerhouse - Allbase problem
At 11:28 am 19/05/99 -0400, Byron Welch wrote:
>Andreas,
> I think the default locking strategy in QTP is set lock run so everything
>is locked for the duration of the run. I would suggest using
>SET LOCK RECORD UPDATE
I would also recommend
set file xxxxxxxx open DBmode 5 (read share)
for files accessed but not being updated.
> This should limit locking to update time and on a record by record basis.
>
>Byron Welch
>Manager In-House Programming
>Creative Computing
>Lincoln, RI
>
>-----Original Message-----
>From: Noack, Andreas M. [mailto:Andreas.Noack@BetzDearborn.com]
>Sent: Wednesday, May 19, 1999 11:07 AM
>To: 'POWERH-L@lists.swau.edu'
>Subject: FW: Powerhouse - Allbase problem
>
>
>Dear fellow users of PowerHouse,
>
>as I already pointed out in a previous mail we are currently Y2K-testing on
>HP3000/MPEiX 6.0 with Allbase G3.02 and PH819C4. We are experiencing
locking
>problems which my colleague described in a mail to Cognos. As always this
is
>urgent so I want to put the question also to this list, somebody might have
>experienced similar things already.
>
>Your help is kindly appreciated. THX in advance.
>
>Kind regards
>Andreas Noack
>Hercules BetzDearborn
>Development Group Europe
>Tel. : +32.16.395.290
>Fax : +32.16.395.368
>
>The opinions expressed above are my very own. Due to this fact they may
>change anytime without further notice.
>
>--- forwarded mail ---
>
>
>> Case :
>> I have two sessions open on the same Allbase environment and run the same
>> QTP simultaneously. I am not selecting the same record in the file. The
>> second session gives the SQL deadlock. But it seems if I do the same
thing
>> again without leaving QTP this doesn't happen. I have tried it several
>> times and with several files and each time I have the same result. Below
>> you can find the code that I used and a description of the file in SQL.
>>
>> /* This file was created with a user language environment of */
>> /* NATIVE-3000 */
>>
>>
>> CREATE PUBLIC TABLE GEN.IC_INV_HEADER
>> (PLANT_NBR SMALLINT NOT NULL,
>> IC_INV_NBR INTEGER NOT NULL,
>> SUB_CD CHAR( 1) NOT NULL,
>> CUST_NBR INTEGER NOT NULL,
>> APPL_SEQ SMALLINT NOT NULL,
>> INV_DT DATE NOT NULL,
>> INV_AMT DECIMAL(10, 2) NOT NULL,
>> SHIPM_NBR INTEGER NOT NULL,
>> NEXT_D_SEQ_NBR SMALLINT NOT NULL,
>> NEXT_C_SEQ_NBR SMALLINT NOT NULL,
>> IC_INV_STAT CHAR( 1) NOT NULL,
>> AUTO_CN_STAT CHAR( 1)
>> DEFAULT ' ' NOT NULL
>> )
>> IN DISTRFS;
>>
>> COMMIT WORK;
>>
>> CREATE UNIQUE INDEX IC_INV_KEY
>> ON GEN.IC_INV_HEADER
>> (PLANT_NBR ASC,
>> IC_INV_NBR ASC);
>>
>> COMMIT WORK;
>>
>> ------------
>>
>> NV :qtp
>>
>> Q T P (PowerHouse 8.19.C4)
>> Copyright 1999 COGNOS INCORPORATED
>> BETZ EUROPE INC
>>
>> > access ic_inv_header in haasrode
>> > choose plant_nbr 90, ic_inv_nbr parm
>> Choose viaindex IC_INV_KEY.
>> > output ic_inv_header update
>> > item auto_cn_stat final "X"
>> > go
>>
>> Executing request 1 ...
>>
>> I/C invoice nbr:: 500030
>> I/C invoice nbr::
>>
--------------------------------------------------------------------------
>> -----
>> Data access error.
>>
>> File: IC_INV_HEADER
>> Linkitem: PLANT_NBR
>> Linkitem: IC_INV_NBR 500030
>>
>> Action Taken: Run terminated.
>>
--------------------------------------------------------------------------
>> -----
>> DMS-E-DEADLOCK, A lock conflict with another process has been encountered
>> during operation 'open cursor'.
>> File: IC_INV_HEADER
>> Linkitem: PLANT_NBR
>> Linkitem: IC_INV_NBR 500030
>>
--------------------------------------------------------------------------
>> -----
>> Deadlock detected. (DBERR 14024)
>> File: IC_INV_HEADER
>> Linkitem: PLANT_NBR
>> Linkitem: IC_INV_NBR 500030
>>
--------------------------------------------------------------------------
>> -----
>> Deadlock detected. (DBERR 14024)
>> File: IC_INV_HEADER
>> Linkitem: PLANT_NBR
>> Linkitem: IC_INV_NBR 500030
>>
--------------------------------------------------------------------------
>> -----
>>
>> Records read:
>> IC_INV_HEADER 0
>>
>> Transactions processed: 0
>>
>> Records processed: Added Updated Unchanged
>> Deleted
>> IC_INV_HEADER 0 0 0
>> 0
>>
>> Finished.
>>
--------------------------------------------------------------------------
>> -----
>> Changes made since the last commit have been rolled back to a stable
>> state.
>>
>> Therefore, statistics reported may be incorrect.
>>
--------------------------------------------------------------------------
>> -----
>>
>--- end of forwarded mail ---
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
>
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
+ Jeff Hoffman + e-mail: J.Hoffman@cchs.usyd.EDU.AU
+
+ Director +
+
+ WoniCon Pty Ltd + ,-_|\
+
+ 21 Prices Circuit + voice: +61 2 9542 1527 / \
+
+ Woronora NSW 2141 + fax: +61 2 9521 3979 \_,-._*
+
+ AUSTRALIA + v
+
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.