Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-1000

Wrong column constraint for table JSTREAM_STARTJOBS with Oracle DBMS

    XMLWordPrintable

Details

    Description

      Current Situation

      • For the Oracle DBMS the table JSTREAM_STARTJOBS is created with a wrong constraint:
        "NEXT_PERIOD" TIMESTAMP  NULL, NOT NULL,
        
      • As a result job streams cannot be created with the Oracle DBMS

      Desired Behavior

      • The respective column definition should be:
        "NEXT_PERIOD"  TIMESTAMP    NULL,
        

      Workaround

      • Remove the "not null" constraint:
        ALTER TABLE JSTREAM_STARTJOBS MODIFY "NEXT_PERIOD" TIMESTAMP NULL;
        

      Attachments

        Activity

          People

            ur Uwe Risse
            ap Andreas PĆ¼schel
            Kanika Agrawal Kanika Agrawal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: