How to test Report diagnostic tool in 4.0

[Former Member]

Hi Experts

Can any one share your experience in RDT 4.0 , i read all the documents but havent explained in clear , I dont know how to test the RDT in BO 4.0

Can any one please help me explaining step wise

Appreciate ur help

[Former Member]

Hi Sunil,

had you ever solved the problem with rdt an unknown exception error ?

I'm facing the same problem and it looks like a real nightmare for me.

Regards,

Hans-Peter

[Former Member]

there seems to be some issue with -scancms switch.

Removing it resolved the internal error for us.

[Former Member]

I was having the same issue on Windows and I was able to run it when opening the CMD prompt window as Administrator.

[DayaJha]

Hi Sunil,

Report Diagnostic Tools:

Business Intelligence Platform Repository Diagnostic Tool User Guide:

Links:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_bip_repository_diagnostic_tool_en.p...

BusinessObjects Administration – Repository Diagnostic Tool (By Hexaware):

Links:

http://blogs.hexaware.com/business-objects-boogle/businessobjects-administration-%E2%80%93-repositor...

Note:

Before applyig Report Diagnostic tools take the FRS (File Repository & BIAR/Database )backup of SAP Business Objects Application

Hope this will help you as well.

Thanks,

Daya

[Former Member]

hi vivek.daya

Thanks for your quick reply , i seen this blog it looks very simple but on applying makes a difference . I tried it but i am getting internal error :an unknown exception occurred  even i shut down the SIA server but still i am getting the same error

Here my code i given in cmd under win 64 x64 directory

reposcan.exe -dbdriver sqlserverdatabasesubsystem -connect “UID=boeuser;PWD=XXXX;DSN=BOE140;HOSTNAME=server;PORT=1433 ” -dbkey "XXXX"  -inputfrsdir“C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore\Input” -outputfrsdir “C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI4.0\FileStore\Output” -outputdir "C:\Users\Administrator\Desktop\New folder" -scanfrs true -scancms true

can you please help me on this issue

Appreciate ur help

Regards

sunil

[former_member188911]

moved to the BI Platform , because it is repository diagnostic tool, not for reports...

thanks

Simone Caneparo

SCN Discussions Moderator

[former_member182521]

Sunil,

Try like this

reposcan.exe

-dbdriver sqlserverdatabasesubsystem

-connect “UID=XXX;PWD= XXX;DSN=XXX”

-repair true

-inputfrsdir "IFRS location"

-outputfrsdir  "OFRS location"

-outputdir “E:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\reposcan”

-scanfrs true

-scancms true

-repair false

Kindly check the below in your syntax

1. Port 1433 is omitted if the SQl Server used its default

2. have you created appropriate DSN.

2. Does you IFRS & OFRS are mapped somewhere other that the default installation

Regards,

Mani

[Former Member]

Hi

Thanks for quick reply

when i give the commands in new line it gives error  like batch file could not be found so i created command as of above mentioned .

1)As the DSN port for tcp/ip is 1433 should i give the CMS db port 6400?

2)At fitst i pointed to default DSN CMS db but its not connected ,so i created a new DSN in obdc

3)IFRS and OFRS are in same default location ,

Finally at -scancms it is initializing but it throws an exception like internal error

didnt able to create XML file , i am in BO Xi 4.0 sp4 (no patches )

Any one help me on this

BO Xi 3.1 is far better than 4.0 i think

Regards

sunil

[former_member202789]

Hi,

Is the Authentication mode used for CMS DB connection SQL Authentication or Windows Authentication.

Is the command prompt running with the same account as your SIA in BI 4.0.

In task manager check the user with which sia.exe and cmd.exe is running.

Regards,

Animesh Kumar

[Former Member]

Hi Sunil,

Did you have a look to this wiki article? It's simple and you will get a good understanding of RDT

http://wiki.sdn.sap.com/wiki/display/BOBJ/How+to+use+Repository+Diagnostic+Tool

Basically we use this tool to check any discrepancies with FRS and CMS DB.

If your DB and FRS are consistent, you can take a *good* back-up of DB and documents from file system

Thanks,

Vivek