Loading errors..

[Former Member]

Hi All,

I am loading Vendor master data thru PSA then Infoobject.

I got some errors :1 to 4

=====================================

1. InfoObject /BIC/VEN_NAME1 contains value 22345 , which is not conversion exit compliant

=========================================

2. Too many error records - update terminated

Diagnosis

More than 1 records were marked as incorrect. A systematic error

probably exists.

System Response

The update and further check was terminated due to reasons of

performance.

Procedure

The errors that have arisen up until now are displayed in the PSA.

Analyze and correct the errors and start the update again.

Procedure for System Administration

========================================

3. InfoObject VEN_NAME1 contains invalid characters in record 3 in value ' '

Diagnosis

To guarantee the consistency of the InfoCube, you are not allowed to use

lowercase letters and certain special characters in the specified

InfoObject.

The BW Customizing Implementation Guide tells you how to maintain

permitted additional characters.

System Response

Procedure

In the specified record, check the corresponding field for:

capital/lowercase letters,

special characters that are not permitted,

the plausibilty of date and time entries, and

the correct observance of the ALPHA conversion routine.

Correct the field contents accordingly, and restart the load process

=====================================

4. Error 1 in the update

Diagnosis

The update delivered the error code 1 .

Procedure

You can find further information on this error in the error message of the update.

=====================

for some objects I did :

I checked lower case letters button in Infoobjects general section, it asks uncheck master/ text checkboxex in Master/Text section.

for some objects I did :

In transfer rules i wrote routine :

RESULT = TRAN_STRUCTURE-LOCATION.

TRANSLATE RESULT TO UPPER CASE.

Can you please explain 1 to 4.

How to resolve my problems?

Thanks in advance.

Siri

[Former Member · Accepted solution]

In the 1st one,the infoobject has alpha conversion set on it,but the value for it,coming in the source system records is not alpha-conversion compliant.In the transfer rules,in the lower screen,left hand tab,at the end u will have a checkbox for automatically applying the required alpha conversion.Tick that and then reactivate transfer rules and then load.It should solve the issue.

In the 2nd one,its std messsage for multiple errors in data load.Go to monitor entry for the failed data load,view the PSA records and sort them by status(LED field).Double click on the LED's of the RED records.It will give u the error message for each record.U will need to correct PSA in order to reload.But remember u cannot edit PSA unless request is backed out from the data target..

In the 3rd one,records are sending some special characters or invalid characters..Check the PSA to see what is invalid.If u feel that the special character is a valid one,u can add it to special characters list in t-code RSKC.

cheers..

Vishu

[Former Member]

Hi VC,A.H.P, Praveen,Vishesh,

Thanks to you all.

VC:

If change it to upper case , those will maintanian in CUBE and Bex reports also Uppercase leeters?

If I checked lower case letters button in Infoobjects general section, it asks uncheck master/ text checkboxes in Master/Text section.

When will we use this Lower case check option?

Please explian the below.

<i>To guarantee the consistency of the InfoCube, you are not allowed to use lowercase letters and certain special characters in the specified InfoObject.</i>

Thanks & Regards,

Siri

[Former Member]

Hi,

I hope, 0VENDOR data target already has the records .So delete all records from 0VENDOR and make the setting for lower case.

With rgds,

Anil Kumar Sharma .P

[edwin_harpino]

hi Siri,

1. you can mark in transfer rules, last column 'conversion'.

3. maintain RSKC with ALL_CAPITAL to allow special characters. for lower case, yes you can use translate to upper case.

check if more detail error in st22 and sm21, also sm37 job log. and take a look Siggi's weblog

/people/siegfried.szameitat/blog/2005/07/28/data-load-errors--basic-checks

hope this helps.

[Former Member]

Hi,

In transfer rules tick the 'conversion' coloumn for the respective info object.

Hope this helps

[Former Member]

Hi,

from your source system "name" has lower case letters as well, change those to upper case.

go to transfer rules, use funtion "UPPER" ( delivered by SAP to convert you text field like name to upper letters.

you can go to PSA & check the errord record ( Red color)

as well to get an idea of error.

hope it helps

regards

VC