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

OSP error during 2.3.1 -> 2.4.0 conversion

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.4.0
    • Fix Version/s: 2.4.0
    • Component/s: OSP: Other
    • Labels:
      None

      Description

      12:55:15 [ALTER - 0 row(s), 0.202 secs] [Error Code: 1758, SQL State: 42000] ORA-01758: table must be empty to add mandatory (NOT NULL) column
      alter table osp_scaffolding add preview number(1,0) not null;
      12:55:16 [ALTER - 0 row(s), 0.037 secs] [Error Code: 1758, SQL State: 42000] ORA-01758: table must be empty to add mandatory (NOT NULL) column
      alter table osp_wizard add preview number(1,0) not null;

      It seems that these statements do not work if there is data in the tables. (qa3-us must not have any data in these tables, it didn't show up there)

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                ajpoland Andrew Poland (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration