Dynamics NAV 2013: Charts localization issue

The new charts in NAV 2013 are great. Both the advanced charts and the simple charts.

But I’m having an issue. When I’m running it from the DK Cronus database then it works fine, both in DK and ENU. I can run them, create, edit and delete.

But in my production database which was upgraded from NAV 2009 then I’m getting this error when ever I try to create or edit and the language is set to DK:

1856.clientstop.png

If I’m running it in ENU then it works fine!

I have compared all the objects of my Cronus database and my production database and they are all 100% the same.

I have also tried to delete all the existing charts, but it still doesn’t allow me to create a new. Using ENU no problems.

So if it is not the objects and data, what else could it be?

Hi Erik,

Maybe you can check if database collation is the same for both DB’s?

Hi Benoit,

The collation is the same: Latin1_General_100_CS_AS.

Are there any related entries in the Event Viewer of the client?

Type: System.InvalidOperationException

Message: Error en el documento XML (1, 1).

StackTrace:

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

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

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

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

Source: Microsoft.Dynamics.Nav.Client.WinClient

HResult: -2146233079


Type: System.InvalidOperationException

Message: Error en el documento XML (1, 1).

StackTrace:

en System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)

en System.Xml.Serialization.XmlSerializer.Deserialize(Stream stream)

en Microsoft.Dynamics.Nav.Types.Metadata.ChartDefinition.FromBlob(Byte[] blob)

en Microsoft.Dynamics.Nav.Client.Visualizations.NavVisualizationDefinition.FromNavBlob(Byte[] navBlob)

en Microsoft.Dynamics.Nav.Client.Actions.CustomizeVisualizationControlAction.InvokeCore(Boolean async, LogicalControl logicalControl, Object state, UISession uiSession)

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

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

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

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

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

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

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

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

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

en Microsoft.Dynamics.Framework.UI.WinForms.MenuBarActionControlAdapter.b__0(Object sender, EventArgs e)

en System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)

en System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)

en System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)

en System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)

en System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)

en System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)

en System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)

en System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)

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

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

en System.Windows.Forms.ScrollableControl.WndProc(Message& m)

en System.Windows.Forms.ToolStrip.WndProc(Message& m)

en System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)

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

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

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

Source: System.Xml

HResult: -2146233079


Type: System.Xml.XmlException

LineNumber: 1

LinePosition: 1

Message: ‘’, valor hexadecimal 0x04, es un carácter no válido. línea 1, posición 1.

StackTrace:

en System.Xml.XmlTextReaderImpl.Throw(Exception e)

en System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)

en System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Char[] data, Int32 length, Int32 invCharPos)

en System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()

en System.Xml.XmlTextReaderImpl.ParseDocumentContent()

en System.Xml.XmlTextReaderImpl.Read()

en System.Xml.XmlTextReader.Read()

en System.Xml.XmlReader.MoveToContent()

en Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderChartDefinition.Read14_ChartDefinition()

Source: System.Xml

HResult: -2146232000