Title:

NextChildNum error when launching v3.7.19 client after upgrade.

Affected Users:

LIMS Administrators, Lab Analysts

Fielded Statements:

I recently installed uninstalled my previous version of LIMS-plus 3.62.13 and installed v3.7.19.  Launching the application produces the following error message.

2005 – Error Loading file – record number 14. frsMainCaseview <or one of its members>.  Parent: Type

Conversion required by the DataType property for field ‘NextChildNum’ is invalid

Description:

Root Cause:

The database being connected has an incorrect data type property value on the field 'NextChildNum' located on the request table.

Solution:

Check the requests table and make sure the the field in question (NextChildNum) is set with a data type of (int(not null).  

Expand requests, NextChildNum will be the last field listed.

Make sure this field is set to int data type.

If the field is set to another data type (ex varchar,200), the error message will occur.