Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-25532

Stack trace in reset password if user doesn't have a name entered

    XMLWordPrintable

    Details

    • 10 status:
      Resolved
    • Conversion Script Required:
      Yes
    • Test Plan:
      Hide
      • Create a new user. Don't enter a first or last name, just the required fields. Make sure to include an email address.
      • Login as admin, go to users tool in admin workspace, find that user and change the type to guest (required for reset password)
      • Logout, on 10 nightly the reset password is already available, click reset password and enter the email you specified (real email isn't sent so any email address would have worked)
      • The stack trace is shown, it is also in the log files. The link in the log files doesn't work.
      Show
      Create a new user. Don't enter a first or last name, just the required fields. Make sure to include an email address. Login as admin, go to users tool in admin workspace, find that user and change the type to guest (required for reset password) Logout, on 10 nightly the reset password is already available, click reset password and enter the email you specified (real email isn't sent so any email address would have worked) The stack trace is shown, it is also in the log files. The link in the log files doesn't work.

      Description

      The name fields are not required for a user, and if these are left blank, and you attempt to reset the password, you get a stack trace. See testing tab for more info about how to reproduce on nightly.

      Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("SAK"."VALIDATIONACCOUNT_ITEM"."FIRST_NAME")

      at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
      at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10720)
      at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
      ... 99 more
      2014-01-09 15:17:57,921 WARN http-bio-8082-exec-8 PonderUtilCore - Exception rendering view:
      java.lang.ClassCastException: java.lang.String cannot be cast to [Ljava.lang.String;

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

              is duplicated by

              Bug - A problem which impairs or prevents functionality of the product. SAK-26041 Two same clicks are needed to finish adding non-official participants

              • Blocker - Blocks development and/or testing work, production could not run without this feature working correctly.
              • CLOSED

              Task - A task that needs to be done. SAK-26181 Add oracle conversion script to remove null constraints in VALIDATIONACCOUNT_ITEM

              • Major - Major loss of function or need for functionality in production in the near future.
              • CLOSED
              relates to

              Feature Request - Functionality that you would like to see in Sakai. SAK-24427 Improvements to account validator

              • Major - Major loss of function or need for functionality in production in the near future.
              • CLOSED

                Activity

                  People

                  Assignee:
                  jonespm Matthew Jones
                  Reporter:
                  jonespm Matthew Jones
                  Votes:
                  1 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration