Hi Dojo
I'm trying to fill a table using the SLProtocol.FillArray method but it throws the following exception. Can somebody help me to find the root cause of this please?
2021/12/23 09:12:58.675|AviWest StreamHub.txt|SLManagedScripting.exe|ManagedInterop|ERR|0|140|QA704|PreviewProcessor.SetTableContent|Error while processing the InputsPreview for input 0:
System.InvalidOperationException: This type has a ComVisible(false) parent in its hierarchy, therefore QueryInterface calls for IDispatch or class interfaces are disallowed.
at System.Runtime.InteropServices.Marshal.GetNativeVariantForObject(Object obj, IntPtr pDstNativeVariant)
at Skyline.DataMiner.Scripting.ConcreteSLProtocol.NotifyProtocol(Int32 iType, Object value1, Object value2)
at Skyline.DataMiner.Scripting.ConcreteSLProtocol.FillArray(Int32 tableId, Object[] columns, Nullable`1 timeInfo)
at Skyline.DataMiner.Scripting.ConcreteSLProtocol.FillArray(Int32 tableId, Object[] columns)
at AviWest.StreamHub.PreviewProcessor.SetTableContent()
This is my approach:
Dictionary<string, AudiolevelstableQActionRow> rows = new Dictionary<string, AudiolevelstableQActionRow>();
...string key = String.Format("{0}.{1}", root.InputId, sourceNumber);
AudiolevelstableQActionRow row = new AudiolevelstableQActionRow
{
Audiolevelstableinstance_1601 = key,
Audiolevelstableinputnumber_1602 = root.InputId,
...
};rows[key] = row;
...
protected override void SetTableContent()
{
protocol.FillArray(Parameter.Audiolevelstable.tablePid, rows.Values.ToArray());
}
Thank you in advance!
Kind regards!
Hi Michiel,
When using the Fill Array method with rows, you need to provide the rows as List of object arrays and also specify the type of SaveOption (full or partial).
Using your code, I think something like this would work:
Dictionary<string, AudiolevelstableQActionRow> rows = new Dictionary<string, AudiolevelstableQActionRow>();
...string key = String.Format("{0}.{1}", root.InputId, sourceNumber);
AudiolevelstableQActionRow row = new AudiolevelstableQActionRow
{
Audiolevelstableinstance_1601 = key,
Audiolevelstableinputnumber_1602 = root.InputId,
...
};rows[key] = row;
...
protected override void SetTableContent()
{
var tableRows = rows.Select(r => r.Value.ToObjectArray()).ToList();
protocol.FillArray(
Parameter.Audiolevelstable.tablePid,
tableRows,
NotifyProtocol.SaveOption.Full);
}
Hi João, indeed you are right! With this approach, the issue is solved. Thank you very much for your prompt response!