on 06-07-2011 8:34 AM
Hi Experts,
we are loading data from Application server in form of flat file but the load is failing daily.
error message shows below error
Value '
Characteristic value '641654' of characteristic ZADDR2 is not ALPHA-converted
Error when assigning SID (details in long text)
Error when assigning SID (details in long text)
Error when assigning SID (details in long text)
Activation of data records from ODS object terminated
*Error getting SID for ODS object *.
we have this ZADDR2 as Z characterstic with 60 characterl length and lower case is checked
We have written start routine also to check for # ! like characters
below is the routine
LOOP AT DATA_PACKAGE.
REPLACE ALL OCCURRENCES OF '%&()"''*+,-./:;<=>?_#~@!$^[]{}NULL'
IN DATA_PACKAGE-/BIC/ZADDR1 WITH ' '.
REPLACE '!' IN DATA_PACKAGE-/BIC/ZADDR1 WITH '1'.
REPLACE '!' IN DATA_PACKAGE-/BIC/ZADDR2 WITH '1'.
REPLACE '!' IN DATA_PACKAGE-/BIC/ZSRFLUP WITH '1'.
REPLACE '!' IN DATA_PACKAGE-/BIC/ZNTOFPR2 WITH '1'.
REPLACE '!' IN DATA_PACKAGE-/BIC/ZSUBJ WITH '1'.
CONDENSE DATA_PACKAGE-/BIC/ZADDR2 NO-GAPS.
IF DATA_PACKAGE-/BIC/ZINTR = '4370020'.
DATA_PACKAGE-/BIC/ZPRSLVC = ' '.
ENDIF.
REPLACE ALL OCCURRENCES OF '%&()"''*+,-./:;<=>?_#~@!$^[]{}NULL'
IN DATA_PACKAGE-/BIC/ZADDR2 WITH ' '.
but still we are getting # in the upload thereby resulting in failure
plz let me know the reason and how to correct that
do i need to write routine in update rules for this ZADDR2
plz suggest
Hi,
Execute ALL_CAPITAL_PLUS_HEX in SE38 so that your "#" will be resolved.
Hope it helps.....
Regards,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey,
maybe # is not really the problem because # symolized often a control character like carriage return and so on. You should check against RSKC using function RSKC_ALLOWED_CHAR_CHECK. I think in SDN you should find good functions using this function in the right context.
In spezial cases there is a class CL_ABAP_CHAR_UTILITIES from which you can use the attributes to delete # if you now what this # means.
Hope that helps.
Kind regards,
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Characteristic value '641654' of characteristic ZADDR2 is not ALPHA-converted
this issue is to be solve by flagging the checkbox 'conversion' in the transfer rule of ZADDR2.
try this first and see if the load is successful
M.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
this is already checked Sir
transfer rules is also having start routine given below
DATA: l_s_datapak type TRANSFER_STRUCTURE,
l_s_errorlog TYPE rssm_s_errorlog_int,
var1 type i,
VAR2 TYPE I.
BREAK-POINT.
LOOP AT DATAPAK INTO l_s_datapak.
var1 = strlen( l_s_datapak-/BIC/ZADDR2 ).
VAR2 = strlen( l_s_datapak-/BIC/ZNTOFPR2 ).
IF var1 = 1.
l_s_datapak-/BIC/ZADDR2 = ' '.
endif.
IF VAR2 = 1.
l_s_datapak-/BIC/ZNTOFPR2 = ' '.
endif.
Replace all OCCURRENCES of '#' in l_s_datapak-/BIC/ZADDR2
with space.
please suggest now
thanks
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.