<div>Dear Joe,</div>
<div> </div>
<div>The code seems to work when I changed the following </div>
<div>access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &<br> CLD_COMPUTER_NO of COW_LOC_D IN CWDB & <br> and CLD_COMPUTER_NO OF CW620SF4 to &
<br> CLD_COMPUTER_NO of COW_D IN CWDB<br>to</div>
<div>access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &<br> CLD_COMPUTER_NO of COW_LOC_D IN CWDB &<br> <font color="#ff9966">link</font> CLD_COMPUTER_NO OF COW_LOC_D to &
<br> CLD_COMPUTER_NO of COW_D IN CWDB</div>
<div> </div>
<div>The original code was<br>access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &<br> CLD_COMPUTER_NO of COW_D IN CWDB &<br> and CLD_COMPUTER_NO to &
<br> CLD_COMPUTER_NO of COW_LOC_D IN CWDB<br>I re-wrote it as the former. </div>
<div>Please advise me if the change will cause any problems.</div>
<div> </div>
<div>Regards,</div>
<div>SYED.<br> </div>
<div><span class="gmail_quote">On 12/14/05, <b class="gmail_sendername">Joe Boyle</b> <<a href="mailto:atla38@dsl.pipex.com">atla38@dsl.pipex.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I just noticed that while your QTP output states,<br><br>The permanent subfile will be overwritten.<br> File: $UEV_SUBFILE_PATH\CW620SF8
<br><br>your QTP code is no longer referencing subfile $UEV_SUBFILE_PATH\CW620SF8.<br>It might be worth a recompile before you go any further.<br><br>Regards, Joe.<br><br><br>-----Original Message-----<br>From: powerh-l-bounces+atla38=
<a href="mailto:dsl.pipex.com@lists.sowder.com">dsl.pipex.com@lists.sowder.com</a><br>[mailto:<a href="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com">powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</a>
] On Behalf Of<br>Joe Boyle<br>Sent: 14 December 2005 09:26<br>To: 'Syed Shahul Hameed Mustaffa'<br>Cc: 'PowerHouse List'<br>Subject: RE: Error while executing QTP - Memory fault (invalid address).<br><br>Well in that case, and assuming that there are no other subfile components
<br>lying around with different default column sizes, and assuming that the<br>qshow commands below don't show any mismatch, I would have to say it's<br>likely to be a bug and you should contact Cognos Support for a fixed RBF.
<br><br>Qshow<br>>Show sub $UEV_SUBFILE_PATH\CW620SF4<br>>Show sub $UEV_SUBFILE_PATH\CW620SF8<br>>exit<br><br>If the file layouts from the commands above match the layout of your tables,<br>and the field sizes are large enough to take the table contents,
<br><br>You could try quiz using syntax below, to see if quiz gives the same<br>problem, having first deleted all $UEV_SUBFILE_PATH\CW620SF8* files,<br><br>Acc * $UEV_SUBFILE_PATH\CW620SF4<br>Set sub name $UEV_SUBFILE_PATH\CW620SF8 keep
<br>Rep summ all<br>go<br><br><br>in fact it might be worth using the same approach in qtp purely to see if it<br>works.<br><br><br>Regards, Joe.<br>________________________________________<br>From: powerh-l-bounces+atla38=
<a href="mailto:dsl.pipex.com@lists.sowder.com">dsl.pipex.com@lists.sowder.com</a><br>[mailto:<a href="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com">powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</a>
] On Behalf Of<br>Syed Shahul Hameed Mustaffa<br>Sent: 14 December 2005 07:05<br>To: Joe Boyle<br>Cc: PowerHouse List<br>Subject: Re: Error while executing QTP - Memory fault (invalid address).<br><br>Thank you Joe for your tip.
<br>Very sorry for misleading you.<br><br>I lately found that the following statement gives me a different error<br>(after I commented out most of the code)<br>Statement:<br>request FOURTH-PASS on calculation errors report
<br>set lock file request<br>access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &<br>CLD_COMPUTER_NO of COW_D IN CWDB &<br>and CLD_COMPUTER_NO to &<br>CLD_COMPUTER_NO of COW_LOC_D IN CWDB<br>output COW_D IN CWDB update
<br>item CM_MOVED_LDATE = T_DATE<br><br>Error:<br>Executing request FOURTH-PASS ...<br>----------------------------------------------------------------------------<br>---<br>The permanent subfile will be overwritten.<br>File: $UEV_SUBFILE_PATH\CW620SF8
<br>----------------------------------------------------------------------------<br>---<br>Variable size mismatch. key column #2<br>[1]<br>File: COW_D<br>Linkitem: CLD_COMPUTER_NO 150648<br>Action Taken: Run terminated.<br>
----------------------------------------------------------------------------<br>---<br>I checked the tables and field sizes. Everything seems to be ok.<br>What could be the problem?<br>Regards,<br>SYED<br>On 12/13/05, Joe Boyle <
<a href="mailto:atla38@dsl.pipex.com">atla38@dsl.pipex.com</a>> wrote:<br>It's possible that some dodgy subfile components might be laying around and<br>messing things up. Try 'dir /s c:\* CW620SF8*' and delete any unexpected
<br>subfile parts.<br><br>You will need to this for all your disks, in my experience qtp/quiz can<br>place these subfile parts in the strangest of places.<br><br>Regards, Joe.<br><br><br>-----Original Message-----<br>From: powerh-l-bounces+atla38=
<a href="mailto:dsl.pipex.com@lists.sowder.com">dsl.pipex.com@lists.sowder.com</a><br>[mailto:<a href="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com">powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</a>
] On Behalf<br>Of<br>Joe Boyle<br>Sent: 13 December 2005 14:52<br>To: 'Syed Shahul Hameed Mustaffa'; 'PowerHouse List'<br>Subject: RE: Error while executing QTP - Memory fault (invalid address).<br><br>you could try using the full path, I saw a few problems like this a while
<br>back,<br><br>subfile $UEV_SUBFILE_PATH\CW620SF8 keep include &<br>$UEV_SUBFILE_PATH\CW620SF4<br><br>Of course, the cynical among us ( you know who you are ) might suspect that<br>subfile CW620SF4 is also empty - shame on you ;)
<br><br>Regards, Joe.<br>________________________________________<br>From: powerh-l-bounces+atla38=<a href="mailto:dsl.pipex.com@lists.sowder.com">dsl.pipex.com@lists.sowder.com</a><br>[mailto: powerh-l-bounces+atla38=<a href="mailto:dsl.pipex.com@lists.sowder.com">
dsl.pipex.com@lists.sowder.com</a>] On Behalf<br>Of<br>Syed Shahul Hameed Mustaffa<br>Sent: 13 December 2005 14:34<br>To: PowerHouse List<br>Cc: Joe Boyle<br>Subject: Re: Error while executing QTP - Memory fault (invalid address).
<br><br>Dear Gurus,<br><br>The following code seems to generate the error<br><br>subfile $UEV_SUBFILE_PATH\CW620SF8 keep include &<br>CW620SF4<br><br>The subfile CW620SF8seems to get created. But doesn't contain any data.
<br><br>Any help to resolve my issue will be appreciated.<br>Regards,<br>SYED<br><br><br>On 12/12/05, Syed Shahul Hameed Mustaffa <<a href="mailto:sshahulgm@gmail.com">sshahulgm@gmail.com</a> > wrote:<br>Sorry I felt that my question didn't reach anywhere. That's why I'm
<br>resending it.<br>HoweverI have something to add.<br><br>My initial judgement of code that generates the error seems to be wrong.<br><br>It is from somewhere else. If you need the code file, I can send it.<br><br>Thanks in advance.
<br>Regards,<br>SYED.<br><br><br>On 12/12/05, Syed Shahul Hameed Mustaffa <<a href="mailto:sshahulgm@gmail.com">sshahulgm@gmail.com</a> > wrote:<br>Dear Gurus,<br><br>Quick Intro: I've migrated a PH/MPEIX application to AXIANT4GL/WINDOWS (Thin
<br><br>Client).<br><br>When I execute a QTP, I'm getting the following error message.<br>;---------------------------------------------------------------------------<br>-------<br>Executing request FOURTH-PASS ...<br>*E* Memory fault (invalid address).
<br>*Fatal Error* *4780* Notify Cognos Customer Support<br>;---------------------------------------------------------------------------<br>--------<br><br>The following part of the code seems to generate this error.<br><br>
request FOURTH-PASS on calculation errors report<br>set lock file request<br>;access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &<br>; CLD_COMPUTER_NO of COW_D IN CWDB &<br>; and CLD_COMPUTER_NO to &<br>
; CLD_COMPUTER_NO of COW_LOC_D IN CWDB<br>;---- THE ABOVE STATEMENT IS RE-WRITTEN AS ONE RIGHT BELOW BY me<br>access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &<br>CLD_COMPUTER_NO of COW_LOC_D IN CWDB &<br>
and CLD_COMPUTER_NO OF CW620SF4 to &<br>CLD_COMPUTER_NO of COW_D IN CWDB<br>I'll appreciate any help to resolve this issue.<br>Regards,<br>SYED.<br><br><br><br><br><br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com
</a><br>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to<br><a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">
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><br><br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list:
<a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
<br><a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">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><br></blockquote></div><br>