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

      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.

            [CWD-2536] Oracle Constraint in Crowd prevents user from being created in JIRA

            There are no comments yet on this issue.

              Unassigned Unassigned
              cgauterio Clarissa Gauterio (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: