Yet Again, QTP Failure: OUTPUT --> ADD UPDATE

[Jeff Hoffman]

Hi

Try adding the index spec into your output statement, sounds like 
attempting to add a duplicate key, as Guy suggests, have you got 2 
input records for the same key?

Jeff

At 06:39 AM 30/10/2007, you wrote:
>Content-class: urn:content-classes:message
>Content-Type: multipart/alternative;
>         boundary="----_=_NextPart_001_01C81A63.6262F1E8"
>
>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.
>
>Guy's suggestion is one possible  (and common) cause of an add 
>failure. And he's right, sending the code will help us isolate the 
>problem or at least suggest some very specific possible causes.
>
>Bob
>
>
>----------
>From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com 
>[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On 
>Behalf Of Guy Werry
>Sent: October 29, 2007 3:34 pm
>To: powerh-l at lists.sowder.com
>Subject: RE: Yet Again, QTP Failure: OUTPUT --> ADD UPDATE
>
>Vamshi,
>
>I believe that I have had a similar problem when the input phase 
>returns MORE THAN ONE record complex.
>
>It would be very helpful if you could include a screen shot of the 
>code and error.  That might make it easier to diagnose.
>
>Thanks,
>
>Guy L. Werry
>Senior Systems Analyst
>Hudson Bay Mining & Smelting Co., Limited.
>
>
>----------
>From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com 
>[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com] On 
>Behalf Of vamsi krishna
>Sent: Monday, October 29, 2007 2:12 PM
>To: powerh-l at lists.sowder.com
>Subject: Yet Again, QTP Failure: OUTPUT --> ADD UPDATE
>
>Hello All,
>
>I'd seen a case where the QTP program failed .
>It was something like
>Output xyz add update
>
>how a QTP can fail with error message "Failed to add when a Unique 
>Key/Index was specified"
>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!
>
>
>Please let me know if you if it's something else.
>
>Thanks in advance :-D
>
>Regards,
>Vamsi