Data imported into NAV2015 not available until compiled

spider1269

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.

EvR

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?

ara3n

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.

spider1269

Resolved! After some digging the original code was being run as a SQL script. Putting the script in an SSIS package fixed the issue.