RTC/WS Error: The metadata of table is invalid

Rafal07BC

Hello all.

I am viewing this great forum for quite a while but this is my first post on this forum.

I have problem with RTC and Web Services on Nav 2009 R2 build 32012.
This is a three tier installation with nav server and database on seperate machines.
Database is used by users through classic client but there was a need for web services, so middle tier was installed.

I have developed WS and everything was working fine untill I modified table 156. This table is used by web service.
Since then every time i call my web service, or try to open Resource page from RTC I am receiving error:

The metadata of table 156 is invalid. See Event Viewer for more details.

The event viewer log looks like this:

0200x800000000000001665ApplicationPLNAS01.eu.sdimediagroup.comService: MicrosoftDynamicsNavWS User: UserName Type: System.Xml.XmlException LineNumber: 236 LinePosition: 145 Message: '', hexadecimal value 0x14, is an invalid character. Line 236, position 145. StackTrace: at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args) at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String[] args) at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar) at System.Xml.XmlTextReaderImpl.ParseAttributeValueSlow(Int32 curPos, Char quoteChar, NodeData attr) at System.Xml.XmlTextReaderImpl.ParseAttributes() at System.Xml.XmlTextReaderImpl.ParseElement() at System.Xml.XmlTextReaderImpl.ParseElementContent() at System.Xml.XmlTextReaderImpl.Read() at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace) at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc) at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) at System.Xml.XmlDocument.Load(XmlReader reader) at System.Xml.XmlDocument.LoadXml(String xml) at Microsoft.Dynamics.Nav.Service.Metadata.MetadataProvider.GetNavObjectAsXMLDocument(Int32 id, ObjectType navObjectType) at Microsoft.Dynamics.Nav.Service.Metadata.MetadataProvider.<>c__DisplayClass1.<GetTableMetadataWithExtensions>b__0() Source: System.Xml


If I import old table fob then everything starts working without restarting nav services.
This error is not specific to this modification to table 156, adding any additional field to table triggers this error.

So far I have tried this:

Recompiled all objects.
Restarted both nav server and web service service multiple times.
Changed change listener from pooling to broker.
Changed Nav server configuration to disable cache and restarted services.
Deleted metadata of table 156 from Metadata Table and recompiled table 156.

All with no success.

I will apriciate any help. Thanks.

Rafal07BC

It turns out that table had some captions with regional characters that where converted to 0x14 char in XML.
Fixing captions solved this problem.