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

Adding a documention to a calendar throws a "value too large for column" exception

    XMLWordPrintable

    Details

    • Type: Feature
    • Status: Dismissed (View Workflow)
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: 1.12.9
    • Component/s: None
    • Labels:
      None

      Description

      Current Situation

      When adding a documentation to a calendar in JOC Cockpit a "value too large for column" exception is thrown.

      REQUEST: ./calendar/documentation/assign
      PARAMS: {"jobschedulerId":"scheduler_joc_cockpit","calendar":"/Arbeitstage","documentation":"/custom/1.pdf","auditLog":{}}
      USER: root
      2019-01-18 15:04:37,199 ERROR 2051450519-11154 c.s.j.c.JOCDefaultResponse                   - com.sos.hibernate.exceptions.SOSHibernateObjectOperationException: could not execute statement: 12899 ORA-12899: value too large for column "SCHEDULER"."DOCUMENTATION_USAGES"."OBJECT_TYPE" (actual: 19, maximum: 10)
       [n/a] [DBItemDocumentationUsage[id=<null>,schedulerId=scheduler_joc_cockpit,documentationId=302,objectType=WORKINGDAYSCALENDAR,path=/Arbeitstage Amt,created=Fri Jan 18 14:04:37 UTC 2019,modified=Fri Jan 18 14:04:37 UTC 2019,dateTimeZone4Getters=Europe/Berlin]]
      com.sos.hibernate.exceptions.SOSHibernateObjectOperationException: could not execute statement: 12899 ORA-12899: value too large for column "SCHEDULER"."DOCUMENTATION_USAGES"."OBJECT_TYPE" (actual: 19, maximum: 10)
       [n/a] [DBItemDocumentationUsage[id=<null>,schedulerId=scheduler_joc_cockpit,documentationId=302,objectType=WORKINGDAYSCALENDAR,path=/Arbeitstage,created=Fri Jan 18 14:04:37 UTC 2019,modified=Fri Jan 18 14:04:37 UTC 2019,dateTimeZone4Getters=Europe/Berlin]]
      	at com.sos.hibernate.classes.SOSHibernateSession.save(SOSHibernateSession.java:965)
      	at com.sos.joc.classes.documentation.Documentation.assignDocu(Documentation.java:56)
      	at com.sos.joc.calendar.impl.CalendarResourceDocumentationImpl.assignDocu(CalendarResourceDocumentationImpl.java:85)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      	at java.lang.reflect.Method.invoke(Unknown Source)
      

      Tested with ORACLE Database.

      Desired Behavior

      Adding a documentation to a calendar in JOC Cockpit should work.

        Attachments

          Activity

            People

            • Assignee:
              oh Oliver Haufe
              Reporter:
              ur Uwe Risse
              Approver:
              Uwe Risse
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: