topic RE: Ah OK , I see your point and… in Product Forum

Queue Reports Object - failed to generate report for queue that having collection in its data item

Shenq_FengKwan — Fri, 01 Jun 2018 17:47:00 GMT

I'm currently using Queue Reports Object VBO to create report from the queue, it is able to generate the report if the queue item doesn't contain any collection. However, it is throwing the following error message when generating report against queue that having collection in its data item. Error message: Internal : Could not execute code stage because exception thrown by code stage: Type of value has a mismatch with column type Couldn't store in Attachment Column. Expected type is DataTable Further checked on the VBO (Object Name: Queue Reports), found that it is throwing error at the €œCollect Item Data1€ code stage that in €œGet data From Items€. The code at line 4 and 18 were supposed to omit Collection type field from the queue data item. However, these line of doesn€™t seems to be doing the job as intended.The function in these 2 lines €œMicrosoft.VisualBasic.TypeName(c)€ always return €œDataColumn€ regardless of the actual data type of the column. I have temporarily fixed this by replacing these 2 lines with €œIf c.DataType.toString() = "System.Data.DataTable" Then Continue For€ Has anyone experienced this issue?

The Queue Reporting object…

John__Carter — Fri, 01 Jun 2018 21:37:00 GMT

The Queue Reporting object does not support nested collections I'm afraid. The reason is that there is no universal way to represent a multi-dimensional collection structure on 1 line of a report. To do so you'll need to create some bespoke code specific to the shape of the data in your work queue.

Hi John, Yes, the VBO doesn…

Shenq_FengKwan — Thu, 07 Jun 2018 12:33:00 GMT

Hi John, Yes, the VBO doesn't support nested collections as per documentation. In fact, the VBO has a line of code to ignore the nested collection while retrieving data from queue item, however, the particular line of code doesn't work as it intended to be (on my machine).

Ah OK , I see your point and…

John__Carter — Thu, 07 Jun 2018 15:58:00 GMT

Ah OK , I see your point and thanks for pointing out the error. I'll see that it gets changed.

RE: Ah OK , I see your point and…

RasmusPetersen — Wed, 06 May 2020 10:53:00 GMT

Hi, this wasnt changed (our version 6.5).

I updated the code object that is throwing the exception in Object Queue Reports, page Get Data From Items to this:

For Each c As DataColumn in Item_Data.Columns

   'Ignore nested collections
   If Microsoft.VisualBasic.TypeName(c)="DataTable" Then
  DataFromItems.Columns.Add(c.ColumnName, System.Type.GetType("System.String"))
End If
   If Not DataFromItems.Columns.Contains(c.ColumnName) Then
      DataFromItems.Columns.Add(c.ColumnName, c.DataType)
   End If

Instead of trying to change the DataType after creation, I detect the DataTable type and smash in a string type instead. Aint pretty but it works.

------------------------------
Rasmus Petersen
Manager
KPMG
Europe/London
------------------------------

RE: Ah OK , I see your point and…

ChandanRaju — Thu, 07 May 2020 10:21:00 GMT

Hello @RasmusPetersen, i am trying this option of changing the code like you mentioned. It bypass the error message we see, but the output data comes as blank for many rows (basically with other different tags). assistance is really welcomed. Thanks in advance

------------------------------
Chandan Raju
------------------------------

RE: Ah OK , I see your point and…

ChandanRaju — Fri, 08 May 2020 05:45:00 GMT

@BlueprismSuppor- This issue is not yet resolved and creates a blocker for everyone's work and wastes time and effort to fix it. Please look into this issue.
The Queue Report VBO throws error if the Queue Data has a Column with Collection Data Type, even though there is a piece of code in the VBO to avoid Collection type (Data Table) but doesn't work as expected.

Thank you

------------------------------
Chandan Raju
------------------------------