Focal Point
WebFocus Agent crashed

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5501064891

November 27, 2006, 03:34 PM
Viral
WebFocus Agent crashed
Hi,

I have WebFocus procedure which gets data and Hold in the tempHold file, which is around 65MB in size then use the Modify command to append to the existing focus file which is file type of XFOCUS and its current size is 2.75GB. It getting error out and Webfocus shows as Agent get crash, while I found the error log file generated in the edatemp which say "Assertion failed: !pagexIsDelRecord(page, recid), file P:\R720711B\source\xfnxtx.c, line 90
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information."

If anybody came across this kind of scenario pls. let me know what is the solution or why I am getting suddenly this error, since it was working before.

I am using WF 7.1.1 and OS WINDOWS 2003.


WF 7.6.2/ OS WIN2003.
DM 7.6.2
November 27, 2006, 04:29 PM
Carol Dobson
Not sure why you're getting this error or what's on line 90.....

One thing you can try is starting and stopping the modify with the START and STOP commands

MODIFY FILE FILENAME
START 1
STOP 89
modify logic here

If you can't add any records to your database, it could be corrupt. Try the

? FDT

or

? FILE filename

to see if you get any error messages.

Or try and REBUILD the file.

Good Luck!

Carol



WebFOCUS 7.6.6/TomCat/Win2k3
November 27, 2006, 06:08 PM
susannah
Viral, we're testing 716 in win2k3 and we're having wild crashing problems.
. the parameter screen launch page from mre dies if the job takes 'too long' to run.
. the server starts 2 -3 copies of the same job in new agents, if it decides that the job is taking too long.
. and the jobs that access a REMOTE server just die for no apparent reason,
What you're seeing may be related. Have you opened a case? you'll have to do a TRACE.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
November 27, 2006, 06:57 PM
Viral
Thanks for your responses.
I ran ? File filename command and it works & shows the file status, path, segment and last change timestamp. I tried to access the file as table request and it shows up data, So it may be not corrputed.
Line 90 in my code was ON MATCH DELETE command under modify command. But looks like delete was not the issue since If I run the till that portion of my fex it works. Only last portion of code where it try to append the data it fails.


WF 7.6.2/ OS WIN2003.
DM 7.6.2
November 28, 2006, 11:06 AM
Anatess
Viral,
I'm on WF 7.1.3/Win 2003 and had problems with XFOCUS modify also on a large database (~2G). What I did was to take out the INDEX from the master file description, run the modify, then added the index back to the master file description and rebuilt the indexes. This worked for me.


WF 8.1.05 Windows
December 05, 2006, 03:29 PM
Carol Dobson
If I recall correctly, the ? FDT is the one that would show a corrupted file error message showing an invalid pointer.

Sometimes when a file is corrupt, you can still report on the file but you can't modify it.



WebFOCUS 7.6.6/TomCat/Win2k3
December 13, 2006, 02:49 PM
Viral
Hi All,

Sorry to give late update. I tried the index option didn't worked. Repopluatin the foc file work. Look like my focus file was corrputed.

Thanks again for you feedback.


WF 7.6.2/ OS WIN2003.
DM 7.6.2
December 13, 2006, 03:10 PM
Carol Dobson
Sometimes with a corrupted file, you can report against the file but not modify the file.
Try using TABLE to get the data out and into a HOLD file, then try to reload a brand new file.

Good Luck!



WebFOCUS 7.6.6/TomCat/Win2k3