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.!

I have the same question (0)

All responses (18)

Answers (0)

Mohammed Marhoon 12 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
anandb313@gmail.com 200 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mohammed Marhoon 12 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
anandb313@gmail.com 200 on at

Like (0)

Report

Hi,

New instance but not multi instance..It is a single instance setup.

Was this reply helpful? Yes No
Mohammed Marhoon 12 on at

Like (0)

Report

Hi

It is in one server the sql server and business server instance or two different servers?

Was this reply helpful? Yes No
anandb313@gmail.com 200 on at

Like (0)

Report

Hi,

It is one Sql server and business central server instance not two different servers.

Was this reply helpful? Yes No
Mohammed Marhoon 12 on at

Like (0)

Report

Hi

Did you try to re-setup the Cronus demo database? by remove it and reinstall it

Was this reply helpful? Yes No
anandb313@gmail.com 200 on at

Like (0)

Report

Hi,

No i have used Customized(client) DB from BC14 and from migrating to BC17 i am getting the error

Was this reply helpful? Yes No
Mohammed Marhoon 12 on at

Like (1)

Report

Hi

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

So you are migrating to which version?

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

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

Thanks.

Was this reply helpful? Yes No