Hello Guys,<br><br>I've faced a real strange problem in one of the batch job failure.<br>Following is the QTP Log:<br><br><span style="font-family: courier new,monospace;">********************************************************************
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">* REQUEST PROCESS-SS-CREATE-SSDING *</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">* *</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
* CREATE/UPDATE OPEN ORDERS FOR SUPERSEEDING LINES *</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">********************************************************************
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">-------------------------------------------------------------------------------</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"><span style="font-weight: bold; color: rgb(204, 0, 0);">Attempt to add a duplicate value when UNIQUE KEY/INDEX was specified.</span> [1]</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> File: ODETADD</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Linkitem: CUST-CODE 041184002
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Linkitem: CUST-ORD 45593</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
Linkitem: KEY-CODE</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Linkitem: GM-PART 13270399</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> Linkitem: CUST-ORD-AL 45593</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Linkitem: CUST-CODE-AL 041184002
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Linkitem: LINE-ITEM-NUM 201</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
Linkitem: GM-PART-AL 13270399</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Linkitem: LINE-STATUS 5</span>
<br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Action Taken: Run terminated.</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">-------------------------------------------------------------------------------</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Records read:</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> XPWSQ2DD_SS3_S 1</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> ODET-SSDED 1</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> ODET-SSDING 0
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> XPWIOXRF 0</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
CREF-SSDING 0</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> CREF-SSDED 1</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> XPMIOHEA 1</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
Transactions processed: 1</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Records processed: Added Updated Unchanged Deleted
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> ODETADD 0 0 0 0</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> CREFADD 0 0 0 0</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
ODETUPD 0 0 0 0</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> ODETSSDEDUPD 0 0 0 0
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> OXRFUPD 0 0 0 0</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> OXRFADD 0 0 0 0</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
XPOSQ2DD 0 0 0 0</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
Finished.</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">****************************************************</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> THE PROCESS ./my_xback00.ksh HAS FAILED WITH STATUS 5</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> IN THE COMMAND qtp XPBACKSS0
</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">****************************************************</span><br><br>The problem here is it displays "<span style="font-family: courier new,monospace;">
attempt to add a duplicate value when UNIQUE KEY/INDEX was specified", when there is no corresponding index value present in the file.<br><br><br>Indexes for this file is defined as follows:<br><br>-- Index Contents --
<br><br> ** XDET-KEY is a 49 byte UNIQUE PRIMARY index **<br><br><br> Segment Type Size Ord Offset<br> CUST-CODE CHARACTER 9 A 0
<br> CUST-ORD CHARACTER 20 A 9<br> KEY-CODE CHARACTER 8 A 29<br> GM-PART CHARACTER 12 A 37
<br><br><br> ** XDET-ALT-KEY-1 is a 36 byte UNIQUE ALTERNATE index **<br><br><br> Segment Type Size Ord Offset<br> CUST-ORD-AL CHARACTER 20 A 0
<br> CUST-CODE-AL CHARACTER 9 A 20<br> LINE-ITEM-NUM ZONED UNSIGNED 7 A 29<br><br><br> ** XDET-ALT-KEY-2 is a 12 byte REPEATING ALTERNATE index **
<br><br><br> Segment Type Size Ord Offset<br> GM-PART-AL CHARACTER 12 A 0<br> ?<br>2007/09/14 copd Page 4
<br> R E C O R D R E P O R T<br> For DICTIONARY: /disk1/uketddsnlp/common/dicc/copd.pdc<br><br><br> ** XDET-ALT-KEY-3 is a 1 byte REPEATING ALTERNATE index **<br><br><br> Segment Type Size Ord Offset
<br> LINE-STATUS CHARACTER 1 A 0<br><br><br><br>Following is the data:<br>> acc xpmiodet<br>> choose cust-code "041184002", cust-ord "45593"<br>Choose viaindex XDET-KEY.
<br>> set rep nohead<br>> set rep page wid 260<br>> rep cust-ord cust-ord key-code gm-part cust-ord-al cust-code-al line-item-num gm-part-al line-status<br>> go<br><br> 45593 45593 13262882 45593 041184002 201 13262882 F
<br> 45593 45593 96660028 45593 041184002 700 96660028 F<br>Following is data in the file:<br><br>> acc xpmiodet<br>> choose cust-code "041184002", cust-ord "45593"
<br>Choose viaindex XDET-KEY.<br>> set rep nohead<br>> set rep page wid 260<br>> rep cust-ord cust-ord key-code gm-part cust-ord-al cust-code-al line-item-num gm-part-al line-status<br>> go<br><br> 45593 45593 13262882 45593 041184002 201 13262882 F
<br> 45593 45593 96660028 45593 041184002 700 96660028 F<br></span><br><br>Please lemme know how could this be possible.<br>-- <br>"Nothing is impossible as impossible itself says i m possible"