Repository Diagnostic Tool

system · May 29, 2008, 7:17pm

I’ve been playing around with the Repository Diagnostic Tool, but haven’t had much joy with it. The documentation is rather anemic, so I’m struggling to figure it out on my own. I created a seperate text file with the options that I want. I hope I set that up correctly. It looks like this:

-dbdriver mysqldatabasesubsystem
-connect UID=XXXX;PWD=XXXX;DSN=BOE_CMS
-repair true
-inputfrsdir C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Input
-outputfrsdir C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Output

Note: UID and PWD are removed for security reasons

I stored this in the same file with the tool, so my command line is as follows:

"C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\reposcan.exe" -options- "C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\repo_scan_options.txt"

When I run this, the command window pops up for a second, then disappears. The log files never show up. Any idea what I’m doing wrong here?

MichaelWelter (BOB member since 2002-08-08)

SebastienGoiffon · May 30, 2008, 4:07pm

Hi Michael,

What are ou talking about? The exports wihin the CMC?

Thanks for the answer.

BR
Sebastien

system · May 30, 2008, 5:28pm

Hi, Sebastien;

This has nothing to do with the CMC. The Repository Diagnostic Tool (RDT) is a new component in XI 3.0, with similar functionality to the old Scan/Repair/Compact in 5.x and 6.x.

I finally got it working this morning. There are some errors in the documentation (surprise, surprise ).

The command line parameter -options- should be -optionfile (Page 9)
-outputdir is a mandatory argument, not optional. If left out, the tool tries to write to a nonexistant folder. (Page 10)
Make sure that all referrences to directory trees are in double quotes.

MichaelWelter (BOB member since 2002-08-08)

system · May 31, 2008, 5:14am

Michael,

Thanks… for sharing. It would be even better if you put the exact code that you are using(except user/pass) for your text file and the command prompt syntax in this thread.

BO_Chief (BOB member since 2004-06-06)

system · May 31, 2008, 2:38pm

Here’s the final version of the options file:

-dbdriver sqlserverdatabasesubsystem
-connect UID=XXXX;PWD=XXXX;DSN=BOE_CMS
-repair true
-inputfrsdir "C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Input"
-outputfrsdir "C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Output"
-outputdir "C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\reposcan"

And here’s the command line that I’m running:

"C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\reposcan.exe" -optionsfile "C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\repo_scan_options.txt"

MichaelWelter (BOB member since 2002-08-08)

SebastienGoiffon · June 1, 2008, 2:15pm

After posting I remember this tool to compare CMS id and FRS id.
Never tested it.

Thanks for sharing.

BR
Sebastien

system · June 17, 2008, 6:40pm

We also got this tool to work. And it created a rather ugly xml logfile.

The documentation (and BO support) said I should be able to view this file as a pretty html file by using the rdt-scan and rdt-repair style sheets. This did not work because the style sheets were provided in an unexpected directory.

Our “fix” was to move the tool and associated resources from D:\Program File\Business Objects\BusinessObjects Enterprise12.0\reposcan to D:\Program File\Business Objects\reposcan. It works very nicely now.

By the way, we’ve had a support case open on this issue for over a week. Although we had several conversations with BO support, no solution was offered.

maxtell (BOB member since 2005-09-23)

system · March 6, 2009, 4:51am

This all looks like it could help me, but can someone tell me where the documentation for reposcan.exe is please.

davidmo (BOB member since 2002-09-26)

system · March 6, 2009, 6:39pm

Look for the xi3_bip_repository_diagnostic_tool_en.pdf document here.

MichaelWelter (BOB member since 2002-08-08)

system · March 8, 2009, 8:48pm

Thanks Michael

davidmo (BOB member since 2002-09-26)

system · March 9, 2009, 9:25am

Has anyone actually got the tool to repair the CMS or FRS?
I blew away the CMS and the BIAR backups are corrupt until 2 weeks back

MikeD (BOB member since 2002-06-18)

system · March 9, 2009, 9:01pm

The short answer is Yes. The long answer is be very very careful, or take precautions. After running reposcan I had the unfortunate situation where I couldn’t access the CMS. I couldn’t log in, I couldn’t run CCM although it opened and appeared as all services where running.
I did the next correct step and contacted SAP support. While waiting for a reply, I serched for any files that had been changed which had the same timestamp as the output file from reposcan. Lo and behold, the file;
\Business Objects\BusinessObjects Enterprise 12.0\win32_x86_boe_.dbinfo was changed.
Apparently I had made an error in the database parameters in the options file, and the support desk informed me later that if I get that wrong, and reposcan cannot find the repository, it deletes the repository conection information, which is in this file. So my definite advice is to back this file up, actually backing up the entire install directory is advisable for future reference before doing ANYTHING in the FRS or CMS.

I hav attached a copy of my 2 files I use; the options file and a batch file to run the whole thing. Note some things have been changed for security reasons.

You will notice I have moved my input and output files from the default, this was only to make backup easy and has nothing to do with reposcan. Just edit the values to match your installation.
Good luck; BusinessObjects is 2 parts codeing, 2 parts workarounds and 1 part luck.
reposcan_check_options_noID.txt (0.0 KB)
runRepoScan_noID.txt (0.0 KB)

davidmo (BOB member since 2002-09-26)

system · March 11, 2009, 4:24am

Hi davidmo - much appreciated - it’s not often that posts contain such a complete explanation along with all the details

So did your repo scan physically create a CMS entry from and FRS entry?

The scripts you posted were very similar to the ones that I ran - and I don’t have an issue with connectivity as the repo scan does run and identifies all the missing entries - it just won’t repair them lol

Inconsistent Filename: ~ce20dc5498d4538c3.wid
Directory: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Input\a_000\017\000\4352\
Total Inconsistencies: 1

Inconsistency Warning Suggestion

File C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Input\a_000\017\000\4352~ce20dc5498d4538c3.wid exists in the Input or Output FRS, but there is no corresponding InfoObject in the repository. Please republish the file. The application will not publish this file for you

So I’ve been trying the option of creating a shell webi report and then physically copying these entries into the shell just so as to use the idenifier in the repository. I’m getting some weired results with this. but will persevere until my patience runs out.

I just can’t see why it’s such an issue for the reposcan to not be able to regenerate the repo details - I basically have a 10 day gap between CMS entries and the FRS.

MikeD (BOB member since 2002-06-18)

system · March 11, 2009, 8:40pm

Thanks
I think that writting an application to fix the missing links would pose a few problems. I opened each file directly from the Filestore and found that they all were duplicates so I just deleted them and the next run deleted the empty directory. If there were any (wich there weren’t) that were not duplicated, then I would have saved them somewhere with the correct name, deleted the one in the Filestore, ran reposcan to delete the empty folder then republish.
I feel that efforts to write a better reposcan would be better putting into fixing what causes the problem. A bit like shutting the gate BEFORE the horse gets out.
Maybe a safer reposcan, maybe not a command line program would be OK and that should be a lot less development. Maybe an opportunity for a 3rd party tool, maybe I should shut up and write it myself LOL.

davidmo (BOB member since 2002-09-26)

system · March 12, 2009, 9:55am

- yeah, the tools never quite do what we want them to do.

I can kick myself as I finally cottoned on to the fact that I have these *.wid documents in the File Store without CMS entries, but that I have Web Intelligent Rich Client to open them with, and then repost them into the CMS. You just have to rename them away from that 'orrible unreadable data string name, and some have a few strange lost data providers, but something is better than nothing.

And Yeah - a few scripts would come in handy - and it surely cannot be that difficult to regenerate CMS entries. I think the issue lies in trying to decipher the encrypted data in the actual document.
A scheduled BIAR and File Store backup script would also be handy lol

… let me know how it goes if you ever get some idle time and the scripting itch

MikeD (BOB member since 2002-06-18)

system · July 27, 2009, 2:21pm

Well, to be confirmed, but I just witnessed a strange (and quite dangerous) behavior…

From the RDT admin guide, the -repair option set to “false” explicitly denies the application to repair inconsistencies… well, it sure did all repairs to my CMS !

It seems that one has to NOT use this option at all to avoid repairing…

It did not broke anything and I was doing it on test environment, but still :?

popa_chubby (BOB member since 2009-07-14)

system · March 12, 2010, 6:07pm

I messed up. in my haste of copy/paste

when setting up output dir varialbes… I pointed output dir to

C:\Filestore\Input

This has been in place - for a couple of months

my plan to correct
copy The entire content of C:\filestore\input to C:\filestore\output
Then correct output vaiable
Then use repository diagnostic tool to correct and cleanup

When I ran the RDT it says it completed ok, but my concern is that it did not clean up enough… I say this because it only repaird a couple hundred of items, and the disk size is basically the same size it was before.

the orig file store was 200 gig. I copied that to output – my “new” filestore is now 400 gig… I was expecting the filestore to shrink back to 200 gig.

I have opened a case with support… They feel this maybe a bug ???

Any thoughts

Bryan

bthomps01 (BOB member since 2007-01-09)

system · July 18, 2011, 11:03pm

Great work guys it was really helpful

Poonam (BOB member since 2009-12-10)

system · August 15, 2011, 11:43pm

For what it’s worth, the following commands worked for me. I have not yet tested a repair, but the syntax may help someone get going with an Oracle CMS database.

If you notice the print out from just running reposcan.exe, it will say the connect parameter for Oracle is “oracledatabasesubsytem”. This is incorrect. It should be oracledatabasesubsystem.

Also, as someone said above, the outputdir is mandatory (though the user guide says optional).

Underscores are fine in the Oracle username and password provided the connect parameter is in quotes.

One last note, none of the directory specifications can end with a slash…

Minimal command:

reposcan.exe -dbdriver oracledatabasesubsystem -connect "UID=<userid>;PWD=<password>;DSN=<Oracle sid>" -inputfrsdir "D:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Input" -outputfrsdir "D:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Output" -outputdir "c:\reposcan logs" -repair false

Command with more options:

"D:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\reposcan.exe" -dbdriver oracledatabasesubsystem -connect "UID=<userid>;PWD=<password>;DSN=<Oracle sid>" -inputfrsdir "D:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Input" -outputfrsdir "D:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\FileStore\Output" -count 0 -outputdir "c:\reposcan logs" -scanfrs true -scancms true -repair false

Jason Gardieff (BOB member since 2009-08-07)

system · December 8, 2011, 6:40pm

Thanks to everyone for so much info on this topic. I found the documentation in the manual titled “T-BOEXIV3-4251_Administrative_Tools_and_Tasks_Activity_Guide.pdf”

asnair (BOB member since 2005-08-02)