If an imported SQL Profiler trace is incomplete

If an imported trace appears to be missing permissions or no Object Trace Events were recorded, it is possible that the profiler trace was executed using one of the standard templates instead of the Easy Security template.
If the Easy Security template has not been imported or it was not set as the default, then the Standard template may have been used.

The Standard template does not record all of the necessary events needed for the role permissions. The trace events look similar to the below screen shot and do not include Object Trace Events.

See the following FAQ's for detailed instruction for installing and using the templates.

How To Import an Easy Security SQL Profiler Template

How To Create a New Role Using SQL Profiler

If permissions are missing, another possibility is that the NAV Server service was not restarted prior to starting the recording on RTC. In this case objects may have been cached and would not be picked up by the recording. Always restart the NAV Server service before recording on RTC. In the Classic Client, simply close the client and reopen to clear the object cache.

Like   Don't Like

© 2024 All rights reserved.

Related resources

Download software from