Reports are not working in BI 4.1

[Former Member]

Hi,

Hi,

Environment: BI 4.1, SAP BW and Oracle 11g.

Users are imported from BW.

I am facing issue in 4.1 sp2 After migrating 4.0 to 4.1.

All UNV reports are working fine except reports on Oracle
Database in BI launch Pad, those reports are working fine in Rich client.

I have installed Both 32 and 64 bit Oracle drivers in 4.1 servers.

Thanks in Advance

[Former Member]

This is a known and common issue and also we have encountered this after moving to 4.1 SP2..

This is actually related to the DSL bridge service  not available to use or not running which will only affect UNX based report and BICS report but UNV and rich client would work as they do not use the DSL services...The actual reason of this is there are some JAR files which are needed for this service and got corrupted while installing

You or your admin has two options for this  ( If you already tried creating a new APS dedicated for DSL Bridge and it does not work)

1.If you have a stand alone installation and not a cluster check the installation log file and repair the installation

2.This is how we fixed.. If you are in a clustered environment then if the one of the App server is running fine for the DSL bridge server .. We copied the JAR files relevant for the DSL bridge from the APP server which works fine for the DSL bridge server and put those files on the server not working.. once this is applied we needed to restart the server and create the APS with DSL bridge service which started and worked fine..

[Former Member]

hi Mishra. thanks for the advise after doing above work around I am facing new issue . Webi error on Unx Universes only('getSessionInfosEX')API We are on BO4.1 SP2, I am getting error when I try to create webi report on unx universes only. I can create report on Unv universes without any error. Here is the error I am getting ('An internal error occured while calling 'getSessionInfoEX') API. I have created unx on Oracle 11g and I can run the query in IDT and can see data without any error. Not sure what could be the issue, any ideas? thanks in advance

[arijit_das]

Try the soln provided in the note 1764625 - csEX error shows up when refreshing webi reports after applying SP04 Patch 3