Greetings,
I get the below error when trying to add text to any standard session in baan. Can you please suggest what needs to be done to fix this.
If there is a lock at the db level or something needs to be rebuild..
can you give me exact command to fix this. thanks

------------------------------------------------------------------------------------------
Event Type: Error
Event Source: Infor Porting Set
Event Category: bshell
Event ID: 1000
Description:
Env : baan (c:\baan)
Program : bshell file bdb_fun.c # 1244
Keyword : DB error
Errno : 0
BdbErrno : 850 (E_BDB_FATAL_START)
ExtraInfo : session: "tttxt1100m000";object: "tttxt1100m000"; company number: 320
query: "select tttxt001.ctxt
from tttxt001
where tttxt001.ctxt inrange :tttxt030.fnum and :tttxt030.lnum
order by tttxt001.ctxt asc
as set with 1 rows
"
Message : Error 850 (E_BDB_FATAL_START) on <unknwn> (No retry point specified)
------
dbs_errno = 850, Error 850 occurred:
Error sqlcode 601 (sqlstate: 42000, Return code: -1, diagRecNum: 1) during SQLExecute.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement.
Flushed at \MSQL\msql_error.c : #542.
----------------------------------------------------------------------

thanks for your time

LittleJohn

Dropping and recreating the txt tables did the trick, and fixed the issue

Cheers