Help needed: strange failure: QTP Program

[vamsi krishna]

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/a4e989a0/attachment-0001.html