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

    • Feature
    • Status: Dismissed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • None
    • 1.12.9
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: