first time using java sdk.

sdk development
1

I have a requirement to generate a list of all crystal reports naming their db credential and user id.

scope is (have all crystal reports name and where they are pointing -db- using what user name in a table like view.)

Since query builder is not specific to do this (i tried many ways) but ended up with a solution only available through java sdk.

following a blog “Getting started with BusinessObjects Java SDK | bukhantsov.org”

but i got these error… i guess since the blog is specific to webi report and i am looking for information pertaining to crystal…i got the following errors.

Connecting…

Exception in thread “main” com.businessobjects.rebean.wi.ServerException: An internal error occured while calling ‘openDocument’ API. (Error: ERR_WIS_30270)

at com.businessobjects.rebean.wi.occa.OccaDocumentComAdapter.checkOpenDocError(Unknown Source)

at com.businessobjects.rebean.wi.occa.OccaDocumentComAdapter.openDocument(Unknown Source)

at com.businessobjects.rebean.occa.OccaReportEngineComAdapter.openDocument(Unknown Source)

at com.businessobjects.rebean.wi.ReportEngineImpl.openDocument(Unknown Source)

at com.businessobjects.rebean.wi.occa.WebiReportEngine.openDocument(Unknown Source)

at SandBoxinfoPkg.SandBoxClass.main(SandBoxClass.java:57)

<

I have copied all the jar files, and tried every other possible way. but to no avail.

can some one help on this regard.

what these error are referring to, and what would satisfy it.

environment- BO 4.0 db is oracle 11g, have a enterprise id and windows ad id also.

all of the reports are crystal reports, and 95% based on stored procedure.

Thanks.

siddiqi147 :us: (BOB member since 2011-01-13)

2

22 people read it- but no reply- awesome.

siddiqi147 :us: (BOB member since 2011-01-13)

3

I haven’t done this in 4.0 yet, however in XI 3.1 this would require using the RAS server.

Following the blog you mention, you’ll need to change the query to extract the Crystal Report documents only, using something similar to


Select top 20000 SI_ID, SI_CUID, SI_NAME, si_processinfo.si_logon_info From CI_INFOOBJECTS Where SI_KIND = 'CrystalReport'

Then you need to loop through each report from the returned query and get the properties for each logon (if multiple) and use the properities of SI_SERVER and SI_CUSTOM_USER to get the database name and user. Now if you are using an ODBC connection the server name will be the ODBC connection name so if you need the actual server name you’ll need to get that another way.

And finally output this into a csv file or something.

bdgeise (BOB member since 2011-12-15)