Hello Dojo,

While building a connector I started seeing DataMiner run-time exception, which after some investigation I concluded were caused by tree controls. The actual trees are rather simple and almost a copy-paste from the documentation. From analyzing the element logs I suspect internal problem with subscribing to the foreign key of the child tables.

The table trees initially work as expected after the first API call trigger, however any subsequent updates to the child table(s) causes the table tree to stop showing the child elements, although the overall tree table is still displayed correctly.

Exception:

Unexpected Exception [Non-supported type
Parameter name: dataType]: Subscribe/Unsubscribe ( at Skyline.DataMiner.Net.MessageHandler.ParameterDataToMessages(Type dataType, Int32 dataMinerID, Int32 elementID, Object info, ParameterChangeOrigin origin)
at Skyline.DataMiner.Net.MessageHandler.ParameterDataToMessages(Type dataType, Int32 dataMinerID, Int32 elementID, Object info, ParameterChangeOrigin origin)
at Skyline.DataMiner.Net.DataMiner.SubscribeOnSLDataMinerElementInner(SubscribeInfo info)
at Skyline.DataMiner.Net.DataMiner.SubscribeOnSLDataMinerElement(SubscribeInfo info)
at Skyline.DataMiner.Net.DataMiner.DoQueuedSubscriptionInner(Object arg))

Element log (params 2119 and 2221 are the foreign keys):

2024/08/08 19:36:53.324|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2100 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2119 == 50870 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 0... Cookie 26
2024/08/08 19:36:53.328|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2100 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2119 == 50870 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 1... Cookie 27
2024/08/08 19:36:53.331|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2100 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2119 == 48679 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 1... Cookie 28
2024/08/08 19:36:53.333|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2100 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2119 == 48679 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 0... Cookie 29
2024/08/08 19:36:53.335|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2100 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2119 == 48679 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 1... Cookie 30
2024/08/08 19:36:53.337|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2200 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2221 == 48066 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 1... Cookie 31
2024/08/08 19:36:53.344|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2200 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2221 == 48066 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 0... Cookie 32
2024/08/08 19:36:53.350|SLElement.exe|9576|CElement::Subscribe|INF|-1|subscribe (198101/2): 198101/2 VT_ARRAY|VT_VARIANT (7) ~ 0 VT_I4 : 5 ~ 1 VT_I4 : 2200 ~ 2 VT_ARRAY|VT_BSTR (1) : value=2221 == 48066 ~ 3 VT_I4 : 1 ~ 4 VT_I4 : 1... Cookie 33

Code:

<Relations>
<Relation path="1800;2100"/>
<Relation path="1900;2200"/>
</Relations>
<TreeControls>
<TreeControl parameterId="111">
<Hierarchy>
<Table id="1800"/>
<Table id="2100" parent="1800"/>
</Hierarchy>
<OverrideDisplayColumns>1802</OverrideDisplayColumns>
<HiddenColumns>1805,1806,1807,1808,1809,1812,1814,1816,1818,1820,1822,1824,1826,1828,1829</HiddenColumns>
<ReadonlyColumns>1802,1810</ReadonlyColumns>
</TreeControl>
<TreeControl parameterId="112">
<Hierarchy>
<Table id="1900"/>
<Table id="2200" parent="1900"/>
</Hierarchy>
<OverrideDisplayColumns>1902</OverrideDisplayColumns>
<HiddenColumns>1905,1906,1907,1908,1909,1912,1914,1916,1918,1920,1922,1923,1924,1925,1927,1928,1930,1931,1932,1934,1935,1936,1937,1939,1940,1942</HiddenColumns>
<ReadonlyColumns>1902,1910</ReadonlyColumns>
</TreeControl>
</TreeControls>

Correctly displayed table tree (after the first API call to retrieve child data):

Table tree with missing child elements after update to the child's data:

System info:

Self-hosted single DataMiner agent (not a cluster) with ElasticSearch.

DataMiner version: DataMiner (10.4.0.0-14637-CU5).

Thank you.