One of my users is receiving this BQ0035 OLE Automation Error when he is refreshing his BQ files. Has anybody expercienced this. We are on 6.5.2
Thanks for any advice!
susie (BOB member since 2005-05-02)
We are getting the same error. Please keep me informed if you have a solution.
We are running version 6.5.1 and it looks like it happens when in the query properties the smartspace strategy is set to columns insert, rows copy.
Fastwing (BOB member since 2005-08-15)
We’re on 5.1.8 and we get that when the user has an Excel pivot table in the same sheet as the query, AND the query has a smartspace strategy other than “overwrite” in both rows and columns.
We reported it to Business Objects some time ago. . .no fix yet.
Our workaround is to move the pivot table to a different sheet in the same Excel file – OR – change the smartspace strategy to “overwrite”.
KSG 
(BOB member since 2002-07-17)
Did you ever find a solution to this. We are converting to 6.5 and it happens when we try to insert an existing query as is. I will try some of the smart space strategy mentioned by some of the others.
update: smart space strategy did not help. I did compare the 5.17 bqapi.dll file with the 6.5 bqapi.dll and it looks like an issue with the way they built the insert query code. If we come up with a solution, I will update this. If you have found a different solution, I would appreciate an update.
Kit Carson (BOB member since 2005-06-15)