点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)专家您好, 已完成以下升级操作...
点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)专家您好, 已完成以下升级操作...
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
专家您好,
已完成以下升级操作:
FC 10.0 SP 17补丁01 ==> FC 10.0 SP 19
FIM 10.0 SP 14 ==> FIM 10.0 SP 16
DS 4.2 SP 06 ==> DS 4.2 SP 08
IPS 4.1 SP 07 ==> IPS 4.1 SP 09
用于BI 4.1 SP 07 Windows的UMC 10.0 ==>用于BI 4.1 SP 09 Windows的UMC 10.0。 该数据库是Oracle 11g R2
问题在升级后显示。
FIM作业状态正常,但是当我们尝试显示新日志或旧日志中的导入行或拒绝行时,会出现以下错误:
操作期间出现错误:"获取导入的行而没有映射错误"-在针对''表执行SQL语句时。
org.springframework.jdbc.UncategorizedSQLException:StatementCallback; SQL的未分类SQLException [SELECT" CA"," DP"," PE"," RU"," AC"," FL"," AU"," CU",SUM(CAST(REPLACE(" AMOUNT",'。 ','。 DIMENSION_INDEX = FRRD.DIMENSION_INDEX FRRC.JOB_RUN_ID IN(2147483542)FRRC.JOB_RUN_ID,FRRC.ROW_ID GROUP = 1 = MAX(当UPPER(FRRD.DIMENSION_NAME)= N'CA'THE CORCLESCE。 ,''),N'_')END)= COALESCE(NULLIF(" CA",''),N'_')和MAX(当UPPER(FRRD.DIMENSION_NAME)= N'DP'时的情况THEN COALESCE(NULLIF (FRRC.DIMENSION_VALUE,''),N'_')END)= COALESCE(NULLIF(" DP",''),N'_')和MAX(当UPPER(FRRD.DIMENSION_NAME)= N'PE'时的情况 THEN COALESCE(NULLIF(FRRC.DIMENSION_VALUE,``),N'_')END)= COALESCE(NULLIF(" PE",``),N'_')and MAX(当UPPER(FRRD.DIMENSION_NAME)= N'R U'THEN COALESCE(NULLIF(FRRC.DIMENSION_VALUE,``),N'_')END)= COALESCE(NULLIF(" RU",''),N'_')和MAX(当UPPER(FRRD.DIMENSION_NAME) )= N'AC'THEN COALESCE(NULLIF(FRRC.DIMENSION_VALUE,''),N'_')END)= COALESCE(NULLIF(" AC",''),N'_')AND MAX(UPPER时的情况 (FRRD.DIMENSION_NAME)= N'FL'THEN COALESCE(NULLIF(FRRC.DIMENSION_VALUE,``),N'_')END)= COALESCE(NULLIF(" FL",``),N'_')AND MAX (当UPPER(FRRD.DIMENSION_NAME)= N'AU'THEN COALESCE(NULLIF(FRRC.DIMENSION_VALUE,``),N'_')END时的情况)= COALESCE(NULLIF(" AU",''),N'_ ')AND MAX(当UPPER(FRRD.DIMENSION_NAME)= N'CU'时的情况;然后COALESCE(NULLIF(FRRC.DIMENSION_VALUE,``),N'_')END)= COALESCE(NULLIF(" CU",'') ,N'_'))GROUP BY" CA"," DP"," PE"," RU"," AC"," FL"," AU"," CU"]; SQL状态[72000]; 错误代码[12704]; ORA-12704:字符集不匹配
; 嵌套的异常是java.sql.SQLException:ORA-12704:字符集不匹配
java.sql.SQLException:ORA-12704:字符集不匹配
感谢您的帮助,
您好Ayoub
此问题已报告给SAP,似乎是一个错误,已在SP16中引入
SQL语句不正确,应该是
and MAX(当大写(FRRD.DIMENSION_NAME)= N'CA'时的情况;然后COALESCE(NULLIF(FRRC.DIMENSION_VALUE,N''),N'_')END)= COALESCE(NULLIF(" CA",N" ),N'_')
Marc
一周热门 更多>