Smarlist retrieves more than no. of records asked for

[barbola]

Interesting, not sure if this is a 9.0 glitch, but I have a Smartlist report that says at the bottom:

6118 Account Tran | Completed | First 1000 records where...

 

[VictoriaYudin]

Wow, I can't say that I've ever seen that happen...and I use SmartList a LOT! Do you have the GP 9.0 instance service packed? Can you reproduce this or was it just a one time thing?

 

[barbola]

I think maybe it was a one-time incident. Yes we are on SP1 of GP9. The second time I ran this it worked. very strange.

I wanted to send a screen shot to our VAR but they would probably charge us!!

b.

 

[VictoriaYudin]

Usually you see wacky stuff like the wrong number of results returned, when you've lost and regained connection to the SQL Server. GP doesn't have anything built in to notify you that this happened and might cause a problem, but it usually doesn't recover from a lost connection as gracefully as some other applications...

If you keep seeing this king of stuff regularly (not necessarily this exact scenario, but similar issues) then you should take a look at your network and connectivity to the SQL Server a little closer. Otherwise, take screen shots and keep them in case you need them down the road.

V.