IDS Forum

FW: Error ID (pg_next)

Posted By: Meza, Silvana
Date: Thursday, 4 December 2003, at 11:49 a.m.

In Response To: Re: 9.30 DEMO (Andreas Breitfeld )

Can someone assist me in helping a user from iiug-esp.
She got the following errors. She did run oncheck -pcR and also got an
error(see below)

informix@fcrsix:[/usr/informix/7.31/etc] finderr 243
-243 Could not position within a table table-name.

The database server cannot set the file position to a particular row
within the file that represents a table. Check the accompanying ISAM
error code for more information. A hardware error might have occurred,
or the file might have been corrupted (truncated). Unless the ISAM
error code or an operating-system message points to another cause, run
the bcheck or secheck utility to verify file integrity.


informix@fcrsix:[/usr/informix/7.31/etc] finderr 197
-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.

Silvana


-----Original Message-----
From: Teresa Jime.... [ <mailto:mmjimen@wal-mart.com>
mailto:mmjimen@wal-mart.com]
Sent: Thursday, December 04, 2003 8:18 AM
To: iiug-esp@iiug.org
Subject: Error ID (pg_next) [198]


> Perdonen que los moleste pero tengo un problema. Estuve bajando unas
> tablas con el ipload en un ambiente de desarrollo. Las sub=ED sin ning=
=FAn
> problema pero en un programa obtuve el siguiente error:
>=20
> /users/psoft/log/PDBNOM01/PBNOM005_417363.log
>=20
> Gracias.
>=20
> PERFORM VALORES
> SQLRT: EXECUTE-STMT 65293 Informix Error
> [-243]
> ISAM Error [-197] Could not position within a table
> (sysadm.ps_genl_deduction).
> at pos 00425
> PTPSQLRT - CURSOR=3DZERO PASSED
> SQLRT: EXECUTE-STMT
> EMPLID:
> SQLRT: SQL-CONNECT 30005 Informix Error
> [-243]
> ISAM Error [-197] Could not position within a table
> (sysadm.ps_genl_deduction).
> SQLRT: SQL-CONNECT 30005 Informix Error
> [-243]
> ISAM Error [-197] Could not position within a table
> (sysadm.ps_genl_deduction).
> PTPSQLRT - CURSOR=3DZERO PASSED
> SQLRT: SQL-CONNECT
> PTPSQLRT - CURSOR=3DZERO PASSED
> SQLRT: SQL-CONNECT
> SET-RUN-STAT-ERROR(PTPUSTAT)
> DIAGNOSTICO DEL ERROR:
> SQLRT: SQL-CONNECT
> PBNOM005 did not finish at 08:03:30.16 !!!!!
>=20
> El error no explica mucho:
> uxt04 $finderr 197
> -197 ISAM error: Partition recently appended to; can't open for
> write or logging.
>=20
> If this internal error recurs, please note all circumstances and
> contact Informix Technical Support.
>=20
> Yo cheque la tabla ps_genl_deduction y la pod=EDa accesar correctamente. =
La
> borre y la volvi a regenrar.
>=20
> Se corrio un oncheck -pcR y me dio este error:
>=20
> 341708 =20
> 341709 Log file number 10 =20
> 341710 Log file flags 0x15 Log file in use
> 341711 Logfile has been
> backed up
> 341712 Log written to
> archive tap
> e =20
> 341713 Time stamp 376823957 =20
> 341714 Date/Time file filled 09/04/2003 01:40:09
> 341715 Unique identifier 7210 =20
> 341716 Physical location 0x34b035 =20
> 341717 Log size 51200 =20
> 341718 Number pages used 23 =20
> 341719 =20
> 341720 addr stamp nslots type frptr frcnt next prev
> 341721 34b035 4f695622 0 100 7fc 0 1c58 0 =20
> 341722 Log page error: invalid unique ID (pg_next). Log number 10, addr
> 0x34b035
> 341723 34b036 4f69563d 0 100 7fc 0 1c58 1
> 341724 Log page error: invalid unique ID (pg_next). Log number 10, addr
> 0x34b036
> 341725 34b037 4f69565b 0 100 7fc 0 1c58 2
> 341726 Log page error: invalid unique ID (pg_next). Log number 10, addr
> 0x34b037
> 341727 34b038 4f695676 0 100 7fc 0 1c58 3
> 341728 Log page error: invalid unique ID (pg_next). Log number 10, addr
> 0x34b038
> 341729 34b039 4f695693 0 100 7fc 0 1c58 4
> 341730 Log page error: invalid unique ID (pg_next). Log number 10, addr
> 0x34b039
> 341731 34b03a 4f6956a8 0 100 7fc 0 1c58 5
> 341732 Log page error: invalid unique ID (pg_next). Log number 10, addr
> 0x34b03a
>=20
> =BFSabes por que se origino esto? =BFSabes como se puede corregir o como =
se
> puede evitar?
>=20
Gracias.

> Ma. Teresa Jim=E9nez Nieto
> Ingenier=EDa Unix
> Servicios Administrativos Wal*mart
> Nextengo #78 , Col. Santa Cruz Acayucan
> Delegaci=F3n Azcapotzalco,M=E9xico D.F.
> Tel: 53-28-8420 =F3 53-28-3500 ext 3720
> mmjimen@wal-mart.com
>=20
> =20
>=20


**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to=20
whom they are addressed. If you have received this email
in error destroy it immediately.
**********************************************************************
Wal-Mart Stores, Inc. Confidential
**********************************************************************

Messages In This Thread

• 9.30 DEMO
  Tseng, Luke -- Thursday, 30 January 2003, at 1:58 p.m.
  • Re: 9.30 DEMO
    Andreas Breitfeld -- Friday, 31 January 2003, at 5:08 a.m.
    • RE: 9.30 DEMO
      Tseng, Luke -- Friday, 31 January 2003, at 9:54 a.m.
    • FW: Error ID (pg_next)
      Meza, Silvana -- Thursday, 4 December 2003, at 11:49 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.