Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Dynaùmics NAV 2018 CU6 - Starting the NAV Service

Posted on by 5

Hi,

I am trying to run the NAV Service for the first time, using the Demo Database.

The NAV & SQL are on different servers. NAV Service running using NETWORK SERVICE account. My user and NETWORK SERVICE are db_owner on "master" and NAV databases.

I get the following error in the Event Log:

Any idea what permission I'm missing?

Server instance: NAV2018
Tenant ID: 
<ii>User: 
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException
ErrorNumber: 1088
SuppressMessage: False
ContainsPersonalOrRestrictedInformation: False
DiagnosticsSuppress: False
MessageWithoutPrivateInformation:
  The following SQL error was unexpected:
  Cannot find the object "Object Metadata" because it does not exist or you do not have permissions.
  SQL statement:
  IF NOT EXISTS (SELECT * FROM sys.change_tracking_tables WHERE object_id=Object_ID('[dbo].[Object Metadata]')) ALTER TABLE [dbo].[Object Metadata] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON);
  IF NOT EXISTS (SELECT * FROM sys.change_tracking_tables WHERE object_id=Object_ID('[dbo].[Debugger Breakpoint]')) ALTER TABLE [dbo].[Debugger Breakpoint] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON);
  IF NOT EXISTS (SELECT * FROM sys.change_tracking_tables WHERE object_id=Object_ID('[dbo].[Add-in]')) ALTER TABLE [dbo].[Add-in] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON);
  IF NOT EXISTS (SELECT * FROM sys.change_tracking_tables WHERE object_id=Object_ID('[dbo].[NAV App Object Metadata]')) ALTER TABLE [dbo].[NAV App Object Metadata] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON);
  IF NOT EXISTS (SELECT * FROM sys.change_tracking_tables WHERE object_id=Object_ID('[dbo].[NAV App Tenant App]')) ALTER TABLE [dbo].[NAV App Tenant App] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON);
  IF NOT EXISTS (SELECT * FROM sys.change_tracking_tables WHERE object_id=Object_ID('[dbo].[NAV App]')) ALTER TABLE [dbo].[NAV App] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON);
  SELECT CONVERT(BIGINT, CHANGE_TRACKING_CURRENT_VERSION())
  StackTrace:
     at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
     at System.Environment.get_StackTrace()
     at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ThrowNavSqlException(SqlExceptionAdapter exceptionAdapter, String commandText, Boolean isLastExceptionARollbackCause, Boolean logExceptions)
     at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass107_0`1.<ExecuteFunction>b__0()
     at Microsoft.Dynamics.Nav.Diagnostic.NavDiagnostics.SendTraceTagOnThreshold[T](String tag, Category category, Verbosity verbosity, Int32 threshold, Func`1 action, String message, Object[] parameters)
     at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTrace[T](EventTask task, Func`1 function, String commandText)
     at Microsoft.Dynamics.Nav.Runtime.NavSqlCommand.ExecuteScalar()
     at Microsoft.Dynamics.Nav.Runtime.NavDatabaseChangeListener.Initialize()
     at Microsoft.Dynamics.Nav.Runtime.NavDatabase.InitializeChangeListener()
     at Microsoft.Dynamics.Nav.Runtime.NavEnvironment.OnApplicationMounted(NavTenantCollection tenantCollection)
     at Microsoft.Dynamics.Nav.Runtime.NavTenantCollection.AddSystemTenant(String appDatabaseServerName, String appDatabaseName, String appDatabaseUserName, ProtectedDatabasePassword appDatabasePassword, Boolean verifyConnection, String newEncryptionKey, IDatabasePasswordPublicEncryptionKeyStorage keyStorage, Boolean allowOverwritePublicKey, Boolean verifyServerInstanceKey)
     at Microsoft.Dynamics.Nav.Runtime.NavTenantCollection.AddSingleLegacyTenant(String databaseServerName, String databaseName, String databaseUserName, ProtectedDatabasePassword databasePassword, EncryptionProvider encryptionProvider, AzureKeyVaultSettings azureKeyVaultSettings)
     at Microsoft.Dynamics.Nav.Runtime.NavTenantCollection.ConfigureTenants(ServerUserSettings settings, String encryptionKey)
     at Microsoft.Dynamics.Nav.Runtime.NavTaskFactory.<>c__DisplayClass11_0.<StartNewTask>b__0()
     at System.Threading.Tasks.Task.Execute()
     at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
     at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
     at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
     at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
     at System.Threading.ThreadHelper.ThreadStart(Object obj)
SuppressExceptionCreatedEvent: False
FatalityScope: None

Kind regards,

Cristian

Categories:
  • CristiG. Profile Picture
    CristiG. 5 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Thank you guys for your help!

    I ended up creating a dedicated domain user account for the NAV Service.

    Works like a charm :)

    Still not sure what I was missing regarding the NETWORK SERVICE account, knowing that I had a previous install on 2018 CU0 and it worked.

    Kind regards,

    Cristian

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Assuming you are compiling the object on the database server it self and not on any other PC.

  • CristiG. Profile Picture
    CristiG. 5 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Alright Stefano,

    Will do this and let you all know the result! :)

    Kind regards,

    Cristian

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,154 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    NETWORK SERVICE is evil :) Try to create a domain user account, grant them the permission to run as a service, assign it permissions in your NAV database and run the NAV service under this account.

    The errors here are too much and it seems that you need to force a schema sync.

  • CristiG. Profile Picture
    CristiG. 5 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Hi guys,

    I tried your advice, but same result. And as my main issue is that I cannot start the service, it needs a NAV Szervice to sync.

    I still believe I am missing some permissions on the SQL Server but don't know which ones...

    Do you have a checklist for the NETWORK SERVICE account needed permissions ?

    Kind regards,

    Cristian

  • Suggested answer
    Andrey Baludin Profile Picture
    Andrey Baludin 3,941 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Hi! Open the development environment and press Tools ->Sync. Schema for all tables -> Force.

  • Suggested answer
    Jatin Patel Profile Picture
    Jatin Patel 2,641 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Try to open C/SIDE as an administrator and recompile or else Sync-NAVTenant using PowerShell.

  • CristiG. Profile Picture
    CristiG. 5 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Hi Stefano,

    Got quite a lot of errors on Pages and also the following:

    Error No.	Object Type	Object ID	Object Name	Error Type	Function/Trigger	Line No.	Description
    1332	Codeunit	397	Mail	Error	CreateMessage	3	You have specified an unknown variable. Recipients Define the variable under 'Global C/AL symbols'.
    1333	Codeunit	400	SMTP Mail	Error	CreateMessage	7	You have specified an unknown variable. Dispose Define the variable under 'Global C/AL symbols'.
    1334	Codeunit	424	Export Analysis View	Error	ExportData	20	You have specified an unknown variable. CallOpenText Define the variable under 'Global C/AL symbols'.
    1335	Codeunit	802	Online Map Management	Error	MakeSelection	1	You have specified an unknown variable. IsAvailable Define the variable under 'Global C/AL symbols'.
    1336	Codeunit	1410	Doc. Exch. Service Mgt.	Error	Initialize	5	You have specified an unknown variable. Consumer Define the variable under 'Global C/AL symbols'.
    1337	Codeunit	1630	Office Management	Error	AttachAvailable	3	You have specified an unknown variable. OutlookItemRead Define the variable under 'Global C/AL symbols'.
    1338	Codeunit	1633	Office Host Provider	Error	OnGetHostType	6	You have specified an unknown variable. HostType Define the variable under 'Global C/AL symbols'.
    1339	Codeunit	1637	Office Document Handler	Error	HandleSalesCommand	2	You have specified an unknown variable. NewSalesCreditMemo Define the variable under 'Global C/AL symbols'.
    1340	Codeunit	1642	Intelligent Info Manifest	Error	SetupUrl	1	You have specified an unknown variable. OutlookItemRead Define the variable under 'Global C/AL symbols'.
    1341	Codeunit	1643	Hyperlink Manifest	Error	OnGenerateManifest	6	You have specified an unknown variable. OutlookHyperlink Define the variable under 'Global C/AL symbols'.
    1342	Codeunit	1651	Exchange PowerShell Runner	Error	CreateExchangePSRunner	1	You have specified an unknown variable. CreateInSandbox Define the variable under 'Global C/AL symbols'.
    1343	Codeunit	2001	Azure ML Connector	Error	Initialize	1	You have specified an unknown variable. AzureMLRequest Define the variable under 'Global C/AL symbols'.
    1344	Codeunit	2200	Azure Key Vault Management	Error	GetMachineLearningCredentials	9	You have specified an unknown variable. MachineLearningCredentialsHelper Define the variable under 'Global C/AL symbols'.
    1345	Codeunit	5052	AttachmentManagement	Error	InitializeExchangeWithCredentials	8	You have specified an unknown variable. WebCredentials Define the variable under 'Global C/AL symbols'.
    1346	Codeunit	5054	WordManagement	Error	CreateWordAttachment	1	You have specified an unknown variable. MergeHandler Define the variable under 'Global C/AL symbols'.
    1347	Codeunit	5064	Email Logging Dispatcher	Error	RunEMailBatch	10	You have specified an unknown variable. FindEmailMessages Define the variable under 'Global C/AL symbols'.
    1348	Codeunit	5300	Outlook Synch. Setup Mgt.	Error	ShowOItemsList	4	You have specified an unknown variable. OutlookObjectLibrary Define the variable under 'Global C/AL symbols'.
    1349	Codeunit	5301	Outlook Synch. NAV Mgt	Error	StartSynchronization	10	You have specified an unknown variable. XmlTextWriter Define the variable under 'Global C/AL symbols'.
    1350	Codeunit	5304	Outlook Synch. Outlook Mgt.	Error	ProcessOutlookChanges	1	You have specified an unknown variable. XmlTextReader Define the variable under 'Global C/AL symbols'.
    1351	Codeunit	5305	Outlook Synch. Process Line	Error	ProcessProperties	1	You have specified an unknown variable. GetAllCurrentChildNodes Define the variable under 'Global C/AL symbols'.
    1352	Codeunit	5306	Outlook Synch. Export Schema	Error	SendMappingScheme	5	You have specified an unknown variable. XmlTextReader Define the variable under 'Global C/AL symbols'.
    1353	Codeunit	5309	Outlook Synch. Process Links	Error	ProcessOutlookEntryIDResponse	1	You have specified an unknown variable. XmlTextReader Define the variable under 'Global C/AL symbols'.
    1354	Codeunit	5310	Outlook Synch. Resolve Confl.	Error	Process	4	You have specified an unknown variable. XmlTextWriter Define the variable under 'Global C/AL symbols'.
    1355	Codeunit	5311	Outlook Synch. Finalize	Error	Finalize	1	You have specified an unknown variable. XmlTextReader Define the variable under 'Global C/AL symbols'.
    1356	Codeunit	5320	Exchange Web Services Client	Error	GetPublicFoldersOnClient	5	You have specified an unknown variable. FolderInfo Define the variable under 'Global C/AL symbols'.
    1357	Codeunit	5321	Exchange Web Services Server	Error	InitializeForVersion	2	You have specified an unknown variable. CreateServiceWrapperForVersion Define the variable under 'Global C/AL symbols'.
    1358	Codeunit	5323	Exchange Add-in Setup	Error	InitializeServiceWithCredentials	1	You have specified an unknown variable. WebCredentials Define the variable under 'Global C/AL symbols'.
    1359	Codeunit	5330	CRM Integration Management	Error	ImportDefaultCRMSolution	1	You have specified an unknown variable. ImportDefaultCrmSolution Define the variable under 'Global C/AL symbols'.
    1360	Codeunit	6303	Azure AD Auth Flow	Error	CreateExchangeServiceWrapperWithToken	2	You have specified an unknown variable. CreateServiceWrapperWithToken Define the variable under 'Global C/AL symbols'.
    1361	Codeunit	6700	O365 Sync. Management	Error	CreateExchangeAccountCredentials	10	You have specified an unknown variable. OAuthCredentials Define the variable under 'Global C/AL symbols'.
    1362	Codeunit	6710	ODataUtility	Error	GenerateExcelWorkBookWithColumns	4	You have specified an unknown variable. DataEntityExportInfo Define the variable under 'Global C/AL symbols'.
    1363	Codeunit	7152	Export Item Analysis View	Error	ExportData	12	You have specified an unknown variable. CallOpenText Define the variable under 'Global C/AL symbols'.
    1364	Codeunit	7820	MS-QBO Table Mgt.	Error	Initialize	10	You have specified an unknown variable. Consumer Define the variable under 'Global C/AL symbols'.
    1365	Codeunit	8610	Questionnaire Management	Error	ImportQuestionnaireFromExcel	5	You have specified an unknown variable. CallOpen Define the variable under 'Global C/AL symbols'.
    1366	Codeunit	9010	Azure AD User Management	Error	CreateNewUsersFromAzureAD	4	You have specified an unknown variable. GetUsersPage Define the variable under 'Global C/AL symbols'.
    1367	Codeunit	9033	Invite External Accountant	Error	CreateNewUser	1	You have specified an unknown variable. GraphQuery Define the variable under 'Global C/AL symbols'.
    1368	Codeunit	9180	Generic Chart Mgt	Error	RetrieveXML	11	You have specified an unknown variable. TableId Define the variable under 'Global C/AL symbols'.
    1369	Codeunit	9510	Document Service Management	Error	TestConnection	5	You have specified an unknown variable. Reset Define the variable under 'Global C/AL symbols'.
    1370	Codeunit	9530	Outlook Message Factory	Error	CreateOutlookMessage	3	You have specified an unknown variable. CreateOutlookMessage Define the variable under 'Global C/AL symbols'.
    1371	Codeunit	9650	Edit MS Word Report Layout	Error	EditReportLayout	11	You have specified an unknown variable. GetApplication Define the variable under 'Global C/AL symbols'.
    1372	Codeunit	9651	Document Report Mgt.	Error	MergeWordLayout	31	You have specified an unknown variable. MergeWordDocument Define the variable under 'Global C/AL symbols'.
    1373	Codeunit	9800	Log Table Permissions	Error	Start	3	You have specified an unknown variable. NavPermissionEventReceiver Define the variable under 'Global C/AL symbols'.
    1374	Codeunit	9801	Identity Management	Error	SetAuthenticationKey	1	You have specified an unknown variable. TrySetAuthenticationKey Define the variable under 'Global C/AL symbols'.
    1375	Codeunit	9990	Code Coverage Mgt.	Error	StartAutomaticBackup	6	You have specified an unknown variable. Timer Define the variable under 'Global C/AL symbols'.
    1435	Codeunit	1751	Data Classification Eval. Data	Warning	ClassifySession	1	The 'Record2000000009Handle' type is obsolete.
    1436	Codeunit	1751	Data Classification Eval. Data	Warning	ClassifySession	3	The 'Record2000000009' type is obsolete.
    1437	Codeunit	1751	Data Classification Eval. Data	Warning	ClassifySession	3	The 'Record2000000009' type is obsolete.
    1438	Codeunit	1751	Data Classification Eval. Data	Warning	ClassifySession	4	The 'Record2000000009' type is obsolete.
    1439	Codeunit	1751	Data Classification Eval. Data	Warning	ClassifySession	4	The 'Record2000000009' type is obsolete.


    Do you think the database might have been incorrectly restored ?

    Kind regards,

    Cristian

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,154 on at
    RE: Dynaùmics NAV 2018 CU6 - Starting the NAV Service

    Can you open the database directly with C/SIDE?

    If so, try to recompile the objects.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans