Procedure RETAILPRODUCTCATEGORYVIEW, Line 1'CONCAT' is not a recognized built-in function name.

(1) Share

Report

Posted on by E. R.

739

Dears,

Please note that i installed the CU12 on ax2012 R3 but when sychronizing the database the following error appears:

Msg 195, Level 15, State 10, Procedure RETAILPRODUCTCATEGORYVIEW, Line 1
'CONCAT' is not a recognized built-in function name.

CREATE VIEW "DBO".RETAILPRODUCTCATEGORYVIEW AS SELECT T1.CATEGORY AS CATEGORY,T1.PRODUCT AS PRODUCT,T1.PARTITION AS PARTITION,T1.RECID AS RECID,T2.PARTITION AS PARTITION#2,T3.PARTITION AS PARTITION#5,T4.PARTITION AS PARTITION#6,T4.NAME AS CATEGORYNAME,T5.PARTITION AS PARTITION#3,T5.NAME AS PRODUCTNAME,T6.PARTITION AS PARTITION#4,(CAST ((CONCAT('"Category=',T1.CATEGORY,',ParentCategory=',T4.PARENTCATEGORY,'"')) AS NVARCHAR(1260))) AS FEATURESLIST FROM ECORESPRODUCTCATEGORY T1 CROSS JOIN ECORESPRODUCT T2 CROSS JOIN ECORESCATEGORYHIERARCHY T3 CROSS JOIN ECORESCATEGORY T4 CROSS JOIN ECORESPRODUCTTRANSLATION T

noting that i am using SQL 2008 R2.

Regards,

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Mea_ 60,284 on at

Like (0)

Report

Looks like a bug, log it with MS, meanwhile you can try to edit view definition to get rid of CONCAT or replace it with {fn CONCAT(id1,id2)}

Was this reply helpful? Yes No