Hi all,

i dumped my live company to a test company. After Dump i run the reorg of the tables but it seems to be that something goes wrong.

Here are the Eventviewer error messages:

Env Baan5c (f:\baan5c)
Prog dbserver_dll file \db\servers\MSQL\msql_error.c # 499
Keyword MSQL Messages
Username ts_mh type S language 3
Process 0x7f8
ProcessSet mhagel@vbsb5c001:2040
Lasterror 0
Errno 0
bdberrno 0
Message
dbs_errno = 1308, Error 1308 occurred:
Error sqlcode 308 (sqlstate: 42000, Return code: -1, diagRecNum: 1) during SQLExecute.
[Microsoft][ODBC SQL Server Driver][SQL Server]Index 'Ittfacp240998_1a' on table 'dbo.ttfacp240998' (specified in the FROM clause) does not exist.
Flushed at \db\servers\MSQL\msql_error.c : #504.


nv Baan5c (f:\baan5c)
Prog dbserver_dll file \db\servers\MSQL\msql_error.c # 499
Keyword MSQL Messages
Username ts_mh type S language 3
Process 0x7f8
ProcessSet mhagel@vbsb5c001:2040
Lasterror 0
Errno 0
bdberrno 0
Message
dbs_errno = 1308, Error 1308 occurred:
Error sqlcode 8180 (sqlstate: 42000, Return code: -1, diagRecNum: 2) during SQLExecute.
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
Flushed at \db\servers\MSQL\msql_error.c : #504.

Env Baan5c (f:\baan5c)
Prog dbserver_dll file \db\servers\MSQL\msql_error.c # 641
Keyword MSQL Error
Username ts_mh type S language 3
Process 0x7f8
ProcessSet mhagel@vbsb5c001:2040
Lasterror 183 (Eine Datei kann nicht erstellt werden, wenn sie bereits vorhanden ist.)
Errno 0
bdberrno 0
Message
dbs_errno = 1308, Error 1308 occurred:
See fatal SQL statement in 'f:/baan5c/log/log.msql.mesg'.
Flushed at \db\servers\MSQL\msql_cursor.c : #672.


Env Baan5c (f:\baan5c)
Prog bshell file \logic\mir\mir\bdb_fun.c # 1144
Keyword DB error
Username ts_mh type S language 3
Process 0x7f8
ProcessSet mhagel@VBCRMACBOOK:2488
Lasterror 997 (Überlappender E/A-Vorgang wird verarbeitet.)
Errno 0
bdberrno 1308 (database error 308)
Message Error 1308 (database error 308) on select

Env Baan5c (f:\baan5c)
Prog bshell file \logic\mir\mir\mul_fun.c # 461
Keyword Process state:
Username ts_mh type S language 3
Process 0x7f8
ProcessSet mhagel@VBCRMACBOOK:2488
Lasterror 0
Errno 0
bdberrno 1308 (database error 308)
Message FATAL ERROR: Error 1308 (database error 308) on select
Can not continue in tdpur4201s000 in DLL: otfacpdll2402 (tfacp.dll2402.check.if.order.line.in.tfacp240)

I found in TMP Dir a R. file with the name of the errormessage R.tfacp240998 but i have no clue what the content of this file mean.

Thanks in Advance

Marco

Hello Touranus,

if there's an R*-file in the tmp directory it means that something went wrong the reconfiguration. You could restart it with "bdbreconfig", but in your case the easiest way would be to import tfacp240 into company 998 again.

BTW: After the import there is no need to reorganize tables with data+indices.
Reorg with referential integrity+repair reference counter is enough.

Have a nice day,

Lebowski

thanks lebowski,


that worked fine for me.

Have a nice day 2.

Marco

Thanks for the tip - I'm glad I looked here. I moved changes to production last week, for 44 companies, and 2 of the companies failed to create indices. (Since this is a summary table only updated once a month, it seemed safe to let it slide as other Monday "issues" came in.)

I just wanted to thank you for having this type of assist available.