Wednesday, February 1, 2017

Data at the root level is invalid. Line 1, position 1 MS Dynamics NAV


How I resolve this error? 
Data at the root level is invalid. Line 1, position 1. 




The solution I followed is at :

Dynamics User Link

Step 1 :

You have to remove this property in Navision XMLPORT. For this Goto new line in XMLPORT and open Properties.


Step 2 :

Change format property to Variable text.


I hope this will resolve your problem Like mine.

Wednesday, January 11, 2017

Error while opening RTC 2017: You do not have the following permissions on CodeUnit ApplicationManagement: Execute

Error: 


You do not have the following permissions on CodeUnit ApplicationManagement?

Execute in NAV 2017?

With new installation of MS Dynamics NAV 2017, you have stuck on this Error to resolve it follow :
Open Powershell of MS Dynamics NAV 2017.




Type this command by replacing your domain ID in line 1

$objUser = New-Object System.Security.Principal.NTAccount(" ")
$strSID = $objUser.Translate([System.Security.Principal.SecurityIdentifier])
$strSID.Value


Press Enter you will receive SID ,Please copy it.



Open your SSMS SQL Server Management Studio.
and select the DB and click on New Querry at the TOP. and Paste this Querry.
Put in your SSID and run the querry.


DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50), @USERSIDTXT varchar(50)
SELECT NEWID()
SET @USERNAME = 'YMI\VE00'
SET @USERSID = NEWID()
SET @USERSIDTXT = CONVERT(VARCHAR(50), @USERSID)
SET @WINDOWSSID = 'S-1-5-21-1840235955-2410550965-3881810730-44149'

INSERT INTO [dbo].[User]
([User Security ID],[User Name],[Full Name],[State],[Expiry Date],[Windows Security ID],[Change Password],[License Type]
,[Authentication Email],[Contact Email])

VALUES
(@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0,'','VE00@global.com')

INSERT INTO [dbo].[User Property]

([User Security ID],[Password],[Name Identifier],[Authentication Key],[WebServices Key],[WebServices Key Expiry Date],
[Authentication Object ID])

VALUES

(@USERSID,'','','','','1753-01-01 00:00:00.000','')
INSERT INTO [dbo].[Access Control]
([User Security ID],[Role ID],[Company Name])
VALUES
(@USERSID,'SUPER','')
GO




Now Start your NAV 2017 RTC and enjoy the stuff.



Get your Complete CODE here

$objUser = New-Object System.Security.Principal.NTAccount("YourDomain\Your ID")
$strSID = $objUser.Translate([System.Security.Principal.SecurityIdentifier])
$strSID.Value

USE [DATABASE NAME]
DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50), @USERSIDTXT varchar(50)

SELECT NEWID()
SET @USERNAME = 'YourDomain\Your ID'
SET @USERSID = NEWID()
SET @USERSIDTXT = CONVERT(VARCHAR(50), @USERSID)
SET @WINDOWSSID = 'Your SSID'

INSERT INTO [dbo].[User]

([User Security ID],[User Name],[Full Name],[State],[Expiry Date],[Windows Security ID],[Change Password],[License Type]
,[Authentication Email])
VALUES
(@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0,'')

INSERT INTO [dbo].[User Property]
([User Security ID],[Password],[Name Identifier],[Authentication Key],[WebServices Key],[WebServices Key Expiry Date],
[Authentication Object ID])

VALUES
(@USERSID,'','','','','1753-01-01 00:00:00.000','')
INSERT INTO [dbo].[Access Control]
([User Security ID],[Role ID],[Company Name])

VALUES
(@USERSID,'SUPER','')
GO

Discontinued Component NAV 2013 & Later - INPUT BOX (The Input Method is Obsolete). in NAV 2017


Error (The Input Method is Obsolete).

How to use Window dialog Box in NAV 2013 R2 And Above?

Error while using dialog in NAV 2013 R2.



To resolve this error we must have to use DotNet variable in NAV 2013 R2. 

We have to define this variable as DOTNET Type.

And directly paste this as SUBTYPE : Microsoft.VisualBasic.Interaction.'Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'



my text constants are :- Name ConstValue
Text000 The customer was found.\
Text001 Customer No. %1 is:\%2
Text002 Sorry, that customer could not be found.



Also put this property as YES in NAVISION.

The result is :

And final Result is this :