Skip to Content
avatar image
Former Member

Entry already exists

Hi,

I am facing the problem when trying to enter new production order. When clicking on add button it is throwing error "This entry already exists in the following tables(OWOR)". Kindly give me the soltuion. our client was unable proceed further due to this. Their live system is stopped now.

Thanks,

Sravan Kumar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 11, 2008 at 04:53 PM

    Dear Saravan,

    In that case, kindly followup for this issue in the message you have raised as mentioned in above communications.

    Regards,

    Raghu N

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2008 at 03:05 PM

    Dear Sravan,

    The issue you are having is due to the corruption in the database.

    Please run the following select query :

    "Select *

    from WOR1

    where Docentry not in (Select Docentry from OWOR)"

    In case you got any results, please log a message for SAP support on the channel partner portal.

    Please check Note no 1060000 for more information on this issue

    Also you try to create a new numbering series.

    Regads,

    Vikas Rastogi

    Edited by: Vikas Rastogi on Sep 11, 2008 5:10 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sravan,

      When the Production DB is down it is not a time to WAIT. I would suggest you escalate this to SAP Support and mark this as High Priority.

      Please check if you have any code in the SBO_SP_TransactionNotification stored procedure which code cause this.

      When did this start happening?

      Is it for all users?

      Are you using the latest patch for your localization?

      Suda

  • avatar image
    Former Member
    Sep 11, 2008 at 12:57 PM

    Hi Sravan

    There is possibly an error in the document numbering table on SAP Business One. You will need to log this with SAP on the portal.

    Kind regards

    Peter Juby

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2008 at 01:39 PM

    Dear Sravan Kumar,

    Please add a new Number series with Higher series to the existing one as a workaround.

    Regards,

    Raghu N

    SAP Business One Forums Team

    Add comment
    10|10000 characters needed characters exceeded