Metadata Error with Universal Excel Importer

dipakpatel2505dipakpatel2505 Member Posts: 169
edited 2010-01-12 in NAV Three Tier
Hi All,

I have following Scenario:
1) I have created Form and I am importing Data in Form using Universal Excel Importer
2) I have Transfered Form into Page using Transformation Tools.Page is running properly.

Problem:
Metadata for Codeunit of Universal Excel Importer already exists in table 2000000071 Object Metadata.Page is running properly but when I try to import data from Page using Universal Excel Import, I am getting error of metadata.

Thaks a lot in advance.........

With Best Regards,
Dipak Patel

Comments

  • ara3nara3n Member Posts: 9,256
    recompile object Codeunit 60000.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • dipakpatel2505dipakpatel2505 Member Posts: 169
    Hi Rashed,
    I have recompiled object Codeunit 60000 and then again tried to Import Data using Universal Excel Importer on Page but I am getting same error.

    With Best Regards,
    Dipak Patel
  • ara3nara3n Member Posts: 9,256
    delete all the records from Object Tracking table. Restart the service tier and recompile the object.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • dipakpatel2505dipakpatel2505 Member Posts: 169
    Hi Rashed,
    What do you mean by Object Tracking table i.e. from which table I should delete Records.

    With Best Regards,
    Dipak Patel
  • ara3nara3n Member Posts: 9,256
    Go to Tool->Object designer ->find the table Object Tracking (2000000079)

    Run the table and delete all the records from the table.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • dipakpatel2505dipakpatel2505 Member Posts: 169
    Hi Rashed,

    Thanks for Reply.
    I have deleted all records from Table Object Tracking (2000000079) and restarted the services but still the problem is not resolved.

    I am still getting the same error.

    With Best Regards,
    Dipak Patel
  • ara3nara3n Member Posts: 9,256
    And you recompiled the object?

    Are you even in the same database? The service tier and the Classic client?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • dipakpatel2505dipakpatel2505 Member Posts: 169
    Hi,
    I have recompiled all object and restarted the services. But Still the problem is not solved.

    Ya I am in the same Database.

    With Best Regards,
    Dipak Patel
  • ara3nara3n Member Posts: 9,256
    Just compile that object. repeat the steps. delete the record from object tracking.

    restart the service tier. compile that one object.

    And I'm assuming Enable for Microsoft Dynamics NAV Server is checked.

    In file ->database->Alter->Option tab?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ara3nara3n Member Posts: 9,256
    Hi,
    Ya I am in the same Database.
    l
    How did you check this?

    Did you modify a record and the same record was updated in classic?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • dipakpatel2505dipakpatel2505 Member Posts: 169
    Hi,

    I have compiled Object then Deleted Records from Object Tracking Table then Restarted Services and once again compiled Object.Ya,"Enable for Microsoft Dynamics NAV Server" is checked in File ->database->Alter->Option tab.

    I have checked using CustomSetting File and I have not modified any record.

    With Best Regards,
    Dipak Patel
  • ara3nara3n Member Posts: 9,256
    Check the event log on the service tier.

    By the way can you also tell me if the db sql and client are on same box or different box.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.