Business Intelligence with SAP Business Objects 4.3

Error WIJ 20006 - One or more data sources are unavailable for queries  Environment: BOXI R3.1 SP4  with WebIntelligence The universe connection is working fine. This error came while a user was editing a Webi query. Solution: We resolve the problem by assigning the user to the group with access rights to the universe on which the report pointed. See also related posts: Error DA0005 CONNECTION or SQL SENTENCE ERROR - ORA-12154 BUSINESS OBJECTS ERRORS LIST

Environment: Business Objects XI R 3.1 - Desktop Intelligence/ Rich Client We had this error CONNECTION or SQL SENTENCE ERROR (DA0005) ORA-12154: TNS:could not resolve service name :-12154 just  for one a client in another site of our customer. We checked this  problem by typing  in CMD tnsping Oracle SID  for example: tnsping oracledatabase. The problem was that int the tnsname on the client under the path : C:\app\username\product\11.2.0\client_1\network\admin had not the same Oracle SID. Another  solution  could also be that the tnsping does not respond so the listener could be down. Similar case: On another Desktop Intelligence client with the same issue (error code) the problem was due to a double Oracle installation and a double Business Obects Intallation. Solution: In this case we unified the two different TNSNAMES in only one ! For other error see also: BUSINESS OBJECTS ERRORS LIST

Let see another case of the error: [repo_proxy 13] SessionFacade:openSessionLogon with user info has failed(Transport error: Communication failure.(FWM 00001) (hr=#0x80042a01) related to the error : Cannot access the repository (USR0013) Using Rich Client  (or Desktop Intelligence)  in a Business Objects XI R3.1 with Enterprise authentication on the System NOT USING J2EE system. As I wrote before  SYSTEM:6400(J2EE) means you are using 3 tier Deski which happens through web works fine as there is no firewall in between. while using SYSTEM:6400 we are in case of 2 tier login and your firewall is blocking the connection. In order to solve the problem you need to open some ports in the firewall for detail please read FWM 00001 - openSessionLogon with user info has failed If this operation does not solve the problem you can edit the REGEDIT - Registry Editor  (after making a copy of it in order to recover it in case of problem) then go to: HKEY_LOCAL_MACHINE KE

Before importing an universe in Translation Manager    the Best practise I feel to suggest is to make a local back up of the universe using BO Designer  you need to translate!! In this case  if after exporting the translated universe on CMS you will find the Universe is in some way corrupted you can recover it quicky form  the Designer! Read also related posts: Business Objects Translation Manager Translation Manager Exporting documents How to use Translation Manager Translation Manager Substitution mechanism

[repo_proxy 13] Session Facade::openSessionLogon with user info has failed(Transport error: Communication failure. (FWM 00001) (hr=#0x80042a01) Environment: Business Objects XI R 3.1 Enterprise SP 4 Desktop Intelligence client from extranet site cannot access to the BO Server. We used the right credentials, we checked our firewalls. Our firewall is open for the ports 6400 and 8080 (as default). The log shows that the network packages are sent between the client and server. The request is reaching the CMS as 6400 (BO server port) is enable but the Clients are not getting the response back as the request port is not enabled on the Firewall. On CMS there are two ports: one is Name Server port the other is the Request Port , by default the name server port is assigned the port 6400 and the request will reach the CMS when the name server is enabled on the firewall. The problem is that Web/client application cannot communicate as the Request port is unaware and the f

Environment BO XI R 3.1 SP 4 On logging on Desktop Intelligence,  the following error occurs:  SessionFacade::openSessionLogon with user info has failed(Transport error: Communication failure.(FWM 00001) Cause The client could not talk to the Server . This is the main  reason.  1)SYSTEM:6400(J2EE) means you are using 3 tier Desktop Intelligence which happens through web works fine as there is no firewall in between.  2)SYSTEM:6400 is 2 tier login and your firewall is blocking the connection.  The first one is a key that gets created when you modify or create a new Desktop Intelligence document from Infoview, that is 3-tier. The second one is you entering manually the information for 2-tier. Others Possible causes of the problem are: The server may be down. There may have been a network communication problem. The request my have timed out. Could be also a database connectivity issue between the CMS server and the Repository database. In order to

How to add a link in a dashboard  in order to open a document in SAP BI 4 platform First of all I wish you all HAPPY NEW YEAR! Let see how to insert a link to a document  that has been already published on SAP Business Objects 4 platform. Go to Web Connectivity menu in SAP Dashboards  as shown in the following image Select the  URL Button and drag an drop it  in the chosen position on the canvass Then select button Property tab  assign a name to button label  and then insert the appropriate URL in the following format http://BI4Servername:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=..... In this way, after publishing the dashboard on BILaunchpad  when you will click on the Open Workspace url Button  the related document will be opened: Please read related post: SAP BO 4.0 Open Document