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

    unique constraint www_flow_data_idx1 violated

    lake
      Almost every time I log in to apex 4.0 as a developer 11.2.0.1.0 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
          lake
          Well I can say that having patched to 4.0.1.00.33 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 11.2.0.1.0
          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
            Hi,

            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,

            Tobias
            • 3. Re: unique constraint www_flow_data_idx1 violated
              Paulo
              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:
                select WORKSPACE,APPLICATION_ID,APPLICATION_NAME,PAGE_ID,PAGE_NAME,ITEM_NAME,DISPLAY_AS,DISPLAY_AS_CODE,ITEM_DATA_TYPE,IS_REQUIRED,STANDARD_VALIDATIONS,DISPLAY_SEQUENCE,REGION,REGION_ID,SOURCE_USED,ITEM_DEFAULT,ITEM_DEFAULT_TYPE,LABEL,PRE_ELEMENT_TEXT,POST_ELEMENT_TEXT,FORMAT_MASK,ITEM_LABEL_TEMPLATE,ITEM_LABEL_TEMPLATE_ID,ITEM_SOURCE,ITEM_SOURCE_TYPE,ENCRYPT_SESSION_STATE,SOURCE_POST_COMPUTATION,READ_ONLY_CONDITION_TYPE,READ_ONLY_CONDITION_EXP1,READ_ONLY_CONDITION_EXP2,READ_ONLY_DISPLAY_ATTR,LOV_NAMED_LOV,LOV_DEFINITION,LOV_DISPLAY_EXTRA,LOV_DISPLAY_NULL,LOV_NULL_TEXT,LOV_NULL_VALUE,LOV_QUERY_RESULT_TRANSLATED,LOV_CASCADE_PARENT_ITEMS,AJAX_ITEMS_TO_SUBMIT,AJAX_OPTIMIZE_REFRESH,ITEM_ELEMENT_WIDTH,ITEM_ELEMENT_MAX_LENGTH,ITEM_ELEMENT_HEIGHT,HTML_TABLE_CELL_ATTR_LABEL,HTML_TABLE_CELL_ATTR_ELEMENT,HTML_FORM_ELEMENT_ATTRIBUTES,FORM_ELEMENT_OPTION_ATTRIBUTES,ITEM_BUTTON_IMAGE,ITEM_BUTTON_IMAGE_ATTRIBUTES,BEGINS_ON_NEW_ROW,BEGINS_ON_NEW_CELL,COLUMN_SPAN,ROW_SPAN,LABEL_ALIGNMENT,ITEM_ALIGNMENT,SHOW_QUICK_PICKS,QUICK_PICK_LINK_ATTR,QUICK_PICK_LABEL_01,QUICK_PICK_VALUE_01,QUICK_PICK_LABEL_02,QUICK_PICK_VALUE_02,QUICK_PICK_LABEL_03,QUICK_PICK_VALUE_03,QUICK_PICK_LABEL_04,QUICK_PICK_VALUE_04,QUICK_PICK_LABEL_05,QUICK_PICK_VALUE_05,QUICK_PICK_LABEL_06,QUICK_PICK_VALUE_06,QUICK_PICK_LABEL_07,QUICK_PICK_VALUE_07,QUICK_PICK_LABEL_08,QUICK_PICK_VALUE_08,QUICK_PICK_LABEL_09,QUICK_PICK_VALUE_09,QUICK_PICK_LABEL_10,QUICK_PICK_VALUE_10,ATTRIBUTE_01,ATTRIBUTE_02,ATTRIBUTE_03,ATTRIBUTE_04,ATTRIBUTE_05,ATTRIBUTE_06,ATTRIBUTE_07,ATTRIBUTE_08,ATTRIBUTE_09,ATTRIBUTE_10,CONDITION_TYPE,CONDITION_EXPRESSION1,CONDITION_EXPRESSION2,MAINTAIN_SESSION_STATE,ITEM_PROTECTION_LEVEL,ESCAPE_ON_HTTP_OUTPUT,AUTHORIZATION_SCHEME,AUTHORIZATION_SCHEME_ID,BUILD_OPTION,BUILD_OPTION_ID,ITEM_HELP_TEXT,LAST_UPDATED_BY,LAST_UPDATED_ON,COMPONENT_COMMENT,ITEM_ID,COMPONENT_SIGNATURE
                from APEX_APPLICATION_PAGE_ITEMS
                where ITEM_ID = 9815904291046405 
                It is not the solution but the way to the reason of your problem! :)

                Tobias
                • 5. Re: unique constraint www_flow_data_idx1 violated
                  Tobias Arnhold
                  I found some interesting posts about the issue:
                  https://kr.forums.oracle.com/forums/thread.jspa?threadID=2289819&tstart=0&messageID=9896349
                  DEADLOCK DETECTED ==> wwv_flow_data
                  https://kr.forums.oracle.com/forums/thread.jspa?threadID=615993
                  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 
                    Return:
                    FLOW_INSTANCE;ITEM_ID;ITEM_ELEMENT_ID;ITEM_FILTER;SESSION_STATE_STATUS;FLOW_ID;ITEM_NAME;NAME_LENGTH;IS_ENCRYPTED;ITEM_VALUE
                    1,6679134851686E15;2,3147182501019E17;1;N;R;100;P101_USERNAME;;N;
                    We always open the page like this:
                    http://<server>:8080/pls/apex/f?p=100:1

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