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

ODS activation falilure

Dear Experts

im getting the following error when activating the ODS.Im here by providing you the list of error messages.I have checked data in PSA there are no errors.Errors occur when i try to activate the data in ODS.

Request REQU_41M8WINWEIOHTV72ABVY7ZK9N , data package 000001 incorrect with status 9

Request REQU_41M8WINWEIOHTV72ABVY7ZK9N , data package 000001 not correct

Inserted records 1- ; Changed records 1- ; Deleted records 1-

No confirmation for request ODSR_41MADFG820OVP3WC2PMKISP5N when activating the ODS object XCCC_O05

Communication error (RFC call) occurred

Activation of data records from ODS object XCCC_O05 terminated

Activation of data records from ODS object XCCC_O05 terminated

Thanks in Advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 29, 2006 at 12:19 PM

    Hi Ellora,

    There could be 2 reasons for this:

    1. Tablespace Issue: You may run out of tablepace. Just check the tablespace in DB02 and contact your BASIS to extend this.

    2. Special Characters in your ODS which is preventing the activation.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 29, 2006 at 10:09 AM

    Hi

    check in SM21 for further details, Also check if there is any shortdump..And could you let us know what kind of data r u pulling it to ODS..How long did it take to pull the records? Have you check in settings of ods set quality status to OK.

    Regards

    Ram

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Ram

      i have checked with SM21 and ST 22

      im providing you the message :

      SM21 :

      Database error 1502 at INS access to table /BIC/B0001

      ORA-01502: index 'SAPBD1./BIC/B0001608000~0' or partition of 75

      Run-time error "DBIF_RSQL_SQL_ERROR" occurred

      ST22 :

      The exception must either be prevented, caught within the procedure

      "INSERT_ODS"

      "(FORM)", or declared in the procedure's RAISING clause.

      To prevent the exception, note the following:

      Database error text........: "ORA-01502: index 'SAPBD1./BIC/B0001608000~0' or

      partition of such index is in unusable state"

      Internal call code.........: "[RSQL/INSR//BIC/B0001608000 ]"

      i guess this might be of some help in resolving the problem.

      Thanks in advance.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2006 at 02:00 AM

    Oracle is tellin gyou the index, or at least one partition, is in an unusable state. There are probably half a dozen possible causes. The resolution is to either drop and recerate or rebuild the index or at least that partition's index.

    It's worth a review of OSS Notes - I don't know if there is anything out there to address this. Best bet is have your DBA take a look and they'll probably go ahead and rebuild the index.

    Oracle Error Messages are on the internet lots of places, you can try Googling ORA-1502.

    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.