Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-10793

Problems with propvalue column size in properties tables

    Details

    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      1
    • Sprint:
      OpenIDM Sprint 6.5-3
    • Support Ticket IDs:

      Description

      The propvalue column size of various table is 2000, but the actual values may be larger than that. It appears like this may lead to problems with Oracle databases. A particular issue is the "serialized" property of scheduler objects which can be much larger than 2000. This could be addressed individually for specific properties, like changing the schedulerobjects table so that "serialized" is not searchable (for which there seems no good reason), but other tables and properties may be affected as well, like managedobjects or specifically the /jsonconfig/configurationProperties/privateKey  property. Another option might be to specifically truncate propvalue before inserting in in the properties tables.

        Attachments

          Activity

            People

            • Assignee:
              emanuel.brici Emanuel Brici
              Reporter:
              matthias.grabiak Matthias Grabiak
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: