Error Publishing Extension Package - NAV 2017

(1) Share

Report

Posted on by Zaid Tariq

2,274

Hi,
I am facing an error while publishing the .navx to the NAV instance. I have upgraded a database from NAV 5.0 to 2017 and its is working fine. Then I did some customization in the upgraded database and exported these changes and deleted from the changes from the database so that i can deploy them using extensions. I am able to develop a .navx package but not able to the publish it to the service. The error is as follow:
Publish-NAVApp : An item with the same key has already been added.

*This post is locked for comments

All responses (6)

Answers (3)

Verified answer

Zaid Tariq 2,274 on at

Like (0)

Report

RE: Error Publishing Extension Package - NAV 2017

Just a small change in query: DELETE [dbo].[Object] where [Type] =0 and [Company Name] = 'ABCD'

Use [Type] instead of Type.

Thanks
Community Member on at

Like (0)

Report

RE: Error Publishing Extension Package - NAV 2017

Thanks Zaid. It helps me a lot. I was stuck in a problem like this for a long time and this is the right solution.
Verified answer

Zaid Tariq 2,274 on at

Like (2)

Report
RE: Error Publishing Extension Package - NAV 2017

I am able to solve the problem, here are the steps:
Before start following the step let assume you have two companies first ABCD and second WXYZ

Take a backup of your Database (In case something went wrong)

Go to SQL Server Management Studio and select your database at which you are publishing extension.

Right click on that db and select New Query.

Run the following Query:
DELETE [dbo].[Object] where [Type] =0 and [Company Name] = 'ABCD'
*If you have more than one company, run above query for all by replacing ABCD with you company name. Repeat until only one (any of them) is left like i have deleted object for ABCD so only one compnay is left which is WXYZ in my case.

Now Run the following Query:
UPDATE [dbo].[Object] SET [Company Name] = '' WHERE [Type] = 0

You are done, now Publish and Install the extension. Don't forget to like or share your feedback if this is helpful. (For more info follow my post at: www.navision360.com/.../)
Mohana Yadav 60,232 Super User 2025 Season 1 on at

Like (0)

Report

RE: Error Publishing Extension Package - NAV 2017

then you need to look if you have added any keys and key has same combination of fields in another key
Verified answer

Zaid Tariq 2,274 on at

Like (0)

Report

RE: Error Publishing Extension Package - NAV 2017

Well Thanks but i already had tried this.
Suggested answer

Mohana Yadav 60,232 Super User 2025 Season 1 on at

Like (0)

Report

RE: Error Publishing Extension Package - NAV 2017

instead of deleting from database, can you restore new database before customizations and try to publish?

may be you have not removed all customizations?