You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@airavata.apache.org by "Marcus Christie (Jira)" <ji...@apache.org> on 2021/03/24 21:07:00 UTC
[jira] [Resolved] (AIRAVATA-3408) increase
user_friendly_description length
[ https://issues.apache.org/jira/browse/AIRAVATA-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marcus Christie resolved AIRAVATA-3408.
---------------------------------------
Resolution: Duplicate
> increase user_friendly_description length
> -----------------------------------------
>
> Key: AIRAVATA-3408
> URL: https://issues.apache.org/jira/browse/AIRAVATA-3408
> Project: Airavata
> Issue Type: Improvement
> Components: Application Catalog
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
>
> Getting this error with long descriptions:
> {code:sql}
> 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
> {code}
> Maybe should just turn this into a CLOB
--
This message was sent by Atlassian Jira
(v8.3.4#803005)