Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-2536

Oracle Constraint in Crowd prevents user from being created in JIRA

    XMLWordPrintable

Details

    Description

      When connecting Crowd 2.2.7 and JIRA 4.1, and the JIRA application in Crowd has the Create User permission, it is not possible to create a user in JIRA. The following stacktrace appears on the atlassian-jira.log file:

      2011-06-22 14:18:04,598 http-8095-5 ERROR [hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("CROWDUSER"."CWD_USER"."FIRST_NAME")

	at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9119)
...

      There is a C008275 constraint regarding the Fist Name not being NULL.

      When switching from Oracle to MySQL for example, the error does not happen. The user is created in Crowd, however, the First Name column on the cwd_user is NULL.

      Attachments

        Activity

          People

            Unassigned Unassigned
            cgauterio Clarissa Gauterio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: