Integer table in Dataports

olga

Hello,
I've got the problem. I have 4.0 SP1 Navision version on SQL. I've created a new dataport for export with one dataitem - Integer table. There is no filter on that table, I just break dataport when it is needed. But I don't know how many Integer table rows dataport will use during runnig process. When I push Run button the strange form appears. There is shown that rows of Integer table are being counted. They are counted till 1,000,000,000 and it takes long.
When I tryed the same with 4.0 SP1 Navision version on Native and 2.6 Navision version on SQL the strange form did not appear.
Can anybody help me with such a problem?
Thanks.

Olga

Luc_VanDyck

This is a confirmed bug and it will be resolved in 4.0 SP2.

Extract from ChangesW140SP2.doc:

P7) Dataport And Counting Records In Navision SQL Server Option

Error

Dataport for table integer would run and would always be counting the records. Dataport should run on SQL Server in the same way as on the Native database.

kine

You can solve it through adding TableView filter on the Integer dataitem with filter 1..