Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th February 2010, 07:27
touranus touranus is offline
Junior Member
 
Join Date: Feb 2010
Posts: 5
touranus is on a distinguished road
Baan: Baan5c - DB: SQL 2005 - OS: Windows 2003
Error 1308 (database on error 308)
Baan: Other/Unknown
DB: Other/Unknown
OS: Other/Unknown
C/S: None/Unknown

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
Reply With Quote
  #2  
Old 15th February 2010, 11:10
lebowski's Avatar
lebowski lebowski is offline
Senior Member
 
Join Date: Jan 2010
Posts: 125
lebowski is on a distinguished road
Baan: Baan IV, BaanERP 5.0c, ERP LN - DB: Oracle, SQL - OS: Unix, Linux, Windows
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
Reply With Quote
Sponsored Links
  #3  
Old 15th February 2010, 13:43
touranus touranus is offline
Junior Member
 
Join Date: Feb 2010
Posts: 5
touranus is on a distinguished road
Baan: Baan5c - DB: SQL 2005 - OS: Windows 2003
thanks lebowski,


that worked fine for me.

Have a nice day 2.

Marco
Reply With Quote
  #4  
Old 8th December 2015, 16:09
lauras's Avatar
lauras lauras is offline
Junior Member
 
Join Date: Dec 2002
Location: Kansas City
Posts: 16
lauras is on a distinguished road
Baan: B4c4 - DB: Oracle 10g - OS: Windows 2000/XP
Thumbs up Re-orging data & indices worked

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.
__________________
Laura
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Baan Database Definitions kberogluer Operating Systems & Databases 5 16th January 2010 13:08
Multiple database on single server Paul P Operating Systems & Databases 7 14th October 2005 08:53
Pb ttdba01108 in convert baan user to database with BaaN V marco_polo Tools Administration & Installation 3 31st March 2005 18:18
Oracle 9.2.0.4 Database create patrickmonks Operating Systems & Databases 9 26th November 2003 14:41


All times are GMT +2. The time now is 16:38.


©2001-2017 - Baanboard.com - Baanforums.com