Fatal Error: ERROR 1308 (database error 308) on select
I am having this error when i open the Purchase Order Lines session & few other sessions.
I re-organized the tables & restarted the server but still this error is coming.
In reorganizing, it showed only 3 tables with status R1 & message
"can not create file 'e:\baan\tmp\R.tiipd001500' file already exists" :(
for table tiipd001
other tables are tcibd001
Please if any1 has a solution for this would be really gr8.:)

Do you still have these R.* files in your temp? Because that means that the reconfigure failed. You should check your eventlog to find out what's wrong.

Regards,

Yes these R.* files are there for the mentioned tables.
Event log is showing

Env : bse (e:\baan)
Program : bshell file \logic\mir\mir\mul_fun.c # 472
Keyword : Process state:
User : zeeshan type:S language:2
Process : 4720
Proc.Set : Zeeshan+Hyder@zeeshan:1148
Lasterror : 0
Errno : 0
BdbErrno : 1308 (database error 308)
ExtraInfo : session: "tdpur4100m900";object: "tdpur4100m900"; company number: 500
query: "select tcibd001.*
from tcibd001
where tcibd001._index1 = { :i.item}
as set with 1 rows
"
Message : FATAL ERROR: Error 1308 (database error 308) on select
Can not continue in tdpur4100m900 in DLL: otdpurdll0403 (tdpur.dll0403.read.general.item.data)[sql.exec]


Please check it & leme know if any solution for it.