hi,
when i run posting integration transactions (session tfgld4201m000),a bw error appear"error 206,record is no locked on tfgld417101 in up_data(51)".so i cant post transaction.who know how to solve it?

Hi,

The specified table <table-name> is not in the database.

The database server cannot find a table or view specified in the statement. The table or view might have been renamed or dropped from the database.

Check the names of tables and views in the statement. If the names are spelled as you intended, check that you are using the database you want. To find the names of all tables in the database, query the systables table. To find the names of all views, query the sysviews table.

Regards, Carmar

Hi DDQING,

An error 206 is in 99.99% of the cases a programming error in BAAN that can only be solved by BAAN Support.
Please contact them immediately unless the problem is caused by a customization.

Regards,

Edwin

Carmar: The specified table <table-name> is not in the database. This is error 506.

I think Edwin is right, but I cannot imagine that that error still exists in the standard software... an error like this would not exist for a long time.

Normally in an SQL statement you need to select with a (delayed) lock when you intend to modify a record ("... for update") before a db.insert / db.update command. The error indicates that the selection is not done ... for update.

Run a ttstpsessinfo on your session to see what your current version is and whether or not you run standard software. And if you feel not capable in handling this: log a case.

Hi OmeLuuk,

When it comes to BAAN software never say never again!
Eventhough one might expect the standard software has been stabilized enough by now. However, in real life we still deal with solutions provided by BAAN Support and those can cause unforeseen problems.

Regards,

Edwin

I did not say that the error cannot be (re)introduced in the software, but if it is, I daresay it will not sit there for a long time, not this error in this session.

Every programmer hates a badfix, especially his own.