[AIRAVATA-3408] increase user_friendly_description length

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Application Catalog
• Assignee: Marcus Christie
• Reporter: Marcus Christie
• Created: 03/Feb/21 21:00
• Updated: 24/Mar/21 21:06
• Resolved: 24/Mar/21 21:06

Description

Getting this error with long descriptions:

Caused by: org.apache.openjpa.persistence.PersistenceException: (conn:10655875) Data too long for column 'USER_FRIENDLY_DESC' at row 1 {prepstmnt 1342301087 
UPDATE APPLICATION_INPUT 
    SET USER_FRIENDLY_DESC = ? 
    WHERE INTERFACE_ID = ? AND INPUT_KEY = ? 
[params=(String) Select the type of collection: If all the genomes in your collection..., (String) Database-Indexing_77cf2460-ba00-4eed-96ca-c62b1e1243c5, (String) Project Type]} [code=1406, state=22001]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146)
        at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554)
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:111)
        at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
        ... 20 common frames omitted

Maybe should just turn this into a CLOB

Issue Links

• duplicates: AIRAVATA-3369 BUG: The Application input description field length increase
• relates to: AIRAVATA-3370 New Improvement: Clickable URLs in the Application Input Description