<!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.2900.3157" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009>Ron,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009>At the risk of insulting your intelligence, as I'm sure
that you've already thought of this, the bottom-line answer is actually quite
simple: you have input data that is linking to the SAME output record MULTIPLE
times. This means that you are attempting to update the same output record
more than once, causing the failure.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009>I know, because I've had the same problem in the
past.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009>You'll need to optimize your linkage and/or processing
logic somehow so that you eliminate the multiple updates - that may mean
multiple passes to the input, or utilizing different keys on the output
file.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009>Hope this helps,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=131422015-11032009>
<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 class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com] <B>On Behalf Of
</B>lorcan-computers@fsmail.net<BR><B>Sent:</B> Wednesday, March 11, 2009 10:15
AM<BR><B>To:</B> powerhouse<BR><B>Subject:</B> <BR></FONT><BR></DIV>
<DIV></DIV>
<P>Running the following QTP code on a HP3000, but keep getting the same error,
any ideas on how to get around it</P>
<P>Cheers</P>
<P> </P>
<P>Ron</P>
<P>RUN STOCKS</P>
<P>DISPLAY " ****** Program VS4002PS Version J.01.004 *******"</P>
<P>SET PROCESS LIMIT 300000<BR>SET LOCK FILE UPDATE</P>
<P>GLOBAL TEMPORARY GT-WK-END-DATE DATE<BR>GLOBAL TEMPORARY GT-WK-ST-DATE
DATE</P>
<P>REQUEST ONE</P>
<P>ACCESS PMATRL LINK PLANT-MAT-KEY TO PLANT-MAT-KEY OF MATRL-STOCK OPT</P>
<P><BR>ITEM GT-WK-END-DATE = DATE(DAYS(WK-END-DATE(13))+7)
&<BR> IF GT-WK-END-DATE = 0 ELSE GT-WK-END-DATE</P>
<P>ITEM GT-WK-ST-DATE = WK-END-DATE(13) &<BR> IF
GT-WK-ST-DATE = 0 ELSE GT-WK-ST-DATE</P>
<P>SORT ON PLANT-MAT-KEY OF PMATRL</P>
<P>OUTPUT MATRL-STOCK UPDATE ADD ON ERROR REPORT</P>
<P>ITEM PLANT-MAT-KEY OF MATRL-STOCK FINAL PLANT-MAT-KEY OF PMATRL<BR>ITEM
WK-END-DATE(1) FINAL WK-END-DATE(2)<BR>ITEM WK-RECEIVED(1) FINAL
WK-RECEIVED(2)<BR>ITEM WK-USAGE(1) FINAL WK-USAGE(2)<BR>ITEM WK-USAGE-MORTAR(1)
FINAL WK-USAGE-MORTAR(2)<BR>ITEM WK-USAGE-OTHER(1) FINAL
WK-USAGE-OTHER(2)<BR>ITEM WK-ACT-CLSTOCK(1) FINAL WK-ACT-CLSTOCK(2)<BR>ITEM
WK-END-DATE(2) FINAL WK-END-DATE(3)<BR>ITEM WK-USAGE(2) FINAL
WK-USAGE(3)<BR>ITEM WK-USAGE-MORTAR(2) FINAL WK-USAGE-MORTAR(3)<BR>ITEM
WK-USAGE-OTHER(2) FINAL WK-USAGE-OTHER(3)<BR>ITEM WK-RECEIVED(2) FINAL
WK-RECEIVED(3)<BR>ITEM WK-ACT-CLSTOCK(2) FINAL WK-ACT-CLSTOCK(3)<BR>ITEM
WK-END-DATE(3) FINAL WK-END-DATE(4)<BR>ITEM WK-USAGE(3) FINAL
WK-USAGE(4)<BR>ITEM WK-USAGE-MORTAR(3) FINAL WK-USAGE-MORTAR(4)<BR>ITEM
WK-USAGE-OTHER(3) FINAL WK-USAGE-OTHER(4)<BR>ITEM WK-RECEIVED(3) FINAL
WK-RECEIVED(4)<BR>ITEM WK-ACT-CLSTOCK(3) FINAL WK-ACT-CLSTOCK(4)<BR>ITEM
WK-END-DATE(4) FINAL WK-END-DATE(5)<BR>ITEM WK-USAGE(4) FINAL
WK-USAGE(5)<BR>ITEM WK-USAGE-MORTAR(4) FINAL WK-USAGE-MORTAR(5)<BR>ITEM
WK-USAGE-OTHER(4) FINAL WK-USAGE-OTHER(5)<BR>ITEM WK-RECEIVED(4) FINAL
WK-RECEIVED(5)<BR>ITEM WK-ACT-CLSTOCK(4) FINAL WK-ACT-CLSTOCK(5)<BR>ITEM
WK-END-DATE(5) FINAL WK-END-DATE(6)<BR>ITEM WK-USAGE(5) FINAL
WK-USAGE(6)<BR>ITEM WK-USAGE-MORTAR(5) FINAL WK-USAGE-MORTAR(6)<BR>ITEM
WK-USAGE-OTHER(5) FINAL WK-USAGE-OTHER(6)<BR>ITEM WK-RECEIVED(5) FINAL
WK-RECEIVED(6)<BR>ITEM WK-ACT-CLSTOCK(5) FINAL WK-ACT-CLSTOCK(6)<BR>ITEM
WK-END-DATE(6) FINAL WK-END-DATE(7)<BR>ITEM WK-USAGE(6) FINAL
WK-USAGE(7)<BR>ITEM WK-USAGE-MORTAR(6) FINAL WK-USAGE-MORTAR(7)<BR>ITEM
WK-USAGE-OTHER(6) FINAL WK-USAGE-OTHER(7)<BR>ITEM WK-RECEIVED(6) FINAL
WK-RECEIVED(7)<BR>ITEM WK-ACT-CLSTOCK(6) FINAL WK-ACT-CLSTOCK(7)<BR>ITEM
WK-END-DATE(7) FINAL WK-END-DATE(8)<BR>ITEM WK-USAGE(7) FINAL
WK-USAGE(8)<BR>ITEM WK-USAGE-MORTAR(7) FINAL WK-USAGE-MORTAR(8)<BR>ITEM
WK-USAGE-OTHER(7) FINAL WK-USAGE-OTHER(8)<BR>ITEM WK-RECEIVED(7) FINAL
WK-RECEIVED(8)<BR>ITEM WK-ACT-CLSTOCK(7) FINAL WK-ACT-CLSTOCK(8)<BR>ITEM
WK-END-DATE(8) FINAL WK-END-DATE(9)<BR>ITEM WK-USAGE(8) FINAL WK-USAGE
(9)<BR>ITEM WK-USAGE-MORTAR(8) FINAL WK-USAGE-MORTAR (9)<BR>ITEM
WK-USAGE-OTHER(8) FINAL WK-USAGE-OTHER (9)<BR>ITEM WK-RECEIVED(8) FINAL
WK-RECEIVED(9)<BR>ITEM WK-ACT-CLSTOCK(8) FINAL WK-ACT-CLSTOCK(9)<BR>ITEM
WK-END-DATE(9) FINAL WK-END-DATE(10)<BR>ITEM WK-USAGE(9) FINAL
WK-USAGE(10)<BR>ITEM WK-USAGE-MORTAR(9) FINAL WK-USAGE-MORTAR(10)<BR>ITEM
WK-USAGE-OTHER(9) FINAL WK-USAGE-OTHER(10)<BR>ITEM WK-RECEIVED(9) FINAL
WK-RECEIVED(10)<BR>ITEM WK-ACT-CLSTOCK(9) FINAL WK-ACT-CLSTOCK(10)<BR>ITEM
WK-END-DATE(10) FINAL WK-END-DATE(11)<BR>ITEM WK-USAGE(10) FINAL
WK-USAGE(11)<BR>ITEM WK-USAGE-MORTAR(10) FINAL WK-USAGE-MORTAR(11)<BR>ITEM
WK-USAGE-OTHER(10) FINAL WK-USAGE-OTHER(11)<BR>ITEM WK-RECEIVED(10) FINAL
WK-RECEIVED(11)<BR>ITEM WK-ACT-CLSTOCK(10) FINAL WK-ACT-CLSTOCK(11)<BR>ITEM
WK-END-DATE(11) FINAL WK-END-DATE(12)<BR>ITEM WK-USAGE(11) FINAL
WK-USAGE(12)<BR>ITEM WK-USAGE-MORTAR(11) FINAL WK-USAGE-MORTAR(12)<BR>ITEM
WK-USAGE-OTHER(11) FINAL WK-USAGE-OTHER(12)<BR>ITEM WK-RECEIVED(11) FINAL
WK-RECEIVED(12)<BR>ITEM WK-ACT-CLSTOCK(11) FINAL WK-ACT-CLSTOCK(12)<BR>ITEM
WK-END-DATE(12) FINAL WK-END-DATE(13)<BR>ITEM WK-USAGE(12) FINAL
WK-USAGE(13)<BR>ITEM WK-USAGE-MORTAR(12) FINAL WK-USAGE-MORTAR(13)<BR>ITEM
WK-USAGE-OTHER(12) FINAL WK-USAGE-OTHER(13)<BR>ITEM WK-RECEIVED(12) FINAL
WK-RECEIVED(13)<BR>ITEM WK-ACT-CLSTOCK(12) FINAL WK-ACT-CLSTOCK(13)<BR>ITEM
WK-END-DATE(13) FINAL GT-WK-END-DATE<BR>ITEM WK-USAGE(13) FINAL 0<BR>ITEM
WK-USAGE-MORTAR(13) FINAL 0<BR>ITEM WK-USAGE-OTHER(13) FINAL 0<BR>ITEM
WK-RECEIVED(13) FINAL 0<BR>ITEM WK-ACT-CLSTOCK(13) FINAL 0</P>
<P><STRONG>This is the section of the jobstream that shows the
error</STRONG></P>
<P>68 > USE VS4040PS.LVPHOUSE.EXE NOL<BR>69 VS4040PS
* Version H.01.003<BR>70 <BR>71 10/03/2009
19:14 Hanson
Aggregates
1<BR>72 <BR>73 Run:
VS4040PC<BR>74 Request: ONE<BR>75 <BR>76
<BR>77 Executing request ONE ...<BR>78
----------------------------------------------------------------------<BR>79
Record has been changed since you found
it.
]<BR>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<BR>80
File: VS-ORDER<BR>81
Linkitem:
CUST-ACNO
0118 933066<BR>82
Linkitem:
ARC-ORDNO
644 200903100007<BR>83 Linkitem:
PLANT-DAY-REF
644 20090310<BR>84 Linkitem:
VS-JOB-REF
759R<BR>85 <BR>86 Action Taken: Report and
Continue.<BR>87
----------------------------------------------------------------------<BR>88
<BR>89 Records read:<BR>90
VS-ORDER
394,902<BR>91
VS-CUST-JOB
1,306<BR>92
VS-CUST-MIX
1,285<BR>93
LATEST-MIX
42,116<BR>94 <BR>95 Transactions
processed:
1,245<BR>96 <BR>97 Records
processed:
Added Updated Unchanged
<BR>98
VS-ORDER
0 127
1,117 <BR>99 <BR>00
Finished.<BR>01 <BR>02 > EXIT<BR></P>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.
</BODY></HTML>