BOXI Repository Documentor

system · October 18, 2010, 6:18pm

After removing the Business Query Add-In’s (and rebooting) i’m now getting:

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

system · October 19, 2010, 5:25pm

Every few years I come here to grab a tool and it justifies every penny I spend here.

Even better, this one justified all the time I spend here, which is much harder. Huge thanks to the author.

Cris E (BOB member since 2005-03-18)

system · October 20, 2010, 2:26am

Hi,

Its very nice tool to see the Repository. I feel it will be good, if you can add one more sheet with space usage by Project folder also.

Thanks,
Shyam.

vsshyam (BOB member since 2003-11-11)

system · November 9, 2010, 3:12pm

Hi All,

Any help will be highly appreciated.

I am using XI 3.1 SP 2 FP 2.3 and Excel 2003 SP3.

I am getting error message -

CrystalEnterprise12.FW_InfoObject.1 - -2147210694: 1000440

and process stops.
Can you please provide some insight.

I also want to find out list of reports that will be impacted by changing an object in a universe in webi. Is thr a tool available for it.

Thanks & Regards
Arun

Arun@SHP (BOB member since 2010-11-02)

system · November 10, 2010, 6:43am

Yes, I too received this error - the document works perfectly up until that point and then it crashes. Any idea what its about?

XI 3.1 SP 2 FP 2.4 and Excel 2007.

BOMensch (BOB member since 2010-07-20)

system · November 12, 2010, 12:07pm

Thanks Dear It’s very nice tool to check repository

Anis_gul (BOB member since 2010-03-05)

system · January 1, 2011, 4:30pm

Hi,

Here are the 8th versions of HRS’s BOXI Repository Documentor tools.

I am attaching them here since it’s not possible to merge HRS’s post in the BOB’s Uploads section with this topic.
BOXI Repository Documentor R3 v8.zip (402.0 KB)
BOXI Repository Documentor R2 v8.zip (418.0 KB)

Marek Chladny (BOB member since 2003-11-27)

system · January 4, 2011, 3:04pm

I’ve tried from version 4…to 8…
each time I get this error
:Run-time errr -2147417848 (800010108)

Automation error
The object invoked has disconnected from its clients.

What causes this error?

XI 3.1 SP3
EXCel 2007

dwayneat (BOB member since 2005-11-11)

system · January 4, 2011, 4:32pm

I used to have same, upgraded excel and it works fine
Excel 2007 SP2 MSO (12.0.6425.1000)

Maybe try it on someone elses PC to confirm

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

system · January 6, 2011, 1:29am

I am getting the error: “VBAProject - 91: Object variable or With block variable not set 1000091”.

I am using Excel 2007

How to correct the problem

vsshyam (BOB member since 2003-11-11)

system · January 6, 2011, 9:08pm

Dumb question but just to make sure, if my CMS name is “BO_DEV”, what exactly am I entering in the CMS field?

BOxed (BOB member since 2011-01-06)

system · March 9, 2011, 7:48am

Hello ,

We are using XI R2. When I run this macro I am getting this error below.

CrystalEnterprise12.SessionMgr.1 - -2147024891: 1000440

I went references tab and selected all the 11.5 dll’s but still I am facing the problem.

Can anyone please help me.

julshavar (BOB member since 2011-03-09)

system · March 17, 2011, 11:37am

Downloaded and used R2 v8, work great, ta very much.

One thing though, only giving me two universes instead of 200. Any ideas? Were on BOXI R2 SP3, if that helps.

menace (BOB member since 2011-03-08)

system · April 1, 2011, 8:15pm

Really nice tool have been using it from some time…Thanks a lot

Dose any one know how we can get the parameters included in it. I tried with si_prompts, but no luck.

Any help or suggestions are appreciated.

writetoprav (BOB member since 2007-04-09)

system · April 12, 2011, 7:32am

I second that last request - doing a migration with a lot of reports that have prompts and would love to be able to get a list of the prompts so that I can go back to the developers and ask them what a good value for those prompts would be.

Other than that - what a FAB tool! Great work!

Orange (BOB member since 2006-09-18)

system · April 22, 2011, 12:01pm

I needed to change the following in the macro to get it work (XI 31 version)

CreateObject (“CrystalEnterprise.SessionMgr”) by

CreateObject (“CrystalEnterprise12.SessionMgr.1”)

Actually the correct string can be found by doing a search for “CrystalEnterprise.SessionMgr” in the registry to get the proper ProgId

Hope this helps

fdu (BOB member since 2010-11-22)

system · April 27, 2011, 3:32pm

Anyone know if it is possible to have the name of the connection show up if the report is using one or more ODBC connections rather than a universe? That is the only thing I am missing to be able to replace a manual excel sheet that we keep today!

Thanks to all who have made this thing as great as it is!

Supergrov (BOB member since 2009-01-28)

system · May 2, 2011, 7:32pm

Can you ran this tool from any workstation?

icotler (BOB member since 2002-08-19)

system · May 17, 2011, 4:22pm

HRS…GREAT TOOL!!

I have a couple of questions about v8. We are using the tool and getting most of our data from the repository on a BOE 3.1 SP3 environment.

It seems that we are not getting all our users under Usage by User (My account is missing along with 75 others) We have the set the Document Record limit at 100000 and are not using start/end dates. Doc types, Output Doc type when scheduled and Statii are all set to ‘All’
When we look at the Grand Total at the bottom of the T column, it is showing we are using 271GB out of 300GB. When we look at the file store it is showing we have 35GB of free space. There seems to be a discrepancy in the calculation somewhere in the spreadsheet.

Any assistance you can provide would be most grateful.

surgeon648 (BOB member since 2009-07-31)

system · May 17, 2011, 4:25pm

HRS…It dawned on me since we appear to be missing users, the 4GB discrepancy could be found there. I am thinking if we had all users our totals would tie out.

Thanks again.

surgeon648 (BOB member since 2009-07-31)