LOAD FAILING DAILY DUE TO #

[Former Member]

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

[former_member182470]

Hi,

Execute ALL_CAPITAL_PLUS_HEX in SE38 so that your "#" will be resolved.

Hope it helps.....

Regards,

Suman

[former_member182470]

Hi,

Sorry for my earlier reply. You have to run ALL_CAPITAL_PLUS_HEX in RSKC

Regards,

Suman

[Former Member]

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

[former_member186445]

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.

[Former Member]

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