Error while executing QTP - Memory fault (invalid address).
Joe Boyle
atla38 at dsl.pipex.com
Wed Dec 14 08:08:51 CST 2005
I'm wondering if the linking syntax might be part of the problem. So why not
try using the original code but simplified as below, and allow qtp to make
its own defaults. The compiler should tell you what they are, so if they
match what you need and assuming the subsequent code works, it might solve
the problem,
access *$UEV_SUBFILE_PATH\CW620SF4 &
link to COW_D IN CWDB and to COW_LOC_D IN CWDB
Regards, Joe.
-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Joe Boyle
Sent: 14 December 2005 13:41
To: 'Syed Shahul Hameed Mustaffa'
Cc: 'PowerHouse List'
Subject: RE: Error while executing QTP - Memory fault (invalid address).
Unfortunately you have made two changes in one leap, so it is difficult to
know which has enabled the program to work,
You went from this and CLD_COMPUTER_NO OF CW620SF4 to
&
directly to this link CLD_COMPUTER_NO OF COW_LOC_D to
&
are both changes required ? if not, take them one at a time.
The main difference between 'and to' and 'link to' is that the former will
retrieve the named records either side of the 'and ' in parallel, and the
latter will retrieve the record after the 'link to' only if the record
before the 'link to' actually exists.
Usually parallel linkage is optional, so either record will be retrieved
independently of whether the other exists or not. But I don't recall if you
need an optional statement, or if one is assumed; you will have to make
tests and choose the option that gives you what you need.
Regards, Joe.
________________________________________
From: Syed Shahul Hameed Mustaffa [mailto:sshahulgm at gmail.com]
Sent: 14 December 2005 12:54
To: Joe Boyle
Cc: PowerHouse List
Subject: Re: Error while executing QTP - Memory fault (invalid address).
Dear Joe,
The code seems to work when I changed the following
access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &
CLD_COMPUTER_NO of COW_LOC_D IN CWDB &
and CLD_COMPUTER_NO OF CW620SF4 to &
CLD_COMPUTER_NO of COW_D IN CWDB
to
access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &
CLD_COMPUTER_NO of COW_LOC_D IN CWDB &
link CLD_COMPUTER_NO OF COW_LOC_D to &
CLD_COMPUTER_NO of COW_D IN CWDB
The original code was
access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &
CLD_COMPUTER_NO of COW_D IN CWDB &
and CLD_COMPUTER_NO to &
CLD_COMPUTER_NO of COW_LOC_D IN CWDB
I re-wrote it as the former.
Please advise me if the change will cause any problems.
Regards,
SYED.
On 12/14/05, Joe Boyle <atla38 at dsl.pipex.com> wrote:
I just noticed that while your QTP output states,
The permanent subfile will be overwritten.
File: $UEV_SUBFILE_PATH\CW620SF8
your QTP code is no longer referencing subfile $UEV_SUBFILE_PATH\CW620SF8.
It might be worth a recompile before you go any further.
Regards, Joe.
-----Original Message-----
From: powerh-l-bounces+atla38= dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com ] On Behalf
Of
Joe Boyle
Sent: 14 December 2005 09:26
To: 'Syed Shahul Hameed Mustaffa'
Cc: 'PowerHouse List'
Subject: RE: Error while executing QTP - Memory fault (invalid address).
Well in that case, and assuming that there are no other subfile components
lying around with different default column sizes, and assuming that the
qshow commands below don't show any mismatch, I would have to say it's
likely to be a bug and you should contact Cognos Support for a fixed RBF.
Qshow
>Show sub $UEV_SUBFILE_PATH\CW620SF4
>Show sub $UEV_SUBFILE_PATH\CW620SF8
>exit
If the file layouts from the commands above match the layout of your tables,
and the field sizes are large enough to take the table contents,
You could try quiz using syntax below, to see if quiz gives the same
problem, having first deleted all $UEV_SUBFILE_PATH\CW620SF8* files,
Acc * $UEV_SUBFILE_PATH\CW620SF4
Set sub name $UEV_SUBFILE_PATH\CW620SF8 keep
Rep summ all
go
in fact it might be worth using the same approach in qtp purely to see if it
works.
Regards, Joe.
________________________________________
From: powerh-l-bounces+atla38= dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com ] On Behalf
Of
Syed Shahul Hameed Mustaffa
Sent: 14 December 2005 07:05
To: Joe Boyle
Cc: PowerHouse List
Subject: Re: Error while executing QTP - Memory fault (invalid address).
Thank you Joe for your tip.
Very sorry for misleading you.
I lately found that the following statement gives me a different error
(after I commented out most of the code)
Statement:
request FOURTH-PASS on calculation errors report
set lock file request
access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &
CLD_COMPUTER_NO of COW_D IN CWDB &
and CLD_COMPUTER_NO to &
CLD_COMPUTER_NO of COW_LOC_D IN CWDB
output COW_D IN CWDB update
item CM_MOVED_LDATE = T_DATE
Error:
Executing request FOURTH-PASS ...
----------------------------------------------------------------------------
---
The permanent subfile will be overwritten.
File: $UEV_SUBFILE_PATH\CW620SF8
----------------------------------------------------------------------------
---
Variable size mismatch. key column #2
[1]
File: COW_D
Linkitem: CLD_COMPUTER_NO 150648
Action Taken: Run terminated.
----------------------------------------------------------------------------
---
I checked the tables and field sizes. Everything seems to be ok.
What could be the problem?
Regards,
SYED
On 12/13/05, Joe Boyle < atla38 at dsl.pipex.com> wrote:
It's possible that some dodgy subfile components might be laying around and
messing things up. Try 'dir /s c:\* CW620SF8*' and delete any unexpected
subfile parts.
You will need to this for all your disks, in my experience qtp/quiz can
place these subfile parts in the strangest of places.
Regards, Joe.
-----Original Message-----
From: powerh-l-bounces+atla38= dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com ] On Behalf
Of
Joe Boyle
Sent: 13 December 2005 14:52
To: 'Syed Shahul Hameed Mustaffa'; 'PowerHouse List'
Subject: RE: Error while executing QTP - Memory fault (invalid address).
you could try using the full path, I saw a few problems like this a while
back,
subfile $UEV_SUBFILE_PATH\CW620SF8 keep include &
$UEV_SUBFILE_PATH\CW620SF4
Of course, the cynical among us ( you know who you are ) might suspect that
subfile CW620SF4 is also empty - shame on you ;)
Regards, Joe.
________________________________________
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto: powerh-l-bounces+atla38= dsl.pipex.com at lists.sowder.com] On Behalf
Of
Syed Shahul Hameed Mustaffa
Sent: 13 December 2005 14:34
To: PowerHouse List
Cc: Joe Boyle
Subject: Re: Error while executing QTP - Memory fault (invalid address).
Dear Gurus,
The following code seems to generate the error
subfile $UEV_SUBFILE_PATH\CW620SF8 keep include &
CW620SF4
The subfile CW620SF8seems to get created. But doesn't contain any data.
Any help to resolve my issue will be appreciated.
Regards,
SYED
On 12/12/05, Syed Shahul Hameed Mustaffa <sshahulgm at gmail.com > wrote:
Sorry I felt that my question didn't reach anywhere. That's why I'm
resending it.
HoweverI have something to add.
My initial judgement of code that generates the error seems to be wrong.
It is from somewhere else. If you need the code file, I can send it.
Thanks in advance.
Regards,
SYED.
On 12/12/05, Syed Shahul Hameed Mustaffa <sshahulgm at gmail.com > wrote:
Dear Gurus,
Quick Intro: I've migrated a PH/MPEIX application to AXIANT4GL/WINDOWS (Thin
Client).
When I execute a QTP, I'm getting the following error message.
;---------------------------------------------------------------------------
-------
Executing request FOURTH-PASS ...
*E* Memory fault (invalid address).
*Fatal Error* *4780* Notify Cognos Customer Support
;---------------------------------------------------------------------------
--------
The following part of the code seems to generate this error.
request FOURTH-PASS on calculation errors report
set lock file request
;access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &
; CLD_COMPUTER_NO of COW_D IN CWDB &
; and CLD_COMPUTER_NO to &
; CLD_COMPUTER_NO of COW_LOC_D IN CWDB
;---- THE ABOVE STATEMENT IS RE-WRITTEN AS ONE RIGHT BELOW BY me
access *$UEV_SUBFILE_PATH\CW620SF4 link CLD_COMPUTER_NO to &
CLD_COMPUTER_NO of COW_LOC_D IN CWDB &
and CLD_COMPUTER_NO OF CW620SF4 to &
CLD_COMPUTER_NO of COW_D IN CWDB
I'll appreciate any help to resolve this issue.
Regards,
SYED.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
More information about the powerh-l
mailing list