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

SQL Error 8103 while data loading

Posted on Nov 18, 2011 at 11:30 AM 609 Views

Hi all,

We were loading data to a cube by an IP during which we faced an error. For that moment , the old request was deleted from target and step was repeated and chain got completed successfully. But I want to know why did error happened ? I was unable to get much information regarding this issue.

Error Messages ::

1) SQL Error:8103

2) Errors in source system

3) ORA-08103 : object no longer exists

I also looked into sm21 and found " Database error 8103 at FET" . Main points I want to know about this are ::

1) why this error occured ?

2) what is proper solution for the same ?

Regards,

Arpit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 12:18 PM
    1

    Check Note No. 1144558, This error came during reorganisine the table space.

    Regards,

    Sushant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 07:59 AM
    1

    Hi Arpit,

    For the error ORA-08103: object no longer exists, find the below details for cause and solution.

    Cause: The object has been deleted by another user since the operation began, or a prior incomplete recovery restored the database to a point in time during the deletion of the object.

    Action: Delete the object if this is the result of an incomplete recovery and Remove references to the object.

    Also check the below link..

    http://www.dba-oracle.com/t_ora_08103_object_no_longer_exists.htm

    Regards,

    NIKHIL

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Lars Breddemann
    Lars Breddemann
    Posted on Nov 21, 2011 at 05:23 PM
    1

    Hello Arpit,

    besides the already mentioned possible reasons, you will want to make sure that your Oracle database is on the most current SAP Bundle Patch and that the parameters are set correctly.

    Given that, the error shouldn't reoccur.

    regards,

    Lars

    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.