The Project Controller screens in Dynamics SL crash when launched

plumbline consulting

This crash is likely caused by the timer control in Control Parameter Maintenance. It either doesn’t exist or is set lower than 10.

project-screens-crash_timer1

In SQL Server Management Studio, run the following against the SL application database:

select control_data, * from pjcontrl where control_code = ‘timer’

If the control_data value that is returned is less than 10, run the following update statement.

*As a precaution, confirm recent backups of the SL databases exist before proceeding.

begin tran
update pjcontrl set control_data = ’10’ where control_code = ‘timer’
–Assuming 1 row is affected, run the following commit line, otherwise run the following rollback line
commit – OR – rollback