0
Answer

Error - not a valid number string '10, 10' at implicit type conversion

Photo of Ramco Ramco

Ramco Ramco
1d
59
1

Hi

  In below query i am getting error - 

1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;339 invalid number: not a valid number string '10, 10' at implicit type conversion  'Backend scheduling job' (OBSJ) (at pos 97)

WHEN T1."TransType" = '1470000049' THEN 
(
    SELECT STRING_AGG(TO_NVARCHAR(OL."Code"), ', ')
    FROM OITM A11
    JOIN OLCT OL ON OL."Code" = A11."Location"
    WHERE A11."ItemCode" IN (
        SELECT DISTINCT A0."ItemCode" 
        FROM ACQ1 A0 
        WHERE A0."DocEntry" = T1."CreatedBy" 
          AND A0."ObjType" = '1470000049'
    )
)

Thanks

Next Recommended Forum