<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Dear Werner,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> <o:p></o:p></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">I'm using 3 terminals with write access. Hence I'll verify the SYSPAR.PAR file as well.<o:p></o:p></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">I'll follow your steps and will let you know the results.<o:p></o:p></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> <o:p></o:p></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Appreciate your guidance.<o:p></o:p></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Anusha.<o:p></o:p></SPAN></DIV>
<DIV> <BR><BR>--- On <B>Wed, 2/23/11, Werner Hillebrecht <I><whillebrecht@mec.gov.na></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid"><BR>From: Werner Hillebrecht <whillebrecht@mec.gov.na><BR>Subject: Re: [Isis-users] Issue of suddenly increasing the file size of N01<BR>To: isis-users@iccisis.org<BR>Date: Wednesday, February 23, 2011, 1:53 AM<BR><BR>
<DIV class=plainMail>Dear Anusha, <BR><BR>I can confirm Piet's advice. I had the same problem just a week ago,<BR>noticing the huge N01 file when a backup was taking much longer than usual.<BR>It was a single corrupted record that caused the problem. When exporting the<BR>database, the export stopped at the MFN before the bad record (for example<BR>12356). By viewing the next MFN 12357, one could see that it was corrupted.<BR>After checking that the following MFN was ok, I exported the rest of the<BR>records from 12358 to the end (of course with a different filename of the<BR>ISO file). Then I created an empty copy of the database and imported the two<BR>exports. After a new indexing run, the N01 file was normal. I could then<BR>also replace the corrupted record from an earlier backup of the database.<BR>For cases like this, it is useful to keep some old backups.<BR><BR>We had another such case some years ago, when several records at different<BR>places
got corrupted and I had to export the data in six or seven batches to<BR>restore the database. In that case, we could trace the cause of the bad<BR>records to one networked computer where the SYSPAR.PAR parameter 14 was<BR>wrongly set to single-user access. There can probably be other causes, but<BR>you should better check on your network for that parameter if you have more<BR>than one terminal with writing access.<BR><BR>Werner Hillebrecht<BR>National Archives of Namibia<BR>P/Bag 13250, Windhoek, Namibia<BR>No.1 Eugene Marais Street<BR>Tel +264-61-2935211 / 5204<BR>Fax +264-61-2935217 <BR><BR><BR>-----Original Message-----<BR>From: <A href="http://us.mc353.mail.yahoo.com/mc/compose?to=isis-users-bounces@iccisis.org" ymailto="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</A> [mailto:<A href="http://us.mc353.mail.yahoo.com/mc/compose?to=isis-users-bounces@iccisis.org"
ymailto="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</A>]<BR>On Behalf Of Piet De Keyser<BR>Sent: 23 February 2011 09:14<BR>To: <A href="http://us.mc353.mail.yahoo.com/mc/compose?to=isis-users@iccisis.org" ymailto="mailto:isis-users@iccisis.org">isis-users@iccisis.org</A><BR>Subject: Re: [Isis-users] Issue of suddenly increasing the file size of N01<BR><BR>Hi Anusha,<BR><BR>I have seen this a few years ago. Try to secure your data by exporting <BR>them in small quantities (e.g. 1000 records a one time). You will crash <BR>on some bad records in doing so; skip that section. After this you need <BR>to start from a clean database. Import your data in that clean one. You <BR>could also try to fix the XRF of the database using MSTRCV2 <BR>(downlaodable from the Unesco Isis utilities site).<BR><BR>Piet de Keyser<BR>Belgium<BR><BR>Citeren Anusha Yapa <<A href="http://us.mc353.mail.yahoo.com/mc/compose?to=anusha_yapa@yahoo.com"
ymailto="mailto:anusha_yapa@yahoo.com">anusha_yapa@yahoo.com</A>>:<BR><BR>><BR>> Hello,<BR>> I?m using WinISIS version 1.5. I recently faced an issue of suddenly <BR>> increasing the file size of N01. Normally this file having size below <BR>> 10Kb. But this time it reached up to 5GB. I was tried with importing <BR>> same data to new DB. But again faced same issue. I?m having around <BR>> 30000 records.<BR>> Did anyone face similar issue.<BR>> What is the permanent solution for this.<BR>> Is this occurring due to data issue.<BR>> <BR>> Appreciate you guidance<BR>> Anusha.<BR>><BR>><BR>><BR>><BR><BR><BR>_______________________________________________<BR>isis-users mailing list<BR><A href="http://us.mc353.mail.yahoo.com/mc/compose?to=isis-users@iccisis.org" ymailto="mailto:isis-users@iccisis.org">isis-users@iccisis.org</A><BR>To manage your own subscription options go to:<BR><A
href="http://lists.iccisis.org/listinfo/isis-users" target=_blank>http://lists.iccisis.org/listinfo/isis-users</A><BR>Or contact Henk Rutten: <A href="http://us.mc353.mail.yahoo.com/mc/compose?to=hlrutten@xs4all.nl" ymailto="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</A><BR><BR><BR>_______________________________________________<BR>isis-users mailing list<BR><A href="http://us.mc353.mail.yahoo.com/mc/compose?to=isis-users@iccisis.org" ymailto="mailto:isis-users@iccisis.org">isis-users@iccisis.org</A><BR>To manage your own subscription options go to: <A href="http://lists.iccisis.org/listinfo/isis-users" target=_blank>http://lists.iccisis.org/listinfo/isis-users</A><BR>Or contact Henk Rutten: <A href="http://us.mc353.mail.yahoo.com/mc/compose?to=hlrutten@xs4all.nl" ymailto="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</A><BR></DIV></BLOCKQUOTE></td></tr></table><br>