Hi!

Where i can find description for follow error:

Error mxODBC.OperationalError:('S1000', -271, '[Informix][Informix ODBC Driver][Informix]Could not insert new row into the table.', 4566)

$ finderr 271
-271 Could not insert new row into the table.

This problem has many possible causes, including a locked table or a
full disk. Check the accompanying ISAM error code for more
information.

table is not locked, dbspace is half-empty, informix log is usual...

$ finderr 4566
Message number -4566 not found.

How to get description for this ISAM error message?

Tnx in advance.

Hi,
This error can be that you do not have free space or that do not satisfy a constraint. It tries to execute the sentence gave the dbaccess to see the isam error.

Gustavo.

Tnx for u replay

space in chuncks is present
$ onstat -d

Informix Dynamic Server 2000 Version 9.21.HC3 -- On-Line -- Up 31 days 03:25:57 -- 265864 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
[skiped]
cb255de8 3 0x1 3 1 N informix workdbs1
cb246e30 4 0x1 4 3 N informix workdbs2
5 active, 2047 maximum

Chunks
address chk/dbs offset size free bpages flags pathname
[skiped]
cb255598 3 3 0 500000 213022 PO- /informix/chunks/db1
cb255700 4 4 0 1000000 85 PO- /informix/chunks/db2
cb255868 5 4 0 500000 0 PO- /informix/chunks/db3
[skiped]
cb255b38 7 4 0 1000000 838840 PO- /informix/chunks/db4
7 active, 2047 maximum

/informix/chunks/db4 is practically empty...

table is very simple, without any constraint:
CREATE TABLE usd_history (
id SERIAL(1) NOT NULL,
dt DATE NOT NULL,
value FLOAT
)

oncheck -cI get no error...

i need description for ISAM error 4566. Which utilites/manuals i can see?

Hi Suguby,

The error 4566 is of ODBC not Informix.
Please test insert from dbaccess for see isam error.

dbaccess database 2>error.log <<EOF
insert into table ....
EOF

Gustavo

It look like miracle, but after dinner script begin work... %)
without any changes from my side...

May be any user block this table?... but how?... OK, will see.

Any case tnx for u assistance