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

I have the same question (0)

All responses (6)

Answers (3)

Suggested answer

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

Like (0)

Report

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

may be you have not removed all customizations?

Was this reply helpful? Yes No
Verified answer

Zaid Tariq 2,274 on at

Like (0)

Report

Well Thanks but i already had tried this.

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

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Zaid Tariq 2,274 on at

Like (2)

Report
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/.../)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Zaid Tariq 2,274 on at

Like (0)

Report

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

Use [Type] instead of Type.

Thanks

Was this reply helpful? Yes No