Import Data Missing Table

yukon

Hi,

I not sure someone already discuss before i post here. I'm trying import the data using cmdlet (NAV 2013 R2 - AU-RU9). I found "$ndo$tenantproperty" is added and "$ndo$cachesync" is missing after i run the cmdlet. And cannot open the RTC and NST is stopped showing xxx.$ndo$cachesync is missing.

Here is i used cmdlet

Import-Module "C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1"
Import-NAVData -AllCompanies -DatabaseName ImportData -FileName "D:\temp\Data.navdata" -IncludeApplication -IncludeApplicationData -IncludeGlobalData

Anybody know which rollup is fixed for this bug?

thegunzo

Please try Sync-NAVTenant and post the errors from there

yukon

Hi thegunzo,

thegunzo wrote:

Please try Sync-NAVTenant and post the errors from there

Sorry, I forgot to tell this part. I do not use Tenant.

I found "$ndo$tenantproperty" is added

My bad. This is not added when i use the import data. Demo Database has "$ndo$tenantproperty" table but it is still missing if i create database from Development Client. Please see my screen capture.

"$ndo$cachesync" is missing after i run the cmdlet

.

Server instance: NAV71_AU
User:
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException
SuppressMessage: False
SuppressExceptionCreatedEvent: False
FatalityScope: None
Message:
The following SQL error was unexpected.
Invalid object name 'ImportData.dbo.$ndo$cachesync'.
Statement(s) could not be prepared.
SQL statement:
SELECT [Server Instance ID], CONVERT(BIGINT, [timestamp]), [modifiedtables] FROM [ImportData].[dbo].[$ndo$cachesync] WITH (READCOMMITTED) WHERE [timestamp] > @timestamp

Do not know why missing this table. And cannot find the hotfix for this.



Regards,
Yukon

thegunzo

Hi

Sync-NAVTenant is also used in single-database-environment

In that case the tenant name is Default so you can use that or skip the -Tenant part all to gether.

yukon

Hi thegunzo,

Thanks for your reply.

thegunzo wrote:

Sync-NAVTenant is also used in single-database-environment

In that case the tenant name is Default so you can use that or skip the -Tenant part all to gether.

I run the Sync. cmdlet as below. I can open the Card, List after i sync-tenant. But unable to run the report, insert the line. Application is crash with previous error.

Sync-NAVTenant -ServerInstance NAV71_AU

FYI: I can run application(Create Doc, Running report) after i manual create the "$ndo$cachesync" table. I don't think that is correct way.


Regards,
Yukon

thegunzo

I think you need to send this issue to Microsoft.
Do the manual fix if needed, but it would be nice to have a database backup for Microsoft prior to the fix.