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

Possible to create an assignment with null fields (failed CC import)

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 12.2
    • Fix Version/s: None
    • Component/s: Assignments
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      Not sure how to reproduce this, so this bug report may be of limited use for now, but it seems possible to create an assignment with almost all fields null.

      This then causes in the assignment list table because OPEN_DATE is null (along with many other fields).

      VelocityViewServlet : Error processing a template for path ''
      
      Invocation of method 'getAssignmentStatus' in class com.sun.proxy.$Proxy97 threw exception java.lang.NullPointerException at /vm/assignment/chef_assignments_list_assignments.vm[line 427, column 78]
      
      java.lang.NullPointerException at org.sakaiproject.assignment.impl.AssignmentServiceImpl.getAssignmentStatus(AssignmentServiceImpl.java:1437) at sun.reflect.GeneratedMethodAccessor8007.invoke(Unknown Source) at 
      
      mysql> select CONTEXT, ASSIGNMENT_ID, TITLE, OPEN_DATE, AUTHOR, CREATED_DATE, INSTRUCTIONS, ascii(DRAFT), ascii(DELETED) from ASN_ASSIGNMENT WHERE TITLE IS NULL order by CREATED_DATE;
      +--------------------------------------+--------------------------------------+-------+-----------+--------------------------------------+---------------------+--------------+--------------+----------------+
      | CONTEXT                              | ASSIGNMENT_ID                        | TITLE | OPEN_DATE | AUTHOR                               | CREATED_DATE        | INSTRUCTIONS | ascii(DRAFT) | ascii(DELETED) |
      +--------------------------------------+--------------------------------------+-------+-----------+--------------------------------------+---------------------+--------------+--------------+----------------+
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 0033ac62-e284-4925-aed4-7e77ba038c07 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 0fdbfe86-4b78-4e34-a6b6-65168b1ab824 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 26c86b3e-d9bf-4b57-aa7d-5ed202a491e6 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 2b888d19-3d18-4db1-9256-4864ad536c94 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 7a236a84-52da-446e-813b-2cb92d9c6aa9 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | b4fdde70-0586-494a-9c27-02a93d2e56ed | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | e665cef1-4b34-45ef-9e78-0244f9113214 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | f190abdb-06ee-42d9-9f70-a90f215f702d | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:11:07 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | b8a4ffae-7f3e-433e-8309-950f1a11a3f1 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:04 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | d5ed3bf0-d670-4ecb-8c1b-83cf670cade1 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:04 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 022b7d84-395f-44c2-ae10-ef89984096ba | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 0bb0ee27-90f4-4032-89bd-7379b69eba7a | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 156871c1-2357-4558-8ff1-b74b692cfd73 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 2abdceed-287b-4212-91f9-31fa3dc32b18 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 456e08ed-da26-4f8e-b7ea-85e564cab083 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 49f46456-3423-48dc-9f9e-a8a336132d1a | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 668dc508-775f-4349-bda3-25292de26765 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | 76c059d8-14be-40a8-a804-119f82541023 | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      | 190b62a7-c686-48cc-9f93-8980add754e4 | a249f07e-df24-4962-a921-4944210b27cf | NULL  | NULL      | 55dae6c3-883a-43e8-92dd-b7f8b163a04f | 2018-07-24 09:45:05 | NULL         |            0 |              0 |
      +--------------------------------------+--------------------------------------+-------+-----------+--------------------------------------+---------------------+--------------+--------------+----------------+
      19 rows in set (0.09 sec)
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  smarquard Stephen Marquard
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code