Error in NAV 2018 on Export-NAVData/Import-NAVData

ArmondsArmonds Posts: 57Member
When I try to export company in event viewer I get error: "Data is Null. This method or property cannot be called on Null values"

On import error is: "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

I think in both cases error is raised by the same field or property.

On export error occurs almost immediately, but on import after all data is imported end on the finalization phase.

I tried to check for some exceptions with SQL Profiler, but didn't found anything suspicious.

What could cause this error or how to find/source if it?

Other NAV functionality works without errors, database is synchronized...

Answers

  • DuikmeesterDuikmeester Hoorn, The NetherlandsPosts: 220Member
    Sounds like there is a DateTime field with a value Null. However NAV does not allow that value and could only come from inserting data in Sql directly.
  • ArmondsArmonds Posts: 57Member
    I also thought so.

    I checked all global tables in SQL but didn't found any date field with NULL.

    And also, if i'm not wrong, in NAV date field are not null by default (except taskscheduler system table)
Sign In or Register to comment.