Import Data Missing Table

yukonyukon Member Posts: 361
edited 2014-11-27 in NAV Three Tier
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?

Make Simple & Easy

Comments

  • thegunzothegunzo Member Posts: 274
    Please try Sync-NAVTenant and post the errors from there
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
  • yukonyukon Member Posts: 361
    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
    Make Simple & Easy
  • thegunzothegunzo Member Posts: 274
    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.
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
  • yukonyukon Member Posts: 361
    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
    Make Simple & Easy
  • thegunzothegunzo Member Posts: 274
    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.
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
Sign In or Register to comment.