Problem

The following error is displayed when user tried to update an XDB table where an associated trigger calls a user defined function:

Unable to create sysdef.dat

Product settings are incorrect or the folder does not have write permissions

Solution

Disabling the XDB service and using the Blue Screen XDB Server resolved the error. Initially, the customer had the XDB Server Service running and when the trigger prompted a second session of MFE to be started, it tried to start under the control of the XDB Server Service. Normally the XDB Server Service is run under a "local system" user and does not have full permission required to start a second MFE session and the 'unable to create sysdef.dat' message is then displayed. Disabling the service allowed the “blue screen" XDB Server to be started and thus the second MFE session.