Field Usage Analysis Report

[mclark@convexx.com]

I'm trying to run the Field Usage Analysis Report in ACTDIAG.  It just brings up a box with a bunch of lines.  The first line being; "System.Data.SqlClient.SqlException: Invalid Column name 'USER3'."  Then it reads; "Invalid column name 'USER3'." a few more times, followed by "invalid column name'USER4'." then USER7, USER8 and eventually "warning: Null value is eliminated by an aggregate or other SET operation.  It gives me an OK button and creates a blank report on the desktop.  Any ideas?  I've tried on other databases and it works fine.

Thanks.

[ghollister · Accepted solution]

Hello mclark,
It looks like you may have some invalid or damaged fields. ACT! has default User Fields 1-10. Back up your database, and (if those fields are not being used), delete the fields listed in the error message. Then run Database Maintenance from the Tools menu.

[ghollister · Accepted solution]

Hello mclark,
It looks like you may have some invalid or damaged fields. ACT! has default User Fields 1-10. Back up your database, and (if those fields are not being used), delete the fields listed in the error message. Then run Database Maintenance from the Tools menu.

[mclark@convexx.com]

Thank you.  That worked.