invalid datatype: "T3.U_ARemark" LOB type in GROUP BY clause: (at pos 1913) SAP Business one

[nikunjmehta2290]

Dear all,

I am facing issue like SAP DBTech JDBC: [264]: invalid datatype: "T3.U_ARemark" LOB type in GROUP BY clause: line 69 col 1 (at pos 1913).

Below query comes with this error.

SELECT

T5."BPLName", T3."U_G_ENTRY" AS "Gate Entry No.", T4."U_UNE_CCODE", T4."U_UNE_CNAME", T0."DocEntry", T0."DocNum" AS "Po Number",

T0."DocDate" AS "PO Date", T0."DocDueDate",

--T4."U_UNE_DCDT",

T3."NumAtCard", T3."TaxDate" AS "Invoice Date", T2."U_UNE_MRP" AS "MRP",

T2."ItemCode",T2."Dscription",

IBH."DistNumber" AS "Batch Attribute 1", IBH."MnfSerial" AS "Batch", TO_VARCHAR(IBH."MnfDate",'DD/MM/YYYY') AS "MFG Date",

TO_VARCHAR(IBH."ExpDate",'DD/MM/YYYY') AS "Exp Date",

T3."DocNum",T3."DocDate", T2."Quantity", T3."U_NO_BOX",

T3."U_TOT_WEIGHT",

T3."U_TransporterName", T3."U_DocketNo", T3."U_E_WAY", T3."U_E_WAY_D", T3."U_ASN", T3."U_NOOFDAYS", T3."U_GS1P", T3."U_GST1S", T3."U_GS2S",

T3."U_GS1T",

T3."U_ABC" ,

T3."U_ARemark"

FROM OPOR T0

Inner join POR1 T1 On T0."DocEntry"=T1."DocEntry"

Inner Join PDN1 T2 On T0."DocEntry"=T2."BaseEntry"

Inner Join OPDN T3 On T3."DocEntry"=T2."DocEntry"

Inner Join "TEST3007"."@UNE_GATENTRYHED" T4 On T0."DocEntry"=T4."U_UNE_POENTRY"

LEFT JOIN OBPL T5 ON T0."BPLId" = T5."BPLId"

LEFT JOIN IBT1 IB On T2."DocEntry" = IB."BaseEntry" AND T2."LineNum" = IB."BaseLinNum" AND T2."ItemCode"=IB."ItemCode" AND IB."BaseType"=T2."ObjType"

LEFT JOIN OBTN IBH On IB."ItemCode"=IBH."ItemCode" AND IBH."DistNumber"=IB."BatchNum" Where T0."DocNum"='2102001460'

Group By

T0."DocEntry",T0."DocNum" ,T0."DocDate" ,T0."DocDueDate",T3."U_G_ENTRY", T3."NumAtCard",T3."TaxDate" ,T2."U_UNE_MRP" ,T2."ItemCode",T2."Dscription", IBH."DistNumber" , IBH."MnfSerial", IBH."MnfDate", IBH."ExpDate", T3."DocNum",T3."DocDate",T2."Quantity",T3."U_NO_BOX",T3."U_TOT_WEIGHT",T3."U_TransporterName",T3."U_DocketNo",T3."U_E_WAY",

T3."U_E_WAY_D",T5."BPLName", T4."U_UNE_CCODE", T4."U_UNE_CNAME", --T4."U_UNE_DCDT", T3."U_ASN", T3."U_NOOFDAYS", T3."U_GS1P",

T3."U_GST1S", T3."U_GS2S", T3."U_GS1T",

T3."U_ABC",

T3."U_ARemark"

[Johan_H]

Hi,

The error seems self explanatory. The data type of the U_ARemark field cannot be used in the GROUP BY clause. It is probably a text or image field. This data type (BLOB) allows for too large data for a query to perform operations on (like grouping).

You need to leave it out, or convert it to limit its size for the purpose of the query.

Regards,

Johan