Skip to Content

Database table could not be deleted or recreated

Hi experts, we are having an issue in our Production system. Every week, a particular process chain is failing in the 'Delete Target Contents from DSO' step, with the message - "Database table could not be deleted or recreated". This is happening twice or thrice a week, where the process chain runs daily.

On repeating the failed step, the process chain runs successfully. But this is a recurring issue and should not be occurring. Does anybody have an insight on this?

Thanks in advance!

1.jpg (50.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 03, 2015 at 08:16 AM

    Hi

    did you tried RSRV checks for DSO?

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 03, 2015 at 08:59 AM

    Hi,

    From your error screen shot can you share Ltxt.

    Select failure/red message, at end click on yellow icon and see error details.

    Even Try to activate DSO tables thru SE14.

    With helo of basis or DB Team, please check a DB02.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Lets try thru SE14. Very careful while using SE14.

      Delete data from tables and activate it.

      Have you done compression?

      Recently any changes applied on your cube?

      What's your chain design? have any parallel steps?

      Try to see db object in consistence thru

      Tx - SE14, Enter F/E table name, click on edit, menu Extras-->db object-->check.

  • author's profile photo Former Member
    Former Member
    Posted on Apr 03, 2015 at 09:15 AM

    Hi,

    you can try with the se14 and there you can delete or regenerate any table.....

    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.