Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.1.0-m2, 2.1
    • Component/s: Database, Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-7018Apply sql to master db for KULRICE-6916: KRIM_ENTITY_CACHE_T.PRSN_NM is too small
      KULRICE-7997Quickfinder lightbox too small
      KULRICE-7860KRAD Lookup window - too small to be useful.
      KULRICE-11580Small button size is too big
      KULRICE-7558Default sizes for Rice caches are too small and timeToLiveSeconds is not configured properly
      KULRICE-2305seq_rule_expr sequence missing from mysql.ddl, rule_expr size too small
      KULRICE-8999Windows 2008 IE Resize issue PeopleFlow small size
      KULRICE-7586ConversionNotSupportedException error when working with Uif-SecondaryActionButton-Small
      KULRICE-5338Data table does not resize correctly when page is initially small
      KULRICE-1172KIM name sequence too long
    • Rice Module:
      KIM
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      This came in off the collab list, pasting the message from Jannie Louwrens:

      Hi All,

      I noticed a lot of the following error message is logged in the server log:

      Exception in thread "PMS/KSB-pool-1-thread-18" java.lang.RuntimeException: org.springframework.dao.DataIntegrityViolationException: OJB operation; SQL []; Data truncation: Data too long for column 'PRSN_NM' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PRSN_NM' at row 1
      at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$CallableAdapter.run(IdentityArchiveServiceImpl.java:395)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)
      Caused by: org.springframework.dao.DataIntegrityViolationException: OJB operation; SQL []; Data truncation: Data too long for column 'PRSN_NM' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PRSN_NM' at row 1

      ...

      I have traced it to IdentityArchiveServiceImpl.EntityArchiveWriter.call() method at statement entityCache.add(new EntityDefaultInfoCacheBo( entityToInsert ));

      Looks like the EnitytDefault.EntityName.compositeNameUnmasked is set as a composition of lastname, firstname and middlename of an Entity, which is way too big for the Krim_Entity_Cache_T table's prsn_nm:varchar(40)

      Is this a known bug in the impex table schema create sql?

      Seems the fix would be to make KRIM_ENTITY_CACHE_T.PRSN_NM at least long enough to hold the first, middle and last plus extra formatting characters. Looking at KRIM_ENTITY_NM_T as well as the implementation of EntityName.Builder.getCompositeNameUnmasked() it looks like that would require at least 163 characters (40 + 40 + 80 for column sizes, and then 2 + 1 for extra characters).

        Issue Links

          Activity

          Hide
          Eric Westfall added a comment -

          Let's go ahead and set this to 255.

          Show
          Eric Westfall added a comment - Let's go ahead and set this to 255.
          Hide
          Peter Giles (Inactive) added a comment - - edited

          This should entail creating SQL update scripts for Oracle and MySQL to widen out that column to 255 (as Eric suggested), and following the procedure to have it applied to the master db: https://wiki.kuali.org/display/KULRICE/Process+for+Making+Database+Changes+During+Development

          Show
          Peter Giles (Inactive) added a comment - - edited This should entail creating SQL update scripts for Oracle and MySQL to widen out that column to 255 (as Eric suggested), and following the procedure to have it applied to the master db: https://wiki.kuali.org/display/KULRICE/Process+for+Making+Database+Changes+During+Development
          Hide
          Jeff Ruch added a comment -

          The following files have been created with the SQL changes:

          C:\Idea\Projects\KUALIRICE\scripts\upgrades\2.0.0 to 2.1\db-updates\mysql-2012-03-13.sql

          C:\Idea\Projects\KUALIRICE\scripts\upgrades\2.0.0 to 2.1\db-updates\2012-03-13.sql

          Show
          Jeff Ruch added a comment - The following files have been created with the SQL changes: C:\Idea\Projects\KUALIRICE\scripts\upgrades\2.0.0 to 2.1\db-updates\mysql-2012-03-13.sql C:\Idea\Projects\KUALIRICE\scripts\upgrades\2.0.0 to 2.1\db-updates\2012-03-13.sql
          Hide
          Jeff Ruch added a comment -

          Please note that the files referenced in the previous comment are committed on the 2.1 trunk.

          Show
          Jeff Ruch added a comment - Please note that the files referenced in the previous comment are committed on the 2.1 trunk.
          Hide
          Jeff Ruch added a comment -

          Sent email to krice.dev@kuali.org with request to update database.

          Show
          Jeff Ruch added a comment - Sent email to krice.dev@kuali.org with request to update database.
          Hide
          Jeff Ruch added a comment -

          The email address krice.dev@kuali.org bounces with both my CSU and Kuali email address.

          Show
          Jeff Ruch added a comment - The email address krice.dev@kuali.org bounces with both my CSU and Kuali email address.
          Hide
          Jessica Coltrin (Inactive) added a comment -

          Jeff - I think you're looking to send the notification to rice.dev@kuali.org.

          Show
          Jessica Coltrin (Inactive) added a comment - Jeff - I think you're looking to send the notification to rice.dev@kuali.org.
          Hide
          Jeff Ruch added a comment -

          The scripts have been executed on the master database.

          Show
          Jeff Ruch added a comment - The scripts have been executed on the master database.

            People

            • Assignee:
              Jeff Ruch
              Reporter:
              Peter Giles (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel