With activated DBMonitor EListError

[Kasperian]

Hello!

We have currently some issues with the DBMonitor. If we activate the component "TMSSQLMonitor" and trying to run the procedure StartTransaction from a TMSTransaction we got following error:

e 13.10.2014 11:41:47.774 ---------------------------------------------------------------------------
e 13.10.2014 11:41:47.774 Unhandled exception! Error message: List index out of bounds (0) (EListError)
e 13.10.2014 11:41:47.774 ---------------------------------------------------------------------------
e 13.10.2014 11:41:47.843 --Stack-list begin--
e 13.10.2014 11:41:47.843 [0042411C] Classes.TList.Error (Line 2736, "classes.pas" + 1) + $1
e 13.10.2014 11:41:47.843 [00424185] Classes.TList.Error (Line 2741, "classes.pas" + 1) + $16
e 13.10.2014 11:41:47.843 [00424223] Classes.TList.Get (Line 2772, "classes.pas" + 2) + $E
e 13.10.2014 11:41:47.843 [005A7886] DBAccess.TDAConnections.GetItems + $A
e 13.10.2014 11:41:47.843 [005A7E03] DBAccess.TDATransaction.GetConnection + $3
e 13.10.2014 11:41:47.843 [005A6CA0] DBAccess.TDBAccessUtils.GetConnection + $4
e 13.10.2014 11:41:47.843 [0057A859] DASQLMonitor.TCustomDASQLMonitor.GetParent + $1D
e 13.10.2014 11:41:47.843 [0057C446] DASQLMonitor.TCustomDASQLMonitor.SendDBMonitorEvent + $BA
e 13.10.2014 11:41:47.843 [0057B3E1] DASQLMonitor.TCustomDASQLMonitor.InternalTRStart + $C1
e 13.10.2014 11:41:47.843 [00579F11] DASQLMonitor.TCustomDASQLMonitor.TRStart + $19
e 13.10.2014 11:41:47.843 [005A88B8] DBAccess.TDATransaction.StartTransaction + $A8
e 13.10.2014 11:41:47.843 [005EF498] SYS_DB_MSSQL.TVIADataModule.StartTransaction (Line 1349, "..\sys32100\SYS_DB_MSSQL.pas" + 1) + $5

The settings of the TMSTransaction component are the following:

• DefaultCloseAction: taRollback
• IsolationLevel: ilReadCommitted

Our sql statement via TMSQuery some code lines before runs just fine. Does somebody have a idea for solving that problem?

[AlexP]

Hello,

We have reproduced the problem with DBMonitor - and we will investigate the reasons for such behavior.

[Kasperian]

Thank you for your fast answer! Keep us updated, if you found the issue.

[AlexP]

We have fixed this behavior, the fix will be included to the next version of SDAC.

[Kasperian]

Thank you for the fast response and update! We will check the update when it's avaible.

[AlexP]

We are going to release the new build within a month.