This discussion is archived
10 Replies Latest reply: Apr 10, 2013 11:36 PM by ZairS. RSS

Current version of data in database has changed since user initiated update

413032 Newbie
Currently Being Moderated
I'm getting this error following an update or delete ?

ORA-20001: Error in DML: p_rowid=21, p_alt_rowid=ID, p_rowid2=, p_alt_rowid2=. ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "1FFA33DC4A60C98933B2BE9961D15CDA" application checksum = "0"
  • 1. Re: Current version of data in database has changed since user initiated up
    202811 Employee ACE
    Currently Being Moderated
    sounds like either:

    1) someone else is editing the same thing you are editing; or more likely
    2) your browser's cache settings are causing you to look at an old version of an edit page.

    The message you're seeing is preventing you from saving old data over new data. Check to see if your browser checks for updated pages every time rather than "automatically"
  • 2. Re: Current version of data in database has changed since user initiated up
    413032 Newbie
    Currently Being Moderated
    1) No one else is editing this table.

    2) The browser settings are check every time.

    A developer here has seen this before, but in Oracle forms ?
  • 3. Re: Current version of data in database has changed since user initiated up
    202811 Employee ACE
    Currently Being Moderated
    Are you getting this error every time? Can you try to <Shift>-Reload the page before you submit it?
  • 4. Re: Current version of data in database has changed since user initiated up
    413032 Newbie
    Currently Being Moderated
    Yep just tried that, but this time trying to delete the record.

    "Current version of data in database has changed since user initiated update process."


    However if this helps we have a sperate schema / user that has been granted select,insert,update and delete to the actual owner schema / user of the table.

  • 5. Re: Current version of data in database has changed since user initiated up
    255912 Newbie
    Currently Being Moderated
    Is this on an tabular form (updateable sql)? If so, make sure that your column aliases match your column names (for updateable columns). If they don't match you get this error.
  • 6. Re: Current version of data in database has changed since user initiated up
    BillC Newbie
    Currently Being Moderated
    Thank you... this posting just helped me!
    I had built a master-detail with original SQL as below:

    select "ID", "ORDER_ID", "PROD_ID", "SHIP_DATE",
    "RETURN_DATE", "QNTY_ORDERED", "QNTY_SHIPPED"
    from LS_ORDER_ITEM
    where "ORDER_ID" = :P10_ID

    To get my product name and qnty on hand to show I joined my products table:
    select "O"."ID", "ORDER_ID", "P"."PROD_ID", "SHIP_DATE",
    "RETURN_DATE", "QNTY_ORDERED", "QNTY_SHIPPED",
    "PROD_NAME", "QNTY_ON_HAND"
    from LS_ORDER_ITEM O, LS_PRODUCTS P
    where P.ID1 = O.PROD_ID AND "ORDER_ID" = :P10_ID

    BUT it stopped updating - I was getting the error in "Subject"
    "make sure that your column aliases match your column names (for updateable columns). "

    "PROD_ID" is an updateable column but I was displaying "P"."PROD_ID" from the products table. I changed it to "O"."PROD_ID" and it worked fine!

    (This is posted for all those newbies like me that find this in the future...)

    Bill :>)
  • 7. Re: Current version of data in database has changed since user initiated up
    571471 Newbie
    Currently Being Moderated
    Hi,

    If you could help. I am getting the same MRU error. My regions query is:
    select
    "MS_YEAR_PLAN_ID",
    "MS_YEAR_PLAN_ID" MS_YEAR_PLAN_ID_DISPLAY,
    "YEAR",
    "YP"."MS_PROGRAM_ID",
    "YP"."MS_EVENT_TYPE_ID",
    "JANUARY_QUANTITY",
    "FEBRUARY_QUANTITY",
    "MARCH_QUANTITY",
    "APRIL_QUANTITY",
    "MAY_QUANTITY",
    "JUNE_QUANTITY",
    "JULY_QUANTITY",
    "AUGUST_QUANTITY",
    "SEPTEMBER_QUANTITY",
    "OCTOBER_QUANTITY",
    "NOVEMBER_QUANTITY",
    "DECEMBER_QUANTITY",
    nvl(January_Quantity,0) + nvl(February_Quantity,0) + nvl(March_Quantity,0)
    + nvl(April_Quantity,0) + nvl(May_Quantity,0) + nvl(June_Quantity,0)
    + nvl(July_Quantity,0) + nvl(August_Quantity,0) + nvl(September_Quantity,0)
    + nvl(October_Quantity,0) + nvl(November_Quantity,0)
    + nvl(December_Quantity,0) "Yearly_Total",
    "YP"."UPDATE_DATE",
    "YP"."UPDATE_BY_USER_NAME"
    from MS_YEAR_PLAN YP, MS_PROGRAM P
    where yp.Year = :P7_DL_YEAR
    and P.BUSINESS_AREA_ID = :P7_DL_BUSINESS_AREA
    and YP.MS_PROGRAM_ID = P.MS_PROGRAM_ID
    and ((yp.ms_event_type_id = 1 and p.event_type_review = 'Y') OR (yp.ms_event_type_id = 2 AND p.event_type_dev = 'Y') OR (yp.ms_event_type_id = 3 AND p.event_type_oper = 'Y') OR
    (nvl(January_Quantity,0) + nvl(February_Quantity,0) + nvl(March_Quantity,0)
    + nvl(April_Quantity,0) + nvl(May_Quantity,0) + nvl(June_Quantity,0)
    + nvl(July_Quantity,0) + nvl(August_Quantity,0) + nvl(September_Quantity,0)
    + nvl(October_Quantity,0) + nvl(November_Quantity,0)
    + nvl(December_Quantity,0)) > 0)
    -- AND
    -- instr(UPPER(p.PROGRAM_NAME), UPPER(nvl(:P7_SEARCH, p.program_name))) > 0
    order by
    P.PROGRAM_NAME, YP.MS_EVENT_TYPE_ID

    Any suggestions would be appreciated.

    Thanks,

    Mike
  • 8. Re: Current version of data in database has changed since user initiated up
    542307 Newbie
    Currently Being Moderated
    i know this is very late in response, but is there a non displayed row selector? if so, try deleting it and resubmitting your transaction.
  • 9. Re: Current version of data in database has changed since user initiated up
    ZairS. Newbie
    Currently Being Moderated
    I had this error for 2 days. As an application developer I could not find the exact case from the forum or elsewhere on the web. As the matter of fact I found it recently. From where? From Enterprice manager. Tablespace is full. After adding memory the error "Current Version Of Data In Database Has Changed Since User Initiated Update" has gone. The error or exception thrown from DB is pretty annoying and misunderstanding. If the error was something related memory problem or not enough memory I could resolve it in minutes. Using APEX as developer by time we are getting closer to database administrator role.
  • 10. Re: Current version of data in database has changed since user initiated up
    ZairS. Newbie
    Currently Being Moderated
    After memory addition to tablespace my problem not solved at all. Some transactions gave the error and some did not. So, my previous thesis is wrong.

    It is 4th day I am on this problem and I solved it by remaking primary key.