Query llamadas de servicio con actividad

SAP Business One
1

Cordial saludo

Espero me puedan ayudar ya que al agregar la sentencia Distinct tengo problemas en este query.

Tengo esta consulta para visualizar las llamadas de servicio y sus documentos asociados como las ofertas de venta y las actividades relacionadas en la pestaña operaciones, al agregar esas actividades empece a ver filas duplicadas pero cuando agrego la opción distinct me muestra este mensaje:

1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;264 invalid datatype: LOB type in distinct select clause: line 33 col 20  '' (ECM2) (at pos 755)

esta es la consulta:

SELECT DISTINCT

T5."SeriesName", 
T0."DocNum",

T0."createDate" AS "Fecha de creación",
T0."closeDate" AS "Fecha de resolución", 
---T0."Duration" AS "Duración",
T0."createTime" AS "Hora solicitud",

T6."CardCode", 
T6."CardName", 
T6."CardFName" AS "Sucursal", 

T0."callID",
T0."U_NVS_IdServicio", 
T0."U_NVS_IdServicio2",

T1."Name" AS "Tipo de problema", 
T2."Name" AS "Subtipo de problema", 
CASE 
WHEN T0."priority" = 'L' THEN 'Baja'
WHEN T0."priority" = 'M' THEN 'Media'
WHEN T0."priority" = 'H' THEN 'Alta'
END AS "Prioridad",
T0."subject" AS "Asunto",

T3."Name" AS "Estado", 
CONCAT(CONCAT(T4."lastName",' '),T4."firstName") AS "Técnico",
T0."closeTime" AS "Hora de resolución" ,
  
T7."U_NAME" AS "Usuario de Call Center", 
T0."descrption" AS "Solicitud del cliente",
T8."Notes" AS "Operación"


FROM OSCL T0  

LEFT JOIN OSCP T1 ON T0."problemTyp" = T1."prblmTypID" 
LEFT JOIN OPST T2 ON T0."ProSubType" = T2."ProSubTyId" 
LEFT JOIN OSCS T3 ON T0."status" = T3."statusID" 
LEFT JOIN OHEM T4 ON T0."technician" = T4."empID" 
LEFT JOIN NNM1 T5 ON T0."Series" = T5."Series" 
LEFT JOIN OCRD T6 ON T0."customer" = T6."CardCode" 
LEFT JOIN OUSR T7 ON T0."assignee" = T7."USERID" 
LEFT JOIN OCLG T8 ON CAST(T0."callID" AS INT ) = CAST (T8."parentId" AS INT) AND T0."objType" = T8."parentType"

WHERE T7."U_NAME" NOT IN ('manager')


ORDER BY 
T0."createDate", 
T0."createTime"
2

comentare los campos que no tengo en mi Tabla, te dice la linea en donde esta tu error comienza comentareando la linea y luego checas por que no corre el query o la función que necesita para convertir el campo

saludos

SELECT DISTINCT

T5.SeriesName, 
T0.DocNum,

T0.createDate AS 'Fecha de creación',
T0.closeDate AS 'Fecha de resolución', 
---T0.Duration AS Duración,
T0.createTime AS 'Hora solicitud',

T6.CardCode, 
T6.CardName, 
T6.CardFName AS 'Sucursal', 

T0.callID,
--T0.U_NVS_IdServicio, 
--T0.U_NVS_IdServicio2,

T1.Name AS 'Tipo de problema', 
T2.Name AS 'Subtipo de problema', 
CASE 
WHEN T0.priority = 'L' THEN 'Baja'
WHEN T0.priority = 'M' THEN 'Media'
WHEN T0.priority = 'H' THEN 'Alta'
END AS Prioridad,
T0.subject AS 'Asunto',

T3.Name AS Estado, 
CONCAT(CONCAT(T4.lastName,' '),T4.firstName) AS 'Técnico',
T0.closeTime AS 'Hora de resolución' ,
  
T7.U_NAME AS 'Usuario de Call Center', 
CAST (T0.descrption AS NVARCHAR(MAX)) as  'Solicitud del cliente',
CAST (T8.Notes  AS NVARCHAR(MAX)) as 'Operación'

FROM OSCL T0  

LEFT JOIN OSCP T1 ON T0.problemTyp = T1.prblmTypID 
LEFT JOIN OPST T2 ON T0.ProSubType = T2.ProSubTyId 
LEFT JOIN OSCS T3 ON T0.status = T3.statusID 
LEFT JOIN OHEM T4 ON T0.technician = T4.empID 
LEFT JOIN NNM1 T5 ON T0.Series = T5.Series 
LEFT JOIN OCRD T6 ON T0.customer = T6.CardCode 
LEFT JOIN OUSR T7 ON T0.assignee = T7.USERID 
LEFT JOIN OCLG T8 ON CAST(T0.callID AS INT ) = CAST (T8.parentId AS INT) AND T0.objType = T8.parentType

WHERE T7.U_NAME NOT IN ('manager')

ORDER BY 
T0.createDate, 
T0.createTime
3

Lo resolví dejando únicamente el Tipo de objeto que quería ver dentro del where, para que no mostrara la información de las referencias de objeto vacías que hace que se vean los datos duplicados.