Unexpected Error default.js – invalid column name zEnableProjectSecurity

This articles replaces TK00092.

Error:

Attempting to log onto Time & Expense portal, you receive the following error.

Unexpected Error: default.js - LogOnUserReturn() - LogOn error:
Server was unable to process request.--->Invalid column name
'zEnableProjectSecurity'.(1)

Cause:

One or more company databases is not being updated to the current release.

Resolution:

Update all company databases to the current release.

If you are no longer using Project Cost in a company, you may remove the entries from the Dynamics table pc01410 for any databases not using project cost.

  1. Make a full backup.
  2. Open SQL Server Management Studio.
  3. Run the following script in SQL against the company database you wish to remove.
     Delete from pc01410 where zCompanyID = X

X is the company ID you wish to remove.

All KB Articles

Related Content

More Resources