We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-3864

Migrating from HSQLDB fails when constraints are violated

      If you try to store a review title that is > 255 characters it is not saved and there is no indication of failure in the UI.

      The logs dump something like:

      Caused by: java.sql.BatchUpdateException: Batch entry 0 update cru_review set cru_review_type='1', cru_name='0123456789012345.....6789', cru_default_source='BranchTest', cru_state='Review', cru_description='SAMPLE-1
      TST-1
      
      ', cru_summary=NULL, cru_allow_reviewer_to_join='1', cru_create_date='1280381875156', cru_metrics_version='1', cru_all_reviewers_complete='1', cru_due_date='1280986675000', cru_issue_key='TST-1', cru_parent_review=NULL, cru_creator='2', cru_project='1' where cru_review_id='1' was aborted.  Call getNextException to see the cause.
              at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            Uploaded image for project: 'Crucible'
            1. Crucible
            2. CRUC-3864

            Migrating from HSQLDB fails when constraints are violated

                If you try to store a review title that is > 255 characters it is not saved and there is no indication of failure in the UI.

                The logs dump something like:

                Caused by: java.sql.BatchUpdateException: Batch entry 0 update cru_review set cru_review_type='1', cru_name='0123456789012345.....6789', cru_default_source='BranchTest', cru_state='Review', cru_description='SAMPLE-1
                TST-1
                
                ', cru_summary=NULL, cru_allow_reviewer_to_join='1', cru_create_date='1280381875156', cru_metrics_version='1', cru_all_reviewers_complete='1', cru_due_date='1280986675000', cru_issue_key='TST-1', cru_parent_review=NULL, cru_creator='2', cru_project='1' where cru_review_id='1' was aborted.  Call getNextException to see the cause.
                        at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)
                        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796)
                        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
                        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
                        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
                        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

                        tom@atlassian.com Tom Davies
                        andrew.myers Andrew Myers [Atlassian]
                        Votes:
                        0 Vote for this issue
                        Watchers:
                        1 Start watching this issue

                          Created:
                          Updated:
                          Resolved:

                            Estimated:
                            Original Estimate - 24h
                            24h
                            Remaining:
                            Remaining Estimate - 0h
                            0h
                            Logged:
                            Time Spent - 13h Time Not Required
                            13h

                              tom@atlassian.com Tom Davies
                              andrew.myers Andrew Myers [Atlassian]
                              Affected customers:
                              0 This affects my team
                              Watchers:
                              1 Start watching this issue

                                Created:
                                Updated:
                                Resolved:

                                  Estimated:
                                  Original Estimate - 24h
                                  24h
                                  Remaining:
                                  Remaining Estimate - 0h
                                  0h
                                  Logged:
                                  Time Spent - 13h Time Not Required
                                  13h