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: