6 Replies Latest reply: Jan 11, 2012 2:42 AM by Tobias Arnhold RSS

    unique constraint www_flow_data_idx1 violated

      Almost every time I log in to apex 4.0 as a developer database win32, the first thing I do returns an error like:

      ORA-00001: unique constraint (APEX_040000.WWV_FLOW_DATA_IDX1) violated

      ERR-1029 Unable to store session info. session=2304889538211833 item=197616916753523211

      Even if the machine was shut down to a complete shutdown this happens (a plague on these constant
      thunderstorms here :-)

      Edited by: lake on Jul 23, 2010 10:48 AM
        • 1. Re: unique constraint www_flow_data_idx1 violated
          Well I can say that having patched to I still get this error just from logging in as a developer.

          ORA-00001: unique constraint (APEX_040000.WWV_FLOW_DATA_IDX1) violated

          ERR-1029 Unable to store session info. session=1495664881305811 item=123520011050707326

          I should mention this is the embedded plsql gateway. The database is
          I was using firefox 3.6.8 on 2003 r2 32 bits.

          Oh I see this has been going on for years:
          WWV_FLOW_DATA_IDX1 - unique constraint violated

          What a long lasting bug!
          • 2. Re: unique constraint www_flow_data_idx1 violated
            Tobias Arnhold

            I'm getting the same error:
            ORA-00001: unique constraint (APEX_040000.WWV_FLOW_DATA_IDX1) violated
            ERR-1029 Speichern von Sessioninformationen nicht möglich. session=1221664983920134 item=231471825010190197  
            Version 4.0.2
            Browser: IE 6

            if this is a long running problem is there at least a workaround available or a description what describes the background situation more clearly?

            Best regards,

            • 3. Re: unique constraint www_flow_data_idx1 violated
              Same problem, but in french ;-)

              ORA-00001: violation de contrainte unique (APEX_040000.WWV_FLOW_DATA_IDX1)

              ERR-1029 Impossible de stocker les infos de session. session=4938036086703397 élément=21148856534046941

              Since the last user seems to work in german, and I work in french, could the problem be related to the fact that language is not english (date format maybe)?
              • 4. Re: unique constraint www_flow_data_idx1 violated
                Tobias Arnhold
                I still get this error sometimes. Often in combination of Iframes and item computations or collections

                To check which item is effected try this:
                ORA-00001: unique constraint (APEX_040000.WWV_FLOW_DATA_IDX1) violated
                ERR-1029 Speichern von Sessioninformationen nicht möglich. session=3642920897355064 item=9815904291046405 
                Application > Utilities > Application Express Views > APEX_APPLICATION_PAGE_ITEMS
                Columns: Select all columns
                Filter: Item_ID = 9815904291046405
                Copy the generated select and execute it inside your SQL Developer:
                from APEX_APPLICATION_PAGE_ITEMS
                where ITEM_ID = 9815904291046405 
                It is not the solution but the way to the reason of your problem! :)

                • 5. Re: unique constraint www_flow_data_idx1 violated
                  Tobias Arnhold
                  I found some interesting posts about the issue:
                  DEADLOCK DETECTED ==> wwv_flow_data
                  WWV_FLOW_DATA_IDX1 - unique constraint violated

                  Workaround in one case:
                  "I set up first_time as database field and hidden item instead of text field and CSS style of display:none. It now works. This way i did not need to keep the session, since the hidden field gets the data from the database (if null) anyway."

                  Edited by: Tobias Arnhold on Jan 11, 2012 9:15 AM
                  • 6. Re: unique constraint www_flow_data_idx1 violated
                    Tobias Arnhold
                    We have this issue now on our login page in our APEX 4.0 instance. The effected item is P101_USERNAME and the effected browser is only Internet Explorer (6-8).
                    The issue occurs when I click on login. We do use a standard login procedure with APEX authentification. We also get two different errors:
                    1 error is:
                    Benachrichtigung zu Fehler bei Inhalt von Prüfsumme (Checksum): : 9E5280F59582F016673BD02895369EDF  
                    2 error is:
                    ORA-00001: Unique Constraint (APEX_040000.WWV_FLOW_DATA_IDX1) verletzt 
                    ERR-1029 Speichern von Sessioninformationen nicht möglich. session=1667913485168599 item=231471825010190197  
                    This item 231471825010190197 is P101_USERNAME

                    When I check the issue I find a row inside wwv_flow_data:
                    select * from APEX_040000.WWV_FLOW_DATA
                    where item_id = 231471825010190197
                      and flow_instance = 1667913485168599 
                    We always open the page like this:

                    I don't understand why it happen on the login page?