Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV 2013 R2 Import/Exp...
Microsoft Dynamics NAV (Archived)

NAV 2013 R2 Import/Export DATA - Import failed

(0) ShareShare
ReportReport
Posted on by JF2014 190

Updated Database from NAV 2013 R5 to NAV 2013 R2 (R9). Import of the .navdata ( one company) file failed with the message mentioned below

- I checked the import  on different machines

- The same behavior occurs while renaming a company

- Lines 200000007 etc  from table Object Metadata Snapshot were deleted

Can anybody help with respect to this error? Thanks in advance

 

 

 

Type: Microsoft.Dynamics.Nav.Client.NavClientClosingException

Fatal: False

ShowError: True

Message: The server "xxxx" was unable to process the request. Close the application and start it again.

StackTrace:

     at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoExecute(Func`1 execute)

     at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoRethrowWithCatchException(Exception exception, Boolean designMode)

     at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoHandleThreadException(Exception exception, Boolean designMode)

     at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.WinFormsDispatcherUnhandledException(Object sender, DispatcherUnhandledExceptionEventArgs eventArgs)

     at Microsoft.Dynamics.Framework.UI.WinForms.WinFormsDispatcher.HandleDispatcherException(Object sender, Exception e)

     at Microsoft.Dynamics.Framework.UI.WinForms.WinFormsDispatcher.OnThreadException(Object sender, ThreadExceptionEventArgs eventArgs)

     at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)

     at System.Windows.Forms.Control.WndProcException(Exception e)

     at System.Windows.Forms.Control.ControlNativeWindow.OnThreadException(Exception e)

     at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

     at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

     at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

     at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

     at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

     at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.RunMessagePump()

     at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.RunCore()

     at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.Run()

     at Microsoft.Dynamics.Nav.Client.WinClient.NavClientErrorHandler.ExecuteAndCatchExceptions(Func`1 execute)

Source: Microsoft.Dynamics.Nav.Client.WinClient

HResult: -2146233088

----------------------------------

Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

Message: The server "xxxx" was unable to process the request. Close the application and start it again.

StackTrace:

     at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.<>c__DisplayClass6.<DoRethrowWithCatchException>b__4()

     at Microsoft.Dynamics.Nav.Client.WinClient.NavClientErrorHandler.ExecuteAndCatchExceptions(Func`1 execute)

Source: Microsoft.Dynamics.Nav.Client.WinClient

HResult: -2146233088

----------------------------------

Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

Message: The server "AKQ-AG-NAVCross" was unable to process the request. Close the application and start it again.

StackTrace:

     at Microsoft.Dynamics.Nav.Client.ConnectionStateManager.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod, ServerCallOptions options)

     at Microsoft.Dynamics.Nav.Client.ServerInvocationHandler.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod, ServerCallOptions options)

     at Microsoft.Dynamics.Nav.Client.ServiceConnection.Upload(StreamTransfer stream)

     at Microsoft.Dynamics.Nav.Client.FileActionProvider.InvokeFileAction(IFileDialogProvider fileDialogProvider, FileActionRequest fileActionRequest, UISession uiSession, Int32 maxUploadFileSize, RetrieveFileContents retrieveFileContents, IService service)

     at Microsoft.Dynamics.Nav.Client.ServiceClientCallback.<>c__DisplayClass28.<FileActionDialog>b__27()

     at Microsoft.Dynamics.Nav.Client.ServiceClientCallback.<>c__DisplayClass1.<RunClientRequest>b__0()

     at Microsoft.Dynamics.Nav.Client.ServerInvocationManager.<>c__DisplayClass8.<WaitForServerResponse>b__6()

     at Microsoft.Dynamics.Nav.Client.ServerInvocationManager.DoClientRequestAndCatch(Action clientRequest, Action`1 sendToServerIfNotFaulted)

     at Microsoft.Dynamics.Nav.Client.ServerInvocationManager.WaitForServerResponse(IAsyncResult asyncResult, ThreadCallbackContext threadEventContext)

     at Microsoft.Dynamics.Nav.Client.ServerInvocationManager.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod, ServerCallOptions options)

     at Microsoft.Dynamics.Nav.Client.ServerInvocationHandler.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod, ServerCallOptions options)

     at Microsoft.Dynamics.Nav.Client.ConnectionStateManager.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod, ServerCallOptions options)

     at Microsoft.Dynamics.Nav.Client.ConnectionStateManager.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod)

     at Microsoft.Dynamics.Nav.Client.ServerInvocationHandler.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod)

     at Microsoft.Dynamics.Nav.Client.ServiceConnection.CallServer[T](BeginCallServerMethod beginCallServerMethod, EndCallServerMethod`1 endCallServerMethod)

     at Microsoft.Dynamics.Nav.Client.ServiceConnectionBase.CloseForm(NavCloseFormArguments& mainForm, NavCloseFormArguments[]& subForms, Boolean force)

     at Microsoft.Dynamics.Nav.Client.ServiceConnection.Microsoft.Dynamics.Nav.Client.IService.CloseForm(NavCloseFormArguments& , NavCloseFormArguments[]& , Boolean )

     at Microsoft.Dynamics.Nav.Client.DataBinder.NstDataAccess.CloseForm(IService service, LogicalForm mainForm, FormResult exitAction, Collection`1 subForms, Boolean force)

     at Microsoft.Dynamics.Nav.Client.UIPatterns.NavFormCloseHandler.ExecuteCloseForm(Boolean force)

     at Microsoft.Dynamics.Nav.Client.UIPatterns.NavFormCloseHandler.ExecuteCloseCore(FormClose formClose, Boolean force)

     at Microsoft.Dynamics.Framework.UI.LogicalFormCloseController.DoExecuteCloseThisAndChildForms(FormClose formClose)

     at Microsoft.Dynamics.Framework.UI.LogicalFormCloseController.PerformFullClose(FormClose formClose)

     at Microsoft.Dynamics.Framework.UI.LogicalForm.PerformClose(FormClose formClose)

     at Microsoft.Dynamics.Framework.UI.LogicalForm.Close(FormClose formClose)

     at Microsoft.Dynamics.Framework.UI.CloseAction.InvokeCore(LogicalControl logicalControl, Object state, UISession uiSession)

     at Microsoft.Dynamics.Nav.Client.Actions.ExitAction.InvokeCore(LogicalControl logicalControl, Object state, UISession uiSession)

     at Microsoft.Dynamics.Framework.UI.LogicalAction.InvokeCoreWithErrorHandling(LogicalControl logicalControl, Object state, UISession uiSession)

     at Microsoft.Dynamics.Framework.UI.LogicalAction.DoInvoke(LogicalControl logicalControl, UISession uiSession)

     at Microsoft.Dynamics.Framework.UI.ActionControl.Invoke()

     at Microsoft.Dynamics.Framework.UI.Windows.ActionsHelper.<>c__DisplayClassa.<ModalitySafeInvoke>b__8()

     at Microsoft.Dynamics.Framework.UI.Windows.ActionsHelper.ModalitySafe(Action action)

     at Microsoft.Dynamics.Framework.UI.Windows.ActionsHelper.ModalitySafeInvoke(ActionControl actionControl)

     at Microsoft.Dynamics.Framework.UI.Windows.ActionControlAdapterBase.DefaultInvokeAction(LogicalControlAdapter adapter, ActionControl actionControl)

     at Microsoft.Dynamics.Framework.UI.Windows.ActionControlAdapterBase.DefaultInvokeAction(LogicalControlAdapter adapter)

     at Microsoft.Dynamics.Framework.UI.Windows.ActionControlAdapterBase.OnInvoke()

     at Microsoft.Dynamics.Framework.UI.WinForms.ActionControlAdapter.OnInvoke()

     at Microsoft.Dynamics.Framework.UI.WinForms.ActionControlAdapter.<InitializeNativeControl>b__0(Object sender, EventArgs e)

     at System.EventHandler.Invoke(Object sender, EventArgs e)

     at System.Windows.Forms.Control.OnClick(EventArgs e)

     at System.Windows.Forms.Button.OnClick(EventArgs e)

     at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

     at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

     at System.Windows.Forms.Control.WndProc(Message& m)

     at System.Windows.Forms.ButtonBase.WndProc(Message& m)

     at System.Windows.Forms.Button.WndProc(Message& m)

     at Microsoft.Dynamics.Framework.UI.WinForms.ActionControlAdapter.ActionButton.WndProc(Message& m)

     at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

     at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

     at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Source: Microsoft.Dynamics.Nav.Client.ServiceConnection

HResult: -2146233088

----------------------------------

Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

Message: The server "xxxx" was unable to process the request. Close the application and start it again.

HResult: -2146233088

----------------------------------

Type: System.NullReferenceException

Message: Object reference not set to an instance of an object.

StackTrace:

     at Microsoft.Dynamics.Nav.Runtime.NavSqlDmlCommand.GetWritableSqlValue(NCLMetaField field, NavValue value)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlDmlCommand.ExecuteInsert(IRecordBuffer record)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteCommandAndCacheOnSuccess[T](NavSqlCommandCacheKey commandKey, Func`1 createFunc, Func`2 executeFunc)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlDmlCommand.Insert(NavDatabase database, NCLMetaTable table, Int32 companyIndex, IRecordBuffer record, Boolean retrieveTimestamp, NavValue& identityValue, NavBigInteger& timestampValue)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlDmlCommand.Insert(NavDatabase database, NCLMetaTable table, Int32 companyToken, IRecordBuffer recordBuffer, NavValue& identityValue, NavBigInteger& timestampValue)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlImportExportData.GetCompaniesAndInclusion(NavSqlDataExportHeader header, NavDatabase tenantDatabase, NCLMetaTable companyTable, Boolean includeAllCompanies, IEnumerable`1 companiesToInclude)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlImportExportData.ReadTenantTables(BinaryReader reader, Boolean emptyTenantDatabase, NavSqlDataExportHeader header, NavDatabase tenantDatabase, SqlBulkCopy sqlBulkCopy, Boolean includeGlobalTables, Boolean includeAllCompanies, IEnumerable`1 companiesToInclude)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlImportExportData.<>c__DisplayClass20.<ReadTenantDatabase>b__1f()

     at Microsoft.Dynamics.Nav.Runtime.NavDatabase.PerformSynchronizationAction(Action action)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlImportExportData.ReadTenantDatabase(BinaryReader reader, NavSqlDataExportHeader header, NavDatabase tenantDatabase, Boolean includeGlobalTables, Boolean includeAllCompanies, IEnumerable`1 companiesToInclude)

     at Microsoft.Dynamics.Nav.Runtime.NavSqlImportExportData.Import(Stream stream, Boolean includeApplication, Boolean includeApplicationDatabaseTables, NavDatabase tenantDatabase, Boolean includeGlobalTables, Boolean includeAllCompanies, IEnumerable`1 companiesToInclude, Action`1 reportProgress, Int64 totalBytesInStream, Boolean leaveStreamOpenWhenDone)

     at Microsoft.Dynamics.Nav.Runtime.ALDatabase.<>c__DisplayClass9.<ALImportData>b__7(StreamTransfer streamTransfer)

     at Microsoft.Dynamics.Nav.Service.NSService.Upload(StreamTransfer stream)

     at SyncInvokeUpload(Object , Object[] , Object[] )

     at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

     at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.ErrorMappingCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)

Source: Microsoft.Dynamics.Nav.Ncl

HResult: -2147467261

*This post is locked for comments

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    Yes, you have to compile all the objects not only the tables , i have also have the same problem for me after compiling all objects i'm able to do copy / rename company, lets compile all the obj.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    Hi Rajasekhar,

    Thank you for the fast answer.

    Before posting I already have done a compile of all objects (tables) in  the copy of the DB. Must I do a compile of all objects in the DB where I done the Export?

    Jeannot

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    Recompile all the objects & try to do the operation, most of the cases it will resolves your issue

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    Hello together,
    I made a copy of a NAV DB. NAV CU10 is installed.

    On the origin a on the copy an NST is running. When I will import a company
    I also get the error “Import-NAVData : The server "test" was unable to process the request. Close the application and start it again”

    Did anyone has a solution to solve this issue?

    Best regards

    Jeannot

  • erikmj Profile Picture
    erikmj 5 on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    I just ran into this error, a RTM version that has been upgraded to CU 10.

    Is there a fix for it ? - an additional file that needs to be replaced, one that needs to be deleted, a reg key that needs to be updated.... or... ?

    I need to import an upgraded company into a customer production database that allready contains other companies.

    Best regards,

    Erik

  • JF2014 Profile Picture
    JF2014 190 on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    did that before, but this didn't help. Microsoft is aware of this problem, which will be fixed in one of the following rollups.

    Workaround: If you install NAV 2013 R2 with the respective build version provided with rollup 8 or higher, the problem doesn't occur. If you have an installation with the RTM version of 2013 R2 and have applied different rollups over this installation then you have this problem.

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    Hi 

    Compile all the objects & try to do rename.

    Regards

    Rajasekhar.Y

  • JF2014 Profile Picture
    JF2014 190 on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    Thanks for your answer! I already followed the steps  in this link because i got this 'schema' error. As background:  I'm working with one database only (as test scenario), export a company - delete a company and try to import the .navdata file when my client crashes with the error mentioned above.

  • Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: NAV 2013 R2 Import/Export DATA - Import failed

    I'm not sure which is NAV 2013 R5 version, but if you try to do export/import on upgraded database, this is probably resolving for your problem:

    http://www.dynamics.is/?p=1908

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans