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

error occur ODS to IC

Hi experts,

i am having an issue that i am getting invalid char from ods to IC

now i need to insert option that at processing step 1.psa & then data target.

for this i am unable to choose that because its in disable

i cant find that package in INFOSOURCE &not even find out that DS in SOURCE system under MODELING & mone thing that is of 8zgl_01 infosource where can i find that............

PLZ help it out

Regard's

venkat

Edited by: venkatesh.ravilla on Jun 28, 2011 7:49 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jun 28, 2011 at 06:00 AM

    not sure what you mean...but a here is a guess:

    when you load from dso to cube there is NO psa. the psa is only used when loading from an actual datasource.

    you can find the datasource (as a dso) under the datasources tree of your bi system.

    concerning your actual problem, invalid char: the fact that you only have this problem when loading to the cube and not to dso is because you have no sid generation in the dso.

    your solution is to figure out which char is invalid. delete the load from cube and dso. adapt the data in psa. reload the dso and further upload to the cube

    M.

    Add a comment
    10|10000 characters needed characters exceeded

    • i suppose the 200000 & 2nd is 9500000 is the number of records in the delta infopackage to the dso. that's what you see in the manage tab and this will be the number of records in the new data table of the dso. however when loading from dso to ic it's not the new data table that's used but the change log table. this table reflects the delta of the new data and the already active data. hence it's normal that you don't have the same number of records in the delta load towards the dso.

      M.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2011 at 05:57 AM

    Hello Venkatesh,

    Please check whether Update rules are active version between DSO and Cube , if not make the update rules as active. After making Update rules active then u create a new infopackage as per ur requirement and load the data.

    Regards,

    Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2011 at 07:41 AM

    Dear All,

    Here is a try and kindly find the below suggestions i have.

    1) to find the erroneous records use the tables

    RSERRORLOG to check error records RSERRORHEAD to check PSA records

    2) kindly try to load small chunks of data to DSO so tat error rectification can be fast and u can avoid short dump.

    Thanks and Kind Regards,

    Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2011 at 06:46 AM

    Thank's for your contrebution friend.

    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.