CODEWITHSUNDEEP
acumatica
Maxime
Maxime

Reputation: 858

Unable to publish any customization

For some reason I'm now unable to publish any package on my local Acumatica v.6.10 (I dont know how nor why it happened, it's a shared developpment environnement)

Here's the error I get :

The database schema for the current user contains objects that are not included in the dbo schema. Customizations can work incorrectly. For customizations to work properly, modify the schema for the current user.

I'm not a mssql expert, but I dont understand the error, I tried googling it and looking what's the use of dbo, but I didnt manage to find a solution yet.

Do you have any hints about how to debug this issue ? And locate the differences between the dbo schema and the database schema ?

Thanks,

Upvotes: 0

Views: 134

Answers (1)

Hugues Beauséjour
Hugues Beauséjour

Reputation: 8278

Check if you have some duplicates Stored Procedures/Views/etc.. in database using Microsoft SQL Management Studio that don't begin with prefix 'dbo' and delete them.

This is an example of the issue:

enter image description here

There are duplicates stored proc that are in 'acumaticaUser' and 'dbo' schema: - acumaticaUser.pp_RegisterAdminUser / dbo.pp_RegisterAdminUser

Deleting the duplicates that have 'acumaticaUser' resolves the issue and error messages will disappear.

Upvotes: 1

Related Questions