BusinessObjects Board

BOXI Repository Documentor

thanks a lot for pointing that one out HRS. Unfortunately it won’t work for me on BOXI 3.1 FP1.9 and office 2007 :frowning:


Tiger37 :uk: (BOB member since 2010-04-07)

I removed the Add-Ins from Excel, however this did not resolve the issue.

I stepped through the VB Code and it failed in the “getCategories()” sub routine at the “esession.Logoff” line in the code segment -

CleanUp:
Me.Hide
On Error Resume Next
esession.Logoff
Exit Sub

Ruan


hbunicorns :us: (BOB member since 2007-05-31)

I have incomplete user list in “Usage per user”, documents list is incomplete too why:(? I change record limit few times

BOXI 3.1 sp2
office 03


kkl :poland: (BOB member since 2009-07-16)

Try running it without dates, that way you will get all the data in your repository, the Documentor processes stats only the basis of what it’s gathered.


nnoori :uk: (BOB member since 2009-11-16)

i checked every combination. Nothing helped


kkl :poland: (BOB member since 2009-07-16)

Make sure you’re running it for all formats, remove the dates and increase the document limit, we don’t have this problem on R3 so I don’t think it’s the environment. Other than that not much else I can say, hopefully the OP will come back to you.


nnoori :uk: (BOB member since 2009-11-16)

checked too. same problem in v6 and v7


kkl :poland: (BOB member since 2009-07-16)

Very good tool. Thanks for sharing HRS. However , I am able to work it with Xir3 but not with Xir2. I tried changing the refernces. But still not able ot login. I have both Xir2 and Xir3 clients on my machine. I will try to run this excel sheet on another machine where I have only Xir2.


Indira_M (BOB member since 2006-11-27)

Hi,

I have the same problem, please someone know how could i solve it?

Hello HRS,

I would really love to use your tool, however I am receiving a Run-time error.

Here is the error message
Run-time error ‘-2147417848 (80010108)’:
Automation error
The object invoked has disconnected from its clients.

I am using BO XI 3.1 SP2 and Excel 2003 SP3. I have Designer installed on this PC and I have all the necessary 12.0 References.

Can you help?

Ruan

Best regards


ALDEHIDO (BOB member since 2009-10-05)

Is someone able to run it for XI R2? i have chnaged the ref but still it has errors
Can anyone please post working version of spreadsheet for XI R2, Really appreciate it

thanks
Nirav


nniravv :india: (BOB member since 2007-08-16)

Hi Nniravv, i have a working version for XI R2, how can i send it to you?
Alex.


larrieae (BOB member since 2010-06-24)

Hi Alex
Thanks for response.
My id is nniravv@gmail.com…thanks a lot.


nniravv :india: (BOB member since 2007-08-16)

anyone try with SP3 yet ?

BOXI 3.1 SP3/Excel 2007 … after clicking “Get Document Details” and typing in my CMS, administrator userid, password … :

Getting: Failure in GetCategories()
VBAProject - -2147024769: Automation error
The specified procedure could not be found. 1000440

after clicking OK, i get the same error message in this dialogue box: Failure in btnExtData_Click()


Chris Pohl :us: (BOB member since 2002-06-18)

is it possible for CMS to = cluster name…

how do you setup if you are not running on default port 6400 ??

Thanks
Bryan


bthomps01 :us: (BOB member since 2007-01-09)

I also get the error:

Run-time error ‘-2147417848 (80010108)’:
Automation error
The object invoked has disconnected from its clients.

I am using XIR3.0 Excel 2007.

I would really love to use this tool if someone could help.


kmacdonald (BOB member since 2009-01-08)

@bthomps01 - yes you can use all options you have when logging on to DESKI / Designer

@kmacdonald / Chris Pohl
This utility does work with XI R3.1 sp3 and Excel 2007. I have seen similar messages when running the utility on the Windows Server itself.
Could you please confirm that you have all the client tools installed and running the utility on a client machine.

HRS


Sushir Patel :uk: (BOB member since 2006-04-19)

It is strange because my colleague can run it and we seemingly have the same setup. We are both running it on our own machines and not the server itself. I have all of the client tools installed and I compared libraries and add-ins with her machine to see any differences there and there weren’t any.


kmacdonald (BOB member since 2009-01-08)

Hi Alex,
If you have working version for XI R2 could you please send it to me

ravikanti@yahoo.com

Thanks
Murthy


mravikan (BOB member since 2008-03-12)

Hi Can you please post the Repository Documennter for BO Xi r2

Thanks


usbhargav (BOB member since 2006-10-26)

I got the same error and I solved it by removing the BQY add-in, exiting excel and double-click on the xls file to restart excel.


stef (BOB member since 2004-01-14)