Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
50%
Handover everything to System Integrator from drawing BP till implementation of ERP
0%
Hire more inhouse skilled & capable IT Resource to work directly with SI
50%
Rely on SI Architects/Consultants
0%
Total votes: 2

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th April 2020, 10:00
GasperDBA GasperDBA is offline
Junior Member
 
Join Date: Nov 2019
Posts: 3
GasperDBA is on a distinguished road
Baan: 10 - DB: Microsoft SQL - OS: Microsoft Windows
Long locks on database objects
Baan: Infor ERP 10.4
DB: Other/Unknown
OS: Windows 2016
C/S: Both

Greetings,

we have another problem with baan on SQL Server 2017. Baan is not closing transactions and it is holding locks for hours, sometimes even days.. actually forever, as long as session is alive. Every single session on the server has one open transaction.. at all times.

Is there any option we could set to commit/rollback transactions on the database? Those transactions should be fast and release locks for other to use the database.

Version of RDBMS:
Microsoft SQL Server 2017 (RTM-CU14) (KB4484710) - 14.0.3076.1 (X64) Mar 12 2019 19:29:19 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)

Regards,

Gašper
Reply With Quote
Sponsored Links
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
Undocumented Functions & Variables george7a Tools Development 81 30th September 2015 11:35
Date casting issue niralibaan Tools Development 2 22nd August 2010 18:26
Help regarding tools session rahul.kolhe22 Tools Development 4 22nd January 2010 13:31
xml question steveauckly Tools Development 4 27th July 2004 10:41
File Browser Bogdan Tools Development 52 7th January 2004 08:17


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


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