Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-780

Column "GUID" of the database table SOSFTP_FILES_HISTORY must be extended to VARCHAR(40). Firebird users need to do it manually (see description)

    XMLWordPrintable

Details

    • Feature
    • Status: Resolved (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.3.12.1300
    • Setup
    • None

    Description

      The installer contains the new file ./db/[dbms]/sosftphistory_alter.sql and executes them.

      FOR FIREBIRD USER:

      Please open a firebird sql client (e.g. isql) and call:
      SELECT RDB$CONSTRAINT_NAME FROM RDB$RELATION_CONSTRAINTS WHERE RDB$CONSTRAINT_TYPE='PRIMARY KEY' AND RDB$RELATION_NAME='SOSFTP_FILES_HISTORY';

      Delete the primary key constraint. For this use the constraint name from above sql statement.
      ALTER TABLE SOSFTP_FILES_HISTORY DROP CONSTRAINT [constraint name];

      Alter the type of the column "GUID":
      ALTER TABLE SOSFTP_FILES_HISTORY ALTER COLUMN "GUID" TYPE VARCHAR(40);

      Add the primary key
      ALTER TABLE SOSFTP_FILES_HISTORY ADD PRIMARY KEY ("GUID");

      Attachments

        Activity

          People

            oh Oliver Haufe
            oh Oliver Haufe
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 3 hours
                3h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours
                3h