Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 4th October 2005, 16:12
barkilic barkilic is offline
Junior Member
 
Join Date: Oct 2005
Posts: 3
barkilic is on a distinguished road
Baan: BaanIVc - DB: SQL Server 2000 - OS: Windows
Sql Server Trigger

Hello,

We are new in Windows 2003/SQL Server 2000 Environment.

I created a Sql server trigger. But while it runs, this message pops up:

Fatal error : Error 1000(bdb_errno 520) on tiitm100138 in select
Fatal error : Cannot continue in tiitm0202s000 in DLL : otiitmdll0003(get.company)
Error : tiitm0202s000: A not terminated transaction is aborted


And these are the log records in Windows 2003 Event Viewer's application section:

9/29/2005 2:19:30 PM Baan Error Bshell 1000 TRABB01\BARKIL TRABB01ISAS99 "Env BaanIV (d:\baaniv)
Prog bshell file \logic\mir\mir\bdb_fun.c # 1101
Keyword DB error
Username barkil type S language 2
Process 0x3f34
Lasterror 0
Errno 0
bdberrno 520 (Error during buffered updates)
Message Error 1000 (bdb_errno 520) on tiitm100138 in SELECT
"
9/29/2005 2:19:30 PM Baan Error Msql7_srv 1000 TRABB01\BARKIL TRABB01ISAS99 "Env BaanIV (d:\baaniv)
Prog msql7_srv file \db\servers\MSQL\msql_row.c # 344
Keyword MSQL Error
Username barkil type S language 2
Process 0x3d78
Lasterror 0
Errno 0
bdberrno 0
Message
dbs_errno = 1000 Error 1000 occurred:
Error during execute insert (dbo.ttiitm100138).
Flushed at \db\servers\MSQL\msql_row.c : #244.
"
9/29/2005 2:19:30 PM Baan Error Msql7_srv 1000 TRABB01\BARKIL TRABB01ISAS99 "Env BaanIV (d:\baaniv)
Prog msql7_srv file \db\servers\MSQL\msql_error.c # 513
Keyword MSQL Messages
Username barkil type S language 2
Process 0x3d78
Lasterror 0
Errno 0
bdberrno 0
Message
dbs_errno = 1000 Error 1000 occurred:
Error sqlcode 0 (sqlstate: HY000, Return code: -1, diagRecNum: 1) during SQLExecute.
[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt
Flushed at \db\servers\MSQL\msql_error.c : #518.
"
9/29/2005 2:19:30 PM Baan Error Msql7_srv 1000 TRABB01\BARKIL TRABB01ISAS99 "Env BaanIV (d:\baaniv)
Prog msql7_srv file \db\servers\MSQL\msql_error.c # 513
Keyword MSQL Messages
Username barkil type S language 2
Process 0x3d78
Lasterror 0
Errno 0
bdberrno 0
Message
dbs_errno = 1000 Error 1000 occurred:
Error sqlcode 0 (sqlstate: HY000, Return code: -1, diagRecNum: 1) during SQLExecDirect.
[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt
Flushed at \db\servers\MSQL\msql_error.c : #518.


The trigger looks like this:

Create TRIGGER giris_138
ON ttiitm001138
AFTER INSERT AS
insert into ttiitm200138 - - - - >That's a table I created.
(t_item,t_stat)
select
ek.t_item,
1
from inserted ek
GO
Reply With Quote
 


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 and SQL Server delphin Performance & Tuning 1 21st April 2005 02:51
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 12:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 14:11
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 14:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 14:22


All times are GMT +2. The time now is 06:44.


©2001-2018 - Baanboard.com - Baanforums.com