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,
You are using the FillArray method to fill columns instead of rows. Please try the following overloaded FillArray method:
“protocol.FillArray(Parameter.Audiolevelstable.tablePid, rows.Values.Select(row => row.ToObjectArray()).ToList(), NotifyProtocol.SaveOption.Full);”
The FillArray method overload with the saveOption parameter accepts table rows instead of columns (whereas the other method overloads accept table columns). The implementation of this overload takes the provided list of rows and constructs an array where each element represents a column.
Please check the remarks in the Development Library:
https://help.dataminer.services/development/#t=DataMinerDevelopmentLibrary_Customerpart4ClassLibraryCLASkylineDataMinerScriptingSLProtocol_methods.htm&rhsearch=fillarray&rhhlterm=fillarray&rhsyns=
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!
Hi José, indeed you are right! With this approach, the issue is solved. Thank you very much for your prompt response!