<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=578140812-14092007><FONT face=Arial
color=#0000ff size=2>Looks to me like the UNIQUE ALTERNATE is
failing...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578140812-14092007><FONT face=Arial
color=#0000ff size=2>Hard to read here</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578140812-14092007><FONT face=Arial
color=#0000ff size=2>Maybe the Alternate index should be repeating...you know
your data.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578140812-14092007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=578140812-14092007><FONT face=Arial
color=#0000ff size=2>Ken</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <B>On
Behalf Of </B>vamsi krishna<BR><B>Sent:</B> September 14, 2007 7:57
AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Help needed:
strange failure: QTP Program<BR></FONT><BR></DIV>
<DIV></DIV>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" </BODY></HTML>