Follow

NextChildNum error when launching v3.7.19 client after upgrade.

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:

NextChildNum_Launch.JPG

 

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).  

NextChildNum_Table.JPG

Expand requests, NextChildNum will be the last field listed.

NextChildNum_Field.JPG

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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk