...
6. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead. Check the manual. You have to change some columns to TEXT or BLOBs.
| Expand |
|---|
When CRF has many fields (100-200), the database doesn’t allow pulling all these fields in OS. Resulting OS throws the above error. To resolve this error, you can either exclude the fields/CRFs you don’t want to sync in OS or include only those fields/CRFs you wish to pull from OC into OID mapping csv. Refer to https://openspecimen.atlassian.net/wiki/spaces/CAT/pages/1919779095/OC+Study+Setup#Exclude-and-Include-CRFs for steps to import the mapping csvRefer to the wiki page for more details. |
7. java.lang.RuntimeException: Error retrieving participants of the site: I-Spy2: 400: Error: {"message":"errorCode.studyNotExist","params":{"siteOid":null,"studyOid":"I-SPY2"}}
...