FW: Powerhouse - Allbase problem

[Noack, Andreas M.]

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.