[Prolaborate 4.2] Prolaborate error when clicking on connector

[r.straszewski]

Hello,
I am using Prolaborate version 4.2.0.37.

Description of the problem:
I can select an element (for example requirement or component) and choose "Traceability" from the dropdown menu to see all its connectors. Unfortunately, after clicking on one of the connectors to view its details, I receive a "bad request" error. Because of that, it is impossible to see the connector's note (or other properties). Does anyone else also have this problem?

[r.straszewski]

I think, that I found the problem:

From the logs of Pro Cloud Server

2022-10-18 10:35:18 [DEBUG]:   Thread 50  OSLC DB query error - SELECT Connector.Connector_ID, Connector.Name Name, Connector.Notes, Connector.ea_guid,Connector.Direction,Connector.Connector_Type, Connector.Btm_Mid_Label,   Connector.Stereotype,(SELECT TOP 1 Description FROM t_xref WHERE Description LIKE '@STEREO%' AND client = '{73B16866-16CB-48b9-B23C-01DF4B638BC1}' AND Type = 'connector property') Description,(select STRING_AGG(ea_guid,',') from t_diagram where diagram_id in (select diagramid from t_diagramlinks where connectorid = Connector_ID )) DiagramGuid,SO.ea_guid as SO_Guid,SO.name as SO_Name,SO.Alias as SO_Alias,SO.Note as SO_Notes,SO.Author as SO_Author,SO.Object_Type as SO_Type,(SELECT TOP 1 Description FROM t_xref WHERE Description LIKE '@STEREO%' AND client = SO.ea_guid) as SO_Description,SO.Stereotype as SO_Stereotype,EO.ea_guid as EO_Guid,EO.name as EO_Name,EO.Alias as EO_Alias,EO.Note as EO_Notes,EO.Author as EO_Author,EO.Object_Type as EO_Type,(SELECT TOP 1 Description FROM t_xref WHERE Description LIKE '@STEREO%' AND client = EO.ea_guid) as EO_Description,EO.Stereotype as EO_Stereotype,'Element' as ObjectType,'Connector' as Con_ObjectType,(SELECT STRING_AGG(cons1.ConstraintType,',') from t_connectorconstraint cons1 where cons1.ConnectorID = Connector.Connector_ID ) as ConstraintType ,(SELECT (STRING_AGG(cons2.[Constraint],',')) from t_connectorconstraint cons2 where cons2.ConnectorID = Connector.Connector_ID ) as Constraintname,(SELECT (STRING_AGG(ISNULL(cons2.Notes,'null'),',')) from t_connectorconstraint cons2 where cons2.ConnectorID = Connector.Connector_ID ) as Constraintnotes FROM t_connector Connector inner join t_object SO on SO.object_id = Connector.start_object_id inner join t_object EO on EO.object_id = Connector.end_object_id WHERE Connector.ea_guid = '{73B16866-16CB-48b9-B23C-01DF4B638BC1}'
2022-10-18 10:35:18 [WARNING]: Microsoft OLE DB Provider for SQL Server [-2147217900]
2022-10-18 10:35:18 [WARNING]: 'STRING_AGG' is not a recognized built-in function name.

I am using SQL Server 2008, and there is no STRING_AGG function there (it is available in SQL Server 2017). After testing this on SQL Server 2017, everything works fine. Version of Pro Cloud Server: 5.0.105

[wivel]

Hi

Have you checked the Prolaborate system requirements? It says 'SQL Server 2008 R2 and above', so you need to be on at least R2.

https://prolaborate.sparxsystems.com/resources/v4/documentation/installation-guide?articles=Prerequisites

Henrik

[r.straszewski]

Yes, I know. I thought, that I had 2008 R2, but now i re-checked to be sure and I have "Microsoft SQL Server 2012 (SP3)", so even higher.

Here is info from MS documentation about STRING_AGG (2017 and later)
https://learn.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-ver16