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
14%
200 - 500 GB
32%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 28

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th October 2018, 16:53
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,157
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
always on ms-sql, open transactions
Baan: ERP LN 6.1 FP8 (Infor ERP 10.2)
DB: SQL Server 2016
OS: Other/Unknown
C/S: None/Unknown

In our always on environmet (sqlserver) we experience the fact that the statement dbcc opentran('name of the database') reports active transactions which can be days old.
The problem is that due to this the transaction log can't be truncated/shrinked.

With other statements we can always pinpoint the bshell that's causing it, after closing it is solved.

The transaction reported always is exactly started on the hour (e.g. 9:00:00:xxxAM) which is weird.

I have never seen this in other sql server environments.

We have been discussing it with infor but they don't think it's a bug in their driver. Our sql server is patched up to the latest software. We have reported this to microsoft, haven't received an answer yet.

Anyone else seen this?
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 2 (0 members and 2 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
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 05:35
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
SQL Trace mraja71 Tools Development 2 5th November 2002 16:41


All times are GMT +2. The time now is 13:00.


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