10 Replies Latest reply: Apr 11, 2013 1:36 AM by ZairS. RSS

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

    413032
      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
          Sergio-Oracle
          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
            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
              Sergio-Oracle
              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
                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
                  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
                    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
                      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
                        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.
                          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.
                            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.