cancel
Showing results for 
Search instead for 
Did you mean: 

Java SDK exception while retreving the BO Report

Former Member
0 Kudos

Hello,

We are facing the below issue while retrieving the BO report:

10:50:38,770 - ERROR - ErrorHandler.resolveException(18) | Error caught:
com.sg.boa.exception.BOAException: Unexpected error retreiving the reports from BO : com.crystaldecisions.sdk.exception.SDKServerException: Internal error.

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:Internal error.

The server supplied the following details: OCA_Abuse exception 10503 at [sisecserver_impl.cpp : 314]  42254 {}
...Invalid handle for proxy


Could you please look into the above issue  and suggest us back what has gone wrong?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Kanistha,

Can you give more insight of your problem.

What is BO Product Version?

What reports are you using(crystal/webi)?

When do you get the error at which line of code?

-Prithvi

Former Member
0 Kudos

Hello Prithvi,

We are using BO R3 - 13.XI3.

Getting the exception while downloading the BO report:

String query = "SELECT SI_ID, SI_NAME, SI_DESCRIPTION, SI_OWNER FROM CI_INFOOBJECTS WHERE SI_KIND='FullClient' AND SI_PARENTID in ("+folderIds+")";

IInfoObjects documents = bOAConnectionManager.getConnection().query(query);

Exception is as below:

 

10:50:38,770 - ERROR - ErrorHandler.resolveException(18) | Error caught:
com.sg.boa.exception.BOAException: Unexpected error retreiving the reports from BO : com.crystaldecisions.sdk.exception.SDKServerException: Internal error.

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:Internal error.

The server supplied the following details: OCA_Abuse exception 10503 at [sisecserver_impl.cpp : 314]  42254 {}
...Invalid handle for proxy


at com.sg.boa.dao.ReportBO11xDAOImpl.getBOReportList(ReportBO11xDAOImpl.java:561)
at caf.opm.sec.tda.util.BOReportUtil.getBOReportNames(BOReportUtil.java:56)
at caf.opm.sec.tda.controller.ReportingController.setListValues(ReportingController.java:158)

The issues comes when we modify some BO report and publish it, then it starts giving the above exception and then when we restart the tomcat server not the BO servere it works again.

Please let me know if you need any further information.

Regards,

Kanistha


Prithviraj Shekhawat wrote:

Hi Kanistha,

Can you give more insight of your problem.

What is BO Product Version?

What reports are you using(crystal/webi)?

When do you get the error at which line of code?

-Prithvi

Former Member
0 Kudos

Hi Kanistha,

ERROR - ErrorHandler.resolveException(18) | Error caught:

com.sg.boa.exception.BOAException: Unexpected error retreiving the reports from BO,

is a custom written exception. Also the error messages contains custom packages.

Also, is the above line mentioned the exact line where you get the exception?

I see you are querying for 'FullClient'(Desktop Intelligence) reports. Are you using Report Engine SDKs to download them?

Is downloading means having the reports exported to a particular format.

What report modifications you do and how do you publish them back to enterprise.

The logs do not give sufficient details to get to the cause of the error. Also it would be apt to provide us with the code which actually gives the exception and catch the exception returned by BusinessObjects instead of custom written exceptions.

If you can provide more details about your workflow, it can benefit us to get to the cause.

Thanks,

Prithvi