Error: Table 2000000009 has no name

If you get following error: then the database is corrupted. In detail it means sql view “Session” is missing in the database! This can be a result of a crashed backup/restore process or a failed conversion process. It can be, that View “Database File” is also missing. Although it is possible to restore the missing view… Continue reading Error: Table 2000000009 has no name

Active Directory queries from C/AL

I wanted to get a list of all NAV users with displayname and roles per user in a report. The data base is table “Windows Access Control”. One field should show the displayname of each user. The displayname can be read from hidden table “Windows Object”, field Name. To embed that value in the report i tried to import the field with different… Continue reading Active Directory queries from C/AL

Error: Could not load the selected type library

This is a common error, which can be caused by following reasons: an automation is missing the automation was missing, then installed on the system, but the nav object was not re-compiled after installation a different version of the automation is expected by the nav object. If this error occurs, check where the variable is defined (local… Continue reading Error: Could not load the selected type library

Process decimal values with different regional settings

When importing/processing decimal values, the decimal separator is . or , according to the regional setting. Assuming you want to import decimal values with US Standard regional setting, then the separator is a point (.). To process such decimal values, you can work with the NAV Command GLOBALLANGUAGE. That is the in NAV at runtime used… Continue reading Process decimal values with different regional settings

You cannot create an Automation object ‘name of autom.’ on Microsoft Dynamics NAV Server. You must create it on a client computer.

This is an error message, when trying to create an instance of an automation on a nav server vs. >= 2013. It’s only possible to create the automation instance as client instance. Creating automation instances on nav server is allowed till nav 2009. solution: use create(<name_of_autom.>,false,true) instead of create(<name_of_autom.>). remarks: you need a installed version… Continue reading You cannot create an Automation object ‘name of autom.’ on Microsoft Dynamics NAV Server. You must create it on a client computer.