Help needed: strange failure: QTP Program

[Ken Langendock]

Looks to me like the UNIQUE ALTERNATE is failing...
Hard to read here
Maybe the Alternate index should be repeating...you know your data.
 
Ken

  _____  

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of vamsi krishna
Sent: September 14, 2007 7:57 AM
To: powerh-l at lists.sowder.com
Subject: Help needed: strange failure: QTP Program


Hello Guys,

I've faced a real strange problem in one of the batch job failure.
Following is the QTP Log:

******************************************************************** 
* REQUEST PROCESS-SS-CREATE-SSDING                                 *
*                                                                  *
* CREATE/UPDATE OPEN ORDERS FOR SUPERSEEDING LINES                 *
******************************************************************** 
----------------------------------------------------------------------------
---
Attempt to add a duplicate value when UNIQUE KEY/INDEX was specified.
[1]
   File:  ODETADD
     Linkitem:  CUST-CODE                        041184002 
     Linkitem:  CUST-ORD                         45593
     Linkitem:  KEY-CODE
     Linkitem:  GM-PART                              13270399
     Linkitem:  CUST-ORD-AL                      45593
     Linkitem:  CUST-CODE-AL                     041184002 
     Linkitem:  LINE-ITEM-NUM                          201
     Linkitem:  GM-PART-AL                           13270399
     Linkitem:  LINE-STATUS                      5 

Action Taken: Run terminated.
----------------------------------------------------------------------------
---

Records read:
  XPWSQ2DD_SS3_S                           1
  ODET-SSDED                               1
  ODET-SSDING                              0 
  XPWIOXRF                                 0
  CREF-SSDING                              0
  CREF-SSDED                               1
  XPMIOHEA                                 1

Transactions processed:                    1

Records processed:                     Added    Updated  Unchanged
Deleted 
  ODETADD                                  0          0          0
0
  CREFADD                                  0          0          0
0
  ODETUPD                                  0          0          0
0
  ODETSSDEDUPD                             0          0          0
0 
  OXRFUPD                                  0          0          0
0
  OXRFADD                                  0          0          0
0
  XPOSQ2DD                                 0          0          0
0

Finished.
****************************************************
 THE PROCESS ./my_xback00.ksh HAS FAILED WITH STATUS 5
 IN THE COMMAND qtp XPBACKSS0 
****************************************************

The problem here is it displays " attempt to add a duplicate value when
UNIQUE KEY/INDEX was specified", when there is no corresponding index value
present in the file.


Indexes for this file is defined as follows:

-- Index Contents -- 

 ** XDET-KEY is a 49 byte  UNIQUE PRIMARY  index **


    Segment                              Type            Size  Ord  Offset
    CUST-CODE                            CHARACTER          9    A       0 
    CUST-ORD                             CHARACTER         20    A       9
    KEY-CODE                             CHARACTER          8    A      29
    GM-PART                              CHARACTER         12    A      37 


 ** XDET-ALT-KEY-1 is a 36 byte  UNIQUE ALTERNATE  index **


    Segment                              Type            Size  Ord  Offset
    CUST-ORD-AL                          CHARACTER         20    A       0 
    CUST-CODE-AL                         CHARACTER          9    A      20
    LINE-ITEM-NUM                        ZONED UNSIGNED     7    A      29


 ** XDET-ALT-KEY-2 is a 12 byte  REPEATING ALTERNATE  index ** 


    Segment                              Type            Size  Ord  Offset
    GM-PART-AL                           CHARACTER         12    A       0
 ?
2007/09/14                         copd                           Page    4 
                         R E C O R D   R E P O R T
          For DICTIONARY:  /disk1/uketddsnlp/common/dicc/copd.pdc


 ** XDET-ALT-KEY-3 is a 1 byte   REPEATING ALTERNATE  index **


    Segment                              Type            Size  Ord  Offset 
    LINE-STATUS                          CHARACTER          1    A       0



Following is the data:
> acc xpmiodet
> choose cust-code "041184002", cust-ord "45593"
Choose viaindex XDET-KEY. 
> set rep nohead
> set rep page wid 260
> rep cust-ord cust-ord key-code gm-part cust-ord-al cust-code-al
line-item-num gm-part-al line-status
> go

  45593                 45593                               13262882  45593
041184002        201      13262882  F 
  45593                 45593                               96660028  45593
041184002        700      96660028  F
Following is data in the file:

> acc xpmiodet
> choose cust-code "041184002", cust-ord "45593" 
Choose viaindex XDET-KEY.
> set rep nohead
> set rep page wid 260
> rep cust-ord cust-ord key-code gm-part cust-ord-al cust-code-al
line-item-num gm-part-al line-status
> go

  45593                 45593                               13262882  45593
041184002        201      13262882  F 
  45593                 45593                               96660028  45593
041184002        700      96660028  F


Please lemme know how could this be possible.
-- 
"Nothing is impossible as impossible itself says i m possible" 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070914/c8d94733/attachment-0001.htm