NAV 2016 Startup Error Metadata was changed for table () due to invalid characters.

ara3n
ara3n Member Posts: 9,258
in NAV Three Tier
I get the following error when starting the middle tier.

Server instance: JobQueue
Session type: UnknownClient
Session ID: 2
Metadata was changed for table () due to invalid characters.

Found in ID: ControlDefinition, Language: ame.

Anybody knows how to find the object?
Ahmed Rashed Amini
Independent Consultant/Developer


blog: https://dynamicsuser.net/nav/b/ara3n

Comments

  • Hayan
    Hayan Member Posts: 110
    hey Ar3an,
    did you find a solution for the above problem. I am facing the same issue.

    Thank you in advance.

    Best
    HAYAN
  • ara3n
    ara3n Member Posts: 9,258
    It has been a while but if I remember, I used process of elimination and went through all the objects. Deleted the customized objects one at a time and restarted the service tier. Once I found the object, I recreated the object.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • jwilder
    jwilder Member Posts: 263
    There seems to be 2 flavors of this error, the one above and a similar error where it lists the object id like this: "Metadata was changed for table 18 (Customer) due to invalid characters.". I had this on 2 tables (18 and 111) and by comparing the table to the base Cronus table easily found the offending character. In my case there was a bad character (looks like an enter) in the fieldgroup data. To fix got to dev environment (C/AL), design the table and then go to field groups. The name field had some extra spaces after the name. I removed them and problem solved.

    Similar but separate issue I also have the same error noted at the top of this post:
    Metadata was changed for table () due to invalid characters.
    Found in ID: ControlDefinition, Language: ame.

    I will try to solve based on what was suggested above and will post when I have more info on this.
    Jason Wilder
    jwilder@stonewallkitchen.com
  • jwilder
    jwilder Member Posts: 263
    edited 2019-04-25
    I have a fix for the less descriptive error that looks something like this:
    Server instance: DynamicsNAV110-2
    Tenant: <ii>nav-systemapplication</ii>
    <ii>Session type: UnknownClient
    Session ID: 4
    Metadata was changed for table () due to invalid characters.

    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.
    Found in ID: ControlDefinition, Language: ESM.</ii>

    Process of elimination does seem to be the easiest way to find the offending object (delete objects until the error goes away). In my case it is Page 5982 “Service Item Statistics”. There are 17 controls in that object that have a tooltip under the ESM language with a weird character in it. Here is a picture:
    6ah1cdb4dpi7.png

    To fix you can remove that one character from each control tooltip or you can simply just remove the ESM language from the object if you don't need it.

    This issue exists in the NAV 2018 CU4 Cronus object but guessing it was fixed in a later version.
    Jason Wilder
    jwilder@stonewallkitchen.com

Categories