Character limits in RQM for custom attributes
Accepted answer
Hi Anthony,
1) for the custom attributes :
Not sure.
Based on this :
Stéphane
1) for the custom attributes :
here are the limits (up to the current release):2) for the Headline/Name of a Test Case, Test Plan & Test Script
- for Text (Small) : 250 character limit
- for Text (Medium) : 1000 character limit
Please check also :
- https://jazz.net/forum/questions/47533/what-are-the-string-sizes-ie-small-string
- https://jazz.net/library/content/articles/rtc/4.0/workitem-customization/#customattributes
Note : you could experience these limits by yourself by entering 250+ (resp. 1000+) characters into a Small (resp. Medium) text-based custom attributes. RQM would normally trim them respectively after the 250 (resp. the 1000 th) character.
Not sure.
Based on this :
I've experienced a little bit in a CLM 4.0.0.1 environment (based on a Derby Database).Regards,
As a result, I've obtained this SQL exception in the "qm.log" file after I fed description field with 250+ characters strings :
INFO sqlExceptionLogger - String data, right truncationSQL: INSERT INTO PLANNING.TEST_CASE (STATE_ID, .....)
SQL Exception #1SQL Message: A truncation error was encountered trying to shrink VARCHAR '012345678901234567890123456789012345678901234567890123456789&' to length 250.SQL State: 22001Error Code: 20000So, at least under my current configuration : 250 characters appears to be the limit.
java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR '012345678901234567890123456789012345678901234567890123456789&' to length 250. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
Stéphane