Crowd creates NULL DB values for any blank text box in a directory configuration

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Medium
    • 2.9.1
    • Affects Version/s: 2.5, 2.6, 2.7.2
    • Component/s: Database

      summary:

      After installing Crowd with Oracle DB, and leaving the description field empty for the internal directory, try to run this query in the Crowd Database:

      select * from cwd_directory where description is null;
      

      You will obtain at least 1 row. You can even try creating a directory with null description, or null User DN, and you will find that the values kept in the cwd_directory and cwd_directory_attribute tables are stored as NULL. This is the root cause of this issue: https://jira.atlassian.com/browse/CWD-3217

      workaround:

      https://confluence.atlassian.com/display/CROWDKB/Can't+Create+XML+backup+due+to+NULL+directory+description

              Assignee:
              Lukasz Pater
              Reporter:
              Foo Sim (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: