Column size
The following error messages indicate an incompatibility between an InForm form item and a Clintrial panel item:
ORA-01401: inserted value too large for column.
This Oracle error indicates that an InForm data item is too large for the Clintrial panel item to which it is mapped.
Value was either too large or too small for an Int64.
This .NET error can happen if the InForm item is a long string of digits too large for numeric storage in a 64-bit integer.
These errors can occur if you increase the size of an InForm form control with the Central Designer software without changing the corresponding Clintrial panel item with the Design module. To recover, do one of the following:
- Change the data in the InForm software if appropriate; then, change the size of the control on the InForm form so that it matches the size of the Clintrial panel item. Use the Central Designer software to make the necessary changes in the study, create a deployment package, and deploy it to the InForm server. For more information, see the Central Designer documentation.
- Change the size of the Clintrial panel item. In the Design module of the Clintrial software, change the DB Format of the panel item to a length that is compatible with the length of the InForm item. Save the change and implement the revision. For more information, see the Clintrial Admin and Design manual.
Caution: In the Clintrial software, you cannot change the design of a panel in an EDC protocol if data has already been entered in the panel. If the panel contains EDC data, you can override this restriction by selecting the Enable Modifications to EDC Panels option at the protocol level. For details, see the CIS Designer's Guide. Additionally, you can only change the DB Format of a panel item to a length that is larger.