LO 26603 - unique session logon error

[Former Member]

Hello community,

I have an error that happens when I want to preview the dashboard (or when I execute the flash exported)

Scenario:

- BOBJ Platform SP4 Patch 9

- Dashboard Design SP4 Patch 9

- Crystal Reports 2011 Patch 9

- Live Office SP4 Patch 9

(aligned with the SP and Patch existing in the server of BO).

Other issues

· BI Server          http://<hostname>:8080

· Session URL          http://<hostname>:8080/dswsbobje/services/session

· The data flow is: ECP -> Crystal Report -> Live office -> Dashboard Design.

· We don't have BW.

I'm implementing the Inventory Dashboard of the SAP Best Practices for Business Intelligence V1.40 which get the data from four crystal reports

1) All Plant in client.rpt. (1 live office object in dashboard)

2) All Matrial Group.rpt. (1 live office object in dashboard)

3) All Inventory KPI Data.rpt. (2 live office objects in dashboard)

4) Turnover.rpt (4 live office objects in dashboard)

-- Tests --

I have isolated the error and it happens when I insert the report called Turnover.

There's four live office objects in my dashboard which uses the same crystal report. When I try to preview it, dashboard throws 3 errors.

Error description:

----------

Cannot access to external data

Error de inicio de sesión único: "{C5C1D2EA-7D79-4A10-AFF2-F5D54BE585A8}.rpt

Error de inicio de sesión único: (LO 26603)

Cannot access to external data

Error de inicio de sesión único: ''{C5C1D2EA-7D79-4A10-AFF2-F5D54BE585A8}.rpt

Error de inicio de sesión único: '' (LO 26603)

Cannot access to external data

Error de inicio de sesión único: ''{A3D19BB0-ABE2-4678-A6FC-8A5B3AF791EE}.rpt

Error de inicio de sesión único: '' (LO 26603)

-----------

A translation could be: "unique session logon error"  {a code that I actually don't know what it means. Isn't the CUID} and the LO error code, 26603. I've attached some screen shoots of them.

In the dashboard could find 4 live office objects more which works well if a remove the Turnover objects

If I refresh all the objects, the data is retrieved ok and displayed in the excel sheet properly.

But there is one difference in the connection defined for all the Turnover live office objects. The refresh configuration is defined as "on demand". (the other are defined as "last instance").

The ECP source of the Turnover is a Stored Procedure. In the Crystal reports exists four parameter fields to pass to the procedure (Plant, Language, Material Group and a Flag).

I have already read all of the posts where the LO 26603 is asked/replied and no one fix my proble, i.e: Setting up the database credentials in the report properties in the CMC or change the "on demand" refresh option to "last instance".

I suppose that it's a problem with the consecutive login connections to the database, but when i run the preview mode, first I'm asked for the BO credentials and then, when it want's to refresh the Turnover connections, asked for the DDBB credentials. After that, when the dashboard starts to display the components the three errors appears.

Is there anyone who has some idea that what is happening to me?

Thank you for reading,

Néstor.

[sapanesh_agnihotri · Accepted solution]

HI Have you checked the below

1782484 - Unable to refresh published Live Office document based on a report using single sign-on for database

Thanks,

Sapanesh

[Former Member · Accepted solution]

Hello Sappanesh,

Thank you for the SAP Note but it doesn't resolve the problem.

We have to pass the issue to the Level2 and open a message with SAP.

Regards,

[Former Member]

Hi Nestor,

Good Noon,

    There is a known issue  for live office database logon credentials in BOBJ Platform SP4 Patch 9.

    Live Office-enabled SWF file using a Crystal Report that requires database logon credentials will fail to refresh. This occurs because the SWF file does not prompt the user for database logon credentials, even

if required by the report.

    To ensure the data is refreshed properly, the SWF file and the Crystal Report must be saved to the same BusinessObjects Enterprise system. A BusinessObjects Enterprise administrator must then enter the report's database logon information in the Central Management Console so that credentials are not required when the report is refreshed.

Thank You,

Haresh

[Former Member]

Hello Haresh,

Thank you for your reply.

We did it every time its needed (set up the bbdd credentials of the report in the CMC) but it stills crashing.

Thanks for all,