<div>Hello Bob,</div>
<div> </div>
<div>Here's the failure extract:</div>
<div>
<p><font face="courier new,monospace"><font size="1"><strong>Attempt to add a duplicate value when UNIQUE KEY/INDEX was specified. [8182]<br> File: SPOIINP1-UPD<br> Linkitem: SPOIINP1-KEY</strong>
<font color="#ff0000">93169029301EURL</font></font></font></p>
<p><font face="courier new,monospace"><font size="1"><font color="#cc0000">Action Taken: Run terminated.<br></font><strong>-------------------------------------------------------------------------------</strong></font></font>
</p>
<p><strong><font face="courier new,monospace" size="1">Records read:<br> IPWSPRI2_S 11,613<br> SPOIINP1 5,422<br> PPMINSCP 5,596</font></strong>
</p>
<p><strong><font face="courier new,monospace" size="1">Transactions processed: 8,182<br> SPOIINP1 5,422<br> PPMINSCP 5,596</font></strong></p>
<p><strong><font face="courier new,monospace" size="1">Transactions processed: 8,182</font></strong></p>
<p><strong><font face="courier new,monospace" size="1">Records processed: Added Updated Unchanged Deleted<br> SPOIINP1-UPD 124 4,085 0 0<br> PPMINSCP-UPD 0 90 4,119 0
<br> IPWSPRI3_S 2 0 0 0</font></strong></p>
<p><strong><font face="courier new,monospace" size="1">Finished.<br></font></strong></p><br><br>And Here's the code part:</div>
<div> </div>
<div><font size="2"><font face="">
<p><br><br><font face="courier new,monospace" size="1">ACCESS *$IPWSPRI2_S LINK &<br>RJ(GM-PART) + &<br>TEMP-NSC + &<br>PRIC-LIST + &<br>CURR-CODE +&<br>OUTLET_1 TO &<br>SPOIINP1-KEY OF SPOIINP1 OPTIONAL AND &
<br>RJ(GM-PART) , &<br>TEMP-NSC , &<br>PRIC-LIST , &<br>CURR-CODE TO &<br>GM-PART , &<br>NSC-CODE , &<br>PRIC-LIST-NUM , &<br>PRIC-CURR OF PPMINSCP OPTIONAL<br><br>TEMPORARY TEMP-UNIT INTEGER * 9 SIGNED SIZE 4 BYTES
<br><br>TEMPORARY TEMP-COST INTEGER * 16 SIGNED SIZE 8 BYTES<br><br>TEMPORARY TEMP-VALU INTEGER * 16 SIGNED SIZE 8 BYTES<br><br>SORTED ON GM-PART OF IPWSPRI2_S, &<br><br>TEMP-NSC OF IPWSPRI2_S, &<br><br>PRIC-LIST OF IPWSPRI2_S, &
<br><br>CURR-CODE OF IPWSPRI2_S, &<br>OUTLET_1 OF IPWSPRI2_S</font></p>
<p><br><font face="courier new,monospace" size="1">ITEM TEMP-UNIT SUBTOTAL PART-QTY RESET AT OUTLET_1<br>ITEM TEMP-COST SUBTOTAL PLAN-PRIC RESET AT OUTLET_1 ;L0001<br>ITEM TEMP-VALU SUBTOTAL NET-AMOU-LOC RESET AT OUTLET_1 ;L0001
</font></p>
<p><br><font face="courier new,monospace" size="1">OUTPUT SPOIINP1 ADD UPDATE ALIAS SPOIINP1-UPD AT OUTLET_1 &<br>IF RECORD PPMINSCP EXIST<br>ITEM ................</font></p>
<p> </p>
<p>In the input subfile, there was only one record corresponding to Unique Key value.</p></font>
<p>But the data, which was attempted to add, it was exactly the same record which existed in the file.</p>
<p>So, Is there a possibility that it failed "while adding (unique key) +updating record with same values" ??</p>
<p>It's just a wild guess :-)</p>
<p>Let me know if you need more details</p>
<p>Regards,</p>
<p>Vamsi</p></font></div>
<div><span class="gmail_quote">On 10/30/07, <b class="gmail_sendername">Deskin, Bob</b> <<a href="mailto:Bob.Deskin@cognos.com">Bob.Deskin@cognos.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">On an ADD UPDATE, QTP attempts to retrieve during the initialization phase. If no record is retrieved, it will attempt to add during the output phase. If a record was retrieved, it will attempt to update.
</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Guy's suggestion is one possible (and common) cause of an add failure. </font></span><span><font face="Arial" color="#0000ff" size="2">And he's right, sending the code will help us isolate the problem or at least suggest some very specific possible causes.
</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Bob</font></span></div><br>
<blockquote style="MARGIN-RIGHT: 0px">
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> powerh-l-bounces+bob.deskin=<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cognos.com@lists.sowder.com" target="_blank">cognos.com@lists.sowder.com</a> [mailto:
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com" target="_blank">powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com</a>] <b>On Behalf Of
</b>Guy Werry<br><b>Sent:</b> October 29, 2007 3:34 pm<span class="q"><br><b>To:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com
</a><br></span><b>Subject:</b> RE: Yet Again, QTP Failure: OUTPUT --> ADD UPDATE<br></font><br> </div>
<div><span class="e" id="q_115ed47d71fd3293_3">
<div></div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span>Vamshi,</span></font></div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span></span></font> </div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span>I believe that I have had a similar problem when the input phase returns MORE THAN ONE record complex.</span></font></div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span></span></font> </div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span>It would be very helpful if you could include a screen shot of the code and error. That might make it easier to diagnose.</span></font></div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span></span></font> </div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span>Thanks,</span></font></div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span>
<p><font size="2">Guy L. Werry<br>Senior Systems Analyst<br>Hudson Bay Mining & Smelting Co., Limited. </font></p></span></font></div><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> powerh-l-bounces+guy.werry=<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:hbms.ca@lists.sowder.com" target="_blank">hbms.ca@lists.sowder.com</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com" target="_blank">
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com</a>] <b>On Behalf Of </b>vamsi krishna<br><b>Sent:</b> Monday, October 29, 2007 2:12 PM<br><b>To:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">
powerh-l@lists.sowder.com</a><br><b>Subject:</b> Yet Again, QTP Failure: OUTPUT --> ADD UPDATE<br></font><br> </div>
<div></div>Hello All,<br><br>I'd seen a case where the QTP program failed .<br>It was something like<br><span style="FONT-WEIGHT: bold">Output xyz add update</span><br><br>how a QTP can fail with error message "Failed to add when a Unique Key/Index was specified"
<br>What I understand from OUTPUT --->Add Update is QTP tries to add first, if the records exists, it updates the record with new values, and if this is the case, how could such a QTP Fail!<br><br><br>Please let me know if you if it's something else.
<br><br>Thanks in advance :-D<br><br>Regards, <br>Vamsi<br clear="all"><br>-- <br>"Nothing is impossible as impossible itself says i m possible" The information in this e-mail and any attachments is confidential and may be subject to legal professional privilege. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.
</span></div></blockquote></div><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com
</a><br>Subscribe: &quot;subscribe&quot; in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">
http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.<br>Add 'site:<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/" target="_blank">
lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.<br></blockquote></div><br><br clear="all"><br>-- <br>"Nothing is impossible as impossible itself says i m possible"