Unable to Create tables using Dynamics NAV 2009 R2

(0) Share

Report

Posted on by Abhishek Godisela

645

Hi all,

I have been using Navison 2009 R2 since a couple of months with SQL server 2008 R2. I am facing an issue to create a table using Dynamics NAV 2009 R2 in the sample data company.

I am getting the following error when I am trying to create a new table using NAV:

I can create tables using SQL server 2008 R2, but unable to create using NAV table create option.

Any help would be appreciated.

Regards,

Abhishek.G

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

What ID are you giving for the table while creating?

Which License are you using?

If customer License then check whether you have permissions to create with that ID.

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

Hi Abhishek!

Only 2 options:

- Licence issue.

- User/Role permissions.

Check that out!

...and good luck :-)

Miguel Llorca.

Was this reply helpful? Yes No
Abhishek Godisela 645 on at

Like (0)

Report

Miguel,

Thanks for the quick response.

Where do I check the User/Role permissions in NAV?

Thanks in advance.

--

Regards,

Abhishek

Was this reply helpful? Yes No
Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

Sure!

Go to: "Tools" --> "Security" --> "Roles" (check the user and de assigned role).

In order to check the license: "Tools" --> "License Information"

If you need anything else, let me know :-)

Regards,

Was this reply helpful? Yes No
J Sampath Kumar 10 on at

Like (0)

Report

Hi Miguel,

I am new to MS Navision and facing the same issue.

I am confused, under which role id I have check, give me some idea to proceed

if posible could please provide me the screenshot

Thanks in advance.

Regards,

J Sampath Kumar.

Was this reply helpful? Yes No
Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

Hi,

You must go to "Tools" --> Security" --> Login (depends if you are using Windows or Database login):

Then, select the user which you are getting logged, and click "Roles":

And select the role "SUPER".

Don't forget to sync. Go to: "Tools" --> "Security" --> Synchronize All Logins.

Hope that helps!

Was this reply helpful? Yes No
Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Did you check the table ID and Permissions of your license first?

Was this reply helpful? Yes No
Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

I'm with Mohana. The first thing you should check is the license.

Go to: "Tools" --> "License information"... and at the bottom you will find your assigned IDs (and the corresponding permissions).

Was this reply helpful? Yes No
Suggested answer

Aleksandar Totovic 16,765 on at

Like (0)

Report

This for sure is not related with security roles. I know this message and this is standard message that license does not include required object ID.

I think it's a user license (not partner) and if you have not Application Builder or Solution Developer granules, you may create tables only on 50000+ range (if you bought additional tables). Even if you use 50000+ range, you must see license file which object range you can use.

Maybe you have additional tables, but you are wrong with table ID. Maybe you have not additional tables.

Was this reply helpful? Yes No
Abhishek Godisela 645 on at

Like (0)

Report

Hi all,

I have checked the user permissions, the user has all the roles required. But when I am trying to synchronize the login, I am getting the following error.

Mohana,

How do I check the table ID and Permissions of our license. Because this is what appears when I click on license information.

Any help would be appreciated.

Thanks in advance

--

Regards,

Abhishek

Was this reply helpful? Yes No