Hi Everybody:

Certainly I'm so worried about the error 2426 (bdb_errno 520). could someone help me to decipher what this means?

I hope their answer, and as always... Thanks in advance.


Best regards.

Germán Bernal

The manual describes DB error 520 as:

"This occurs when flushing of buffered updates fails. The flushing can fails due to a lock or to a referential integrity constraint."

So, locks or reference issues most likely. What are you trying to do?

Hi German,

From your profile you are using oracle as a database. So by deducting 1000 from the baan error number, you get the oracle error, ORA 1426.

On unix you can type "oerr ORA 1426" to get an explanation or search on metalink for it. The above command will give you:

> oerr ORA 1426
01426, 00000, "numeric overflow"
// *Cause: Evaluation of an value expression causes an overflow/underflow.
// *Action: Reduce the operands.

It basically means, that Baan tried to write a value into a table field, which did not fit to the datatype of the field.

If you look into log.ora.sql in $BSE/log, you should see the sql statement and therefore the table involved. The error could be caused by several things:

a) simply a bug in Baan
b) You applied a patch, which changed a session but not the corresponding table.
c) like b, but you did not "Create runtime DD" on the table
d) like b, but the other way around, you changed the DD, but the session does not fit.

We once had a similar error on some finance tables. After some analysing we found, that in one table, Baan had written some huge negative values in some number fields and later could not handle them anymore. The records affected were anyway corrupted or not needed anymore. We deleted them and everything was fine. Before I would do something like this in your case, I would consider talking to SSA first.

Regards

Markus

Hi gbernal,

I had this problem some time ago, and I discorvered that this problem happen due to "float exception" problem, in other words a "divide by zero".

Regards.

Xikkos.

We have installed BaanIV c4 on Windows 2003 Enterprise edition as OS with backend MSSQL 2005. Installation went on successfully. But for some Baan sessions having Date field it gives error as -
'Error 205:Read row error'. How to solve this problem?
Regards
M KALAIYARASAN

Any solution for This issue

We have installed BaanIV c4 on Windows 2003 Enterprise edition as OS with backend MSSQL 2005. Installation went on successfully. But for some Baan sessions having Date field it gives error as -
'Error 205:Read row error'. How to solve this problem?
Regards
M KALAIYARASAN

Try to re-organize tables which are accesed by those problamatic sessions. This may be probably some index related problem which you need to rebuild.

Vishal

Hi...

you are comming from an other database? And installing on MSQL at new?
In that case. The tables are not imported because of an error in date field.
You must correct the data in your "old" system dump and import it again.
e.g. when you are comming from informix it happened very often. Because informix is not checking the date if it is correct. MSSQL does.

Regards

Markus