RTC/WS Error: The metadata of table is invalid

Rafal07BC
Member Posts: 5
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.
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.
0
Comments
-
It turns out that table had some captions with regional characters that where converted to 0x14 char in XML.
Fixing captions solved this problem.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions