Small and medium business | Business Central, N...

Sync-NAVTenant : The following SQL error was unexpected: Cannot find the object *** because it does not exist or you do not have permissions.

(0) Share

Report

Posted on by anandb313@gmail.com

200

When i synchronize the Business central application DB.using the commenad "Sync-NAVTenant -ServerInstance BC170 -Mode Sync" it gives me error like "Sync-NAVTenant : The following SQL error was unexpected:
Cannot find the object "********" because it does not exist or you do not have permissions." I also trie with Force. But still it returns the error. It is a upgrade process.The problem is i cannot find the object in sqlDB

Can anyone help me? Thanks IN ADVANCE.!

All responses (18)

Answers (0)

Sort by

Mohammed Marhoon 12 on at

Like (2)

Report
Copy link

Link copied!

Hi

Your database sql server on the same server of business central or separate?

if separate then be sure the login windows server in the business central server provisioned in sql server to have permission access the databases in sql server

Provisioning the Business Central Server Service Account

Please Verify the answer if your question has been answered. This helps other forum users.
anandb313@gmail.com 200 on at

Like (0)

Report
Copy link

Link copied!

Hi Marhoon, Thanks for replying. Yes now i have changed to user account. i am receiving a error of

"Sync-NAVTenant : The following SQL error was unexpected:

Column names in each table must be unique. Column name '$systemCreatedBy' in table 'Object Metadata Snapshot' is specified more than once." But as i checked there is only one name in column '$systemCreatedby' in that table

Thanks,

Anand
Mohammed Marhoon 12 on at

Like (0)

Report
Copy link

Link copied!

Hi

You are setup a new instance? or this existing and you convert it to multi tenant? or its a single setup?

I notice you state you are sync application db!

If you are on multi tenant setup and after you mount the company database then you need to perform "Sync-NAVTenant' on the company database not the application database

example

$NewBcServerInstance = "BC170"

$TenantId = "Cronus"

Sync-NAVTenant -ServerInstance $NewBcServerInstance -Tenant $TenantId -Mode Sync

Please Verify the answer if your question has been answered. This helps other forum users.
anandb313@gmail.com 200 on at

Like (0)

Report
Copy link

Link copied!

Hi,

New instance but not multi instance..It is a single instance setup.
Mohammed Marhoon 12 on at

Like (0)

Report
Copy link

Link copied!

Hi

It is in one server the sql server and business server instance or two different servers?
anandb313@gmail.com 200 on at

Like (0)

Report
Copy link

Link copied!

Hi,

It is one Sql server and business central server instance not two different servers.
Mohammed Marhoon 12 on at

Like (0)

Report
Copy link

Link copied!

Hi

Did you try to re-setup the Cronus demo database? by remove it and reinstall it
anandb313@gmail.com 200 on at

Like (0)

Report
Copy link

Link copied!

Hi,

No i have used Customized(client) DB from BC14 and from migrating to BC17 i am getting the error
Mohammed Marhoon 12 on at

Like (1)

Report
Copy link

Link copied!

Hi

Its better you elaborate more, so I can help you on the same.

So you are migrating to which version?
Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

Maybe it is best to raise a support request via your Dynamics 365 partner.

Thanks.