Some Audit Logs variables don't have a defined size, causing problems in Oracle

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 4.0 RC2, 4.0
    • Affects Version/s: 3.3.3, 3.4.2
    • Component/s: None
    • None

      Currently NEW_VALUE and OLD_VALUE don't have specific sizes set in our code.

      If Oracle is being used as instance DB, and the variables values exceed 255 chars, the following is logged:

      2012-01-09 11:23:58,958 ERROR [Thread-24] [JDBCExceptionReporter] ORA-12899: value too large for column "BAMBOO"."AUDIT_LOG"."NEW_VALUE" (actual: 257, maximum: 255)

      Not having limits defined for the variables, make Oracle set them to 255. It is clear that 255 is not always enough.

      The Error stops audit logging completely for the Plan/Job.

            Assignee:
            Krystian Brazulewicz
            Reporter:
            Renan Battaglin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: