Did you capture the SQL being generated ?
Any date conditions involved ?
Do you have different connections to different databases (test/prod) Did you check this wasn’t caused by “partial results” returned ?
Listserv Archives (BOB member since 2002-06-25)
We had this problem as well. We found that indexes on the main table caused problems specifically.
Changing the array fetch size to 1 does work (There is a note in the techsupport site for this isssue with SQL 6.5 - Resolution Entry 246) but means that data is returned to the user very slowly.
We have raised this as an issue with BusinessObjects and they are supposed to be looking at it.
Hayden Gill
The University of Queensland
Brisbane, Australia
" The situation is that a query will run and produce a result. With no
change to the data warehouse, re-running the exact same query will intermittently produce a different result."
We had this problem a while ago. We were getting a different number of rows returned every time we ran the same query. Try changing the advanced settings for your connection to the following:
Connection Properties = Disconnect after each transaction Connection Mode = Use asynchronous mode
Array fetch size: 1
Listserv Archives (BOB member since 2002-06-25)