Data Load Failures in SAP BW due to Invalid characters

from  http://scn.sap.com/docs/DOC-45073


This document is based on my experience with two issues we faced in two different production environments. This issue we faced with BW 3.x and 7.x objects.

Issue1 – In PSA we received some error records which were showing # value but which can be seen only in edit mode of record.  In the cube data was failing in activating in some of the data packets. This issue started after support pack upgrade in one of over production environment. Earlier error data records used to move to PSA fledge and we used to edit and correct. After support pack upgrade those records stopped moving into PSA fledge.

SAP suggested us to implement following SAP note.

1734721 - Improved error handling in RSAR_TRFC_DATA_RECEIVED

Issue resolved by making following change in the Infopackage

Screenshot1.PNG

 

Post above setting of Consistency check in transfer rule error data records started moving into PSA fledge. This setting can be done if we face issue with 3.x data flow objects.

 

Issue 2- We faced issue in another environment where DSO activation was failing continuously in 7.x data flow. Data was getting loaded successfully but it was failing during activation.

 

Screen shot2.PNG

 

 

Above error was occurring due to non printable charaters generating due to usage of key like Alt,Tab etc.

We tried two function modules.

SCP_REPLACE_STRANGE_CHARS and SF_SPECIALCHAR_DELETE .

 

The function module worked in our case which changes character to .(Dot) value and you can enhance further to replace these dot.

 

Also you can put following ABAP code in your field routine to resolve your issue of data loads/activation due to non printable charaters.

 

replace all occurrences of regex '[^[:print:]]+(?!$)' in Result with ` `.

replace all occurrences of regex '[^[:print:]]+$' in Result with ''.

 

 

There are other methods we tried as follows

1.     1.   Setting in error handling in case of Infopacakages

2.      2.  Setting of error DTPs to get error data records in error PSA.



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值