mibuso.com
Home› NAV Three Tier
Options

Data imported into NAV2015 not available until compiled

spider1269spider1269 Member Posts: 68
in NAV Three Tier
I'm importing data into a buffer table in NAV2015. The issue is that the data isn't in the table until I recompile the table. What's odd is that it happens only 50% of the time. I've been using the same SSIS package for the last 7 years and haven't had any issues until I started testing with NAV2015. We're on NAV5.0SP1 now but will be upgrading soon.

Answers

  • Options
    EvREvR Member Posts: 178
    edited 2015-12-29
    What do you mean by 'the data isn't in the table'?
    At what point?
    Not showing in a list page, or not in the SQL database?
    Is it a new table that just got imported via a fob?
    If so, did you synchronize the schema changes before trying to use it?
    Using SSIS, do you actually create new tables or are you just inserting data into existing tables?
  • Options
    ara3nara3n Member Posts: 9,256
    The issue is that you are inserting directly into the table through sql.

    You need to add in your code

    SELECTLATESTVERSION

    This will cause the middle tier to not use the cache.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    spider1269spider1269 Member Posts: 68
    Resolved! After some digging the original code was being run as a SQL script. Putting the script in an SSIS package fixed the issue.
Sign In or Register to comment.