Re: Spurious error 197?

Posted in 2003

Rajib Sarkar — Tue, 23 Dec 2003 14:27:05 -0700 — source: Usenet: comp.databases.informix

--0__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1 Content-type: multipart/alternative; Boundary="1__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1" --1__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Malc, This error means that there were LIGHT APPENDS done on this table and t= he condition where it fails checks whether this table is created after the= last Level 0 as well. So, you will get this error if there are LIGHT APPENDS done on the table and the table was created after the Last Leve= l 0 archive. That's why once you did the Level 0 it went ahead and let you= do the write. Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = malc_p@btinternet = .com (Malc P) To: informix-list@= iiug.org Sent by: cc: = owner-informix-li Subject: Spurious error= 197? st@iiug.org = = = 12/23/2003 09:39 = AM = Please respond to = malc_p = = IDS9.30HC5, HPUX 11i, 4GL 7.20 Just had this on one of our test systems when writing to a table: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -197 ISAM error: Partition recently appended to; can't open for write or logging. If this internal error recurs, please note all circumstances and contact Technical Support at tsmail@us.ibm.com. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D .... but we haven't added any chunks or anything. Tried a checkpoint and a logical log (Oh how the immature techies laugh when you tell them you're going to force a log to see what happens. sigh.) but still got the error (both INSERT and UPDATE); it cleared when I did a level-0 to /dev/null. There are no blobs or varchars or anything nasty on the table, and no untoward messages in the online log - the instance has been up happily for the last week. Anyone seen this before? I'll raise a tech support case but they won't be that interested as the fault has cleared up. Cheers Malc = --1__=88BBE496DFE614A18f9e8a93df938690918c88BBE496DFE614A1 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Hi Malc, This error means that there were LIGHT APPENDS done on this table and t= he condition where it fails checks whether this table is created after = the last Level 0 as well. So, you will get this error if there are LIGH= T APPENDS done on the table and the table was created after the Last Le= vel 0 archive. That's why once you did the Level 0 it went ahead and l= et you do the write. Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison <img src=3D"cid:10__=3D88BBE496DFE614A18f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for malc_p@btinternet.c= om (Malc P)">malc_p@btinternet.com (Malc P) <table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel= lpadding=3D"0"> <tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D88BBE496DFE6= 14A18f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al= t=3D""> </td><td style=3D"background-image:url(cid:30__=3D88BBE496DFE614A18f9e8= a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img= src=3D"cid:20__=3D88BBE496DFE614A18f9e8a93df938@us.ibm.com" border=3D"= 0" height=3D"1" width=3D"225" alt=3D""> <ul> <ul> <ul> <ul>malc_p@btinternet.com (Malc P) Sent by: owner-informix-list@iiug.org 12/23/2003 09:39 AM Please respond to malc_p</ul> </ul> </ul> </ul> </td><td width=3D"100%"><img src=3D"cid:20__=3D88BBE496DFE614A18f9e8a93= df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> To: informix-list@iiug.org</f= ont> cc: Subject: Spurious error 197?<= /font></td></tr> </table> <tt>IDS9.30HC5, HPUX 11i, 4GL 7.20 Just had this on one of our test systems when writing to a table: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -197    ISAM error: Partition recently appended to; can't ope= n for write or logging.               &nbs= p;                   &nbsp= ;                                   =                     &= nbsp;                   &n= bsp;     If this internal error recurs, please note all circumstances and  = contact Technical Support at tsmail@us.ibm.com.   =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3

Related threads

How to get the sequence value in ESQL/C program?