BusinessObjects Board

Help me in using WID Scanner?

sdk development
#2

For information on grep:

You don’t need to install this on a server. You can run from a client as well, as long as the client can access the filestore on the server (UNC-path) (and desktopintelligence needs to be installed)

jbo :monaco: (BOB member since 2005-07-31)

#3

Hi Jbo,

Thanks for your reply.

I have download this “filegrep-2.5.1a-2-setup.exe” from the site www.sourceforge.net and install it in my server, but still I get nothing and a message apper telling me “File not found”, so can you explain the steps for me ?

Thanks again

DataAdmin :bahrain: (BOB member since 2006-08-23)

#4

Probably you didn’t set the path pointing to your filestore properly… (or one of the other paths)

jbo :monaco: (BOB member since 2005-07-31)

#5

Hi Jbo,

I have checked every thing and they are all correct , but I think the problem is with grep function, there is a note that i should add it to my “PATH environment” so could you tel me how, please. :oops:

DataAdmin :bahrain: (BOB member since 2006-08-23)

#6

Go to control panel\system\advanced\environment variables\ here you can edit the PATH-variable. Add the folder were the grep is installed to the variable.

However it should also work without the grep installed. In that case objects belonging to a wid-file are not retrieved.

hope this helps.

jbo :monaco: (BOB member since 2005-07-31)

#7

Hi Jbo,

It is worked Thanks, it is so helpful tool, I will go through the code to see wither I can customize it.

Thanks again :smiley:

DataAdmin :bahrain: (BOB member since 2006-08-23)

#8

Hi again,
Do I bother you :roll_eyes: ?

I have one more thing about the Scanner :?:

what do you mean by the last check box “Exclude Instance-object-files”

because when i select only the first checkbox “Write to flatfile” it shows 252 documents but when it 175 document it shows an error message, it same for the second checkbox “Write to Database”, but when I select the third checkbox with one of the above boxs it shows 212 documents and it read them all without any error.

So is there any limitation in the tool?
and what do the third cheeckbox mean?

Thanks :slight_smile:

DataAdmin :bahrain: (BOB member since 2006-08-23)

#9

Dear Jbo,

I have do some changes to my Language setting and number setting and it work correctly, may be because i have some Arabic title and numbers.

OK, now I have another Questions :wink:

What do you mean by Universe_shortname in wid_document_universes Table? because I found a lot of universes that have a diffrent universe_name than the universe_shortname? :crazy_face:

Note: most of then are done by saveing a universe with a diffrent name and then I change the universe name in “parameters” in designer.

Thanks

DataAdmin :bahrain: (BOB member since 2006-08-23)

#10

Nice to hear everything worked out fine,

Shortname means the name the universe is saved with (without the extension unv)
Name means the name that is stored in the Universe Parameters

jbo :monaco: (BOB member since 2005-07-31)

#11

Halooo Jbo,

about the short name, I have a univers called worker, I open it and save it as employer and changed the univers name in the parameter,
so now i get this result

name | shortname

worker worker
employer worker

so the short name not changed here??? do you know why? :?

this cause a problem when i check the WID Scanner report because all the report shown that they related to worker in “Universe_used” field.

I check the code and I found where the location that i can chenged the value to be SI_name instead of SI_shortname. but do you have a solution for this without changeing the code? 8)

Thanks

DataAdmin :bahrain: (BOB member since 2006-08-23)

#12

I don’t have a clue :roll_eyes: so I should say change the code.

Maybe you can check with BO query builder where it goes wrong:

http:///businessobjects/enterprise115/WebTools/websamples/query/ie.aspx (URL for IIS installation)

You can get the universe info from the CMS with following query:

select * from ci_appobjects where SI_KIND = ‘Universe’

The field SI_WEBI gives you all the SI_IDs of webi documents using that universe

Get webi document info by using:

select * from ci_infoobjects where SI_ID in (1696,1697,…) :wink:

jbo :monaco: (BOB member since 2005-07-31)

Number of Reports from a Particular Universe
#13

Thanks Jbo
The tool is so helpful and through it i descover some errors in my repository

thank again :lol:

DataAdmin :bahrain: (BOB member since 2006-08-23)

WID Scanner
#14

Hi Jbo,
I am trying to identify all reports that use specific objects as part of an upgrade to BOXI. :smiley:

Would you be able to say if you’re wid scanner would work on v6 .wid reports :?: If it does it would save me loads of time. :lol:

Did you ever manage to include the class that the object belongs to :?:

Thanks,
Robin.

RMCPHAIL :uk: (BOB member since 2007-11-01)

#15

When I run this report, I get Transport error: Communication Failure message. I installed Grep 2.5.1a and modified Path variable.

BOisBest :india: (BOB member since 2004-04-05)

#16

I too am receiving the Transport Error : Communication Failure message when trying to use this utility. Any advice as to why this is happening?

The utility will run successfully against my local BOE install, but will not run against other server environments thus far (even when running it from the server itself).

Has anyone found a solution for this?

Thanks

crystal01 :us: (BOB member since 2006-08-30)

#17

For those of you seeing the “Transport Error - Communication Failure” when you run the tool, check your event log. I originally though this was a network communication error, but that doesn’t seem to be the case.

When I run the WID-Scanner against medium to large size environments, I receive this error, and noticed that the CMS would re-start itself shortly after as well. A look at the event log shows the following:

CMS is unstable and will shut down immediately. Reason: Database access error. Reason ORA-01795: maximum number of expressions in a list is 1000

I see in the WID-Scanner VB that the query used to retrieve the WID objects has a “top 1000000” in the select clause, so this seems to be a different issue…

Anyone have an idea on how to resolve this?

Thanks!

crystal01 :us: (BOB member since 2006-08-30)

#18

Regarding my previous post on the Maximum Expressions In List… error, there is a 1.2 version of the utility which allows for retreival of the WID documents in small batches (# input by user). This will work around the In List DB errors that were received.

Additionally, I found I would occasionally receive “File Not Found” errors that would stop the utility. These are a result of cases where the CMS still has a FRS location pointer, but the physical WID document no longer exists on the filestore. These can be avoided by adjusting the code to check for existance of the file before trying to pull the file size (and grepping for objects).

On a separate issue - I noticed through testing that for certain WID files, object names are not retrieved. Looking closer at the WID files that objects are not retreived for, I see that these WID documents do not contain the “” tag that is parsed for by this utility. I believe this is only the case for a portion of instances, not the report objects themselves…

Does anyone know why there is a difference in the internal format of the WID file? I haven’t yet been able to find a pattern (old WIDs created on a previous SP, instances vs. non-instances, etc). Any input appreciated!

crystal01 :us: (BOB member since 2006-08-30)

#19

Those wid-files where you cannot retrieve objects from are wid files created in an earlier version of webi (before XIR2). This happens when those wid files are migrated to XIr2.

jbo :monaco: (BOB member since 2005-07-31)

#20

That’s what I suspected - thanks…

crystal01 :us: (BOB member since 2006-08-30)

#21

Dear All,

I am running my repository on Windows XP, then what would be the solution to extract only WID docs.

Kindly help me.,

rajraghaven (BOB member since 2007-06-11)