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: