Skip to Content
author's profile photo Former Member
Former Member

Error while loading data into cube

When we try to load data into cube(0pur_c01) its giving this error

Return code 4 when converting field LOG_SYS in record

this LOG_SYS field id used in the following datasources: 0lis_02_itm,0lis_02_hdr,0lis_02_scl

Data records were selected in the PSA

Diagnosis

Data records were marked as incorrect in the PSA.

System Response

If error messages exist for the data records, the corresponding data packets were not updated using the PSA.

Procedure

Go into the PSA maintenance for the request and read the logged messages.

You find the relevant messages for each record in the PSA table by double-clicking on the status of the record.

Where necessary, edit the incorrect records or remove the error in another way.

Post the incorrect data packets manually.

Note that you are only permitted to edit and manually update the request if it is not contained in the request list in the InfoCube (see InfoCube administration). Where necessary, first delete it from the InfoCube.

Thanx in Advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 08:21 PM

    try deleting the assignment to log sy in the transfer rules and it should work

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 08:34 PM

    1. Make sure the source system connection is working. Go to the source system and right click and check.

    2. Replicate the DS and activate transfer rule using program RS_TRANSTRU_ACTIVATE_ALL

    and try to load gain.

    thanks.

    Wond

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2007 at 06:38 AM

    Hi,

    Tools-> Assignment of source system to source system ID

    In next Screen

    Can you see the ID in the 3rd column,If not goto edit menu->suggest source system ID

    Try to load again.

    Regards,

    Saran

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.