2023-04-11 Thermo Chromeleon SDK issues

ChromSword use-case stand-alone app that uses Chromeleon SDK to generate sequences and injections based on experimental data automatically.

1. Problem with unstable DataVault connection with remote DataVault. Local DataVaults work fine, remote at unpredictable times throw following error. Error can be bypassed if Chromeleon UI is open and user loads items from remote DataVault in Chromeleon UI, then suddenly error is not anymore also in App scope.

2. Another Error that occurs after running many sequences (20+) each containing 1 injection using same CmSdkScope instance. Code added as attachement, the main question is what could coause following error and how to prevent it possibly?

Error 1:

xxxxxxxxxx
20
1
Exception: Cannot connect to the database. Dionex.DataAccess    at Dionex.Chromeleon.Data.DbConnectionAdapter.ConnectDatabase()
2
   at Dionex.Chromeleon.Data.DbConnectionAdapter.Connect(Boolean skipEvent)
3
   at Dionex.Chromeleon.Data.SecurableItemMapper.LoadAccessControl(ISecurableItem item)
4
   at Dionex.Chromeleon.Data.DbConnectionAdapter.LoadAccessControlInternal(ISecurableItem item)
5
   at Dionex.Chromeleon.Data.DbConnectionAdapter.<>c__DisplayClass40.<LoadAccessControl>b__3e()
6
   at Dionex.Chromeleon.Data.DbConnectionAdapter.Retry(Action retryCallback, Int32 timeout, Int32 minTries, Boolean isWriteOperation)
7
   at Dionex.Chromeleon.Data.DbConnectionAdapter.RetryQuery(Action retryCallback, Boolean isWriteOperation)
8
   at Dionex.Chromeleon.Data.DbConnectionAdapter.LoadAccessControl(ISecurableItem item)
9
   at Dionex.Chromeleon.Data.SecurableItem`1.LoadAccessControl()
10
   at Dionex.Chromeleon.Data.SecurableItem`1.get_AccessControlList()
11
   at Dionex.Chromeleon.Data.AccessCheck.GetAclFrom(IDataItem item)
12
   at Dionex.Chromeleon.Data.AccessCheck.GetEffectiveAccessControlList(IDataItem item)
13
   at Dionex.Chromeleon.Data.AccessCheck.HasAccess(IDataItem item)
14
   at Dionex.Chromeleon.Data.DataItem`1.CreateAndInitializeData()
15
   at Dionex.Chromeleon.Data.DataItem`1.LoadItemData()
16
   at Dionex.Chromeleon.Data.DataItem`1.LoadData()
17
   at Dionex.Chromeleon.Data.DataItem`1.get_Data()
18
   at Dionex.Chromeleon.Data.DataSource.GetLocked()
19
   at Dionex.Chromeleon.Data.DataSource.get_Locked()
20
   at Thermo.Chromeleon.Sdk.Data.DataVault.get_IsReadOnly()

Error 2

xxxxxxxxxx
1
Chromeleon log: Dionex.Chromeleon.Data.Common.DataAdapterException: Cannot connect to the database.
2
(2): System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  
3
This may have occurred because all pooled connections were in use and max pool size was reached. 

Code that produces the error in remote DataVault:

xxxxxxxxxx
66
1
for (var iRetryCreateSequence = 0; iRetryCreateSequence < 2; iRetryCreateSequence++)
2
{
3
    try
4
    {
5
        if (dataRootParent is IFolder)
6
        {
7
            sequence = itemFactory.CreateSequence(nameOfMethod, dataRootParent as IFolder);
8
        }
9
        else
10
        {
11
            sequence = itemFactory.CreateSequence(nameOfMethod, dataRootParent as IDataVault);
12
        }
13
        break;
14
    }
15
    catch (Exception exc)
16
    {
17
        LoggingUtils.Log(exc);
18

19
        if (!isTimestampAddedNameOfMethod)
20
        {
21
            nameOfMethod += " " + DateTime.Now.ToString("dd-MM-yyyy HH-mm-ss");
22
            isTimestampAddedNameOfMethod = true;
23
        }
24
    }
25
}
26
sequence.Instrument = m_instrument.Name;
27
sequence.InstrumentUri = m_instrument.ApplicationUri;
28

29
var success = false;
30
var retry = 3;
31
while (!success && !m_isRunCancelled && retry >= 0)
32
{
33
    retry--;
34
    try
35
    {
36
        try
37
        {
38
            while (sequence.IsReadOnly && !m_isRunCancelled)
39
            {
40
                LoggingUtils.LogInfo("Data Hive busy");
41
                WindowUtils.SleepWithEvents(1000);
42
            }
43
        }
44
        catch (Exception exc)
45
        {
46
            LoggingUtils.Log(exc);
47
            WindowUtils.SleepWithEvents(5000);
48
        }
49
        method.MoveTo(sequence);
50
        LoggingUtils.LogInfo($"sequence moved to dataRootParent");
51
        success = true;
52
    }
53
    catch (Exception exc)
54
    {
55
        LoggingUtils.Log(exc);
56
        WindowUtils.SleepWithEvents(5000);
57
    }
58
}
59
if (!success)
60
{
61
    LoggingUtils.LogInfo($"method NOT moved to dataRootParent");
62
    StopPump();
63
    StatusDevice = InstrumentStatus.Error;
64
    StatusErrorMessage = LocalizationUtils.Localize("Connection lost to Chromeleon data hive, please restart CSA program and continue execution.");
65
    return;
66
}