Portal to BW connection issue

[former_member196664]

Hi All,

Recently I performed stack upgrade in BW and Portal. Users are getting intermittent errors. Please help to resolve the issue.

Thanks,

Kavitha Rajan.

[hemanth2 · Accepted solution]

Hi Kavitha,

Hope you are doing good.

I would like to mention the below points for you to keep in mind when connection occurs from BI JAVA to ABAP:

1. Always use the CTC Template for BI Java for configuration.

2. To ensure a smooth configuration process, make sure that you have deployed the very latest patch from SAP Service Marketplace at

http://service.sap.com/swdc for CTC Template for BI Java.

3. Read note 983156 ('BI configuration w. Template Installer') and make sure the necessary prerequisites are given on the ABAP side.

4. After running the CTC Template for BI Java, run SAP NetWeaver BI Diagnostics & Support Desk Tool as described in note 937697 to verify your installation. In the "Advanced mode" of the tool, go

to the "Configuration checks" tab and check for potential red traffic lights. To resolve the issues shown there, check the "Remedy" column and follow the instructions given there.

5. The overall process is described in more detail in note 917950 ('SAP NetWeaver 2004s: Setting up BEx Web'). Make sure to go through the note and also have a look at the document    WDEBU7_Setting_up_BEx_Web.zip attached to that note, showing the overall process in a set of slides with screenshots.

Let me know if this helps; else we will check the logs.

____________
Kind Regards,
Hemanth
SAP AGS
 

[former_member196664 · Accepted solution]

Hemanth,

Your answer is very helpful. I am working as per you suggested. I will change to correct answer, if it worked out. Thank you so much for taking time and for thehelp.

Regards,

Kavitha Rajan.

[hemanth2 · Accepted solution]

Great Kavitha.

If  the issue persists, even after this, the BI diagnostics tool along with the web diag tool (as outlined in note 1045019- "Web diagtool for collecting traces" with "Security" -> "All" ) will give you more info.
Also make sure that ALL BI SCAs are deployed; at times this is the issue.

I am not sure of your release; hence I will list everything:

What is BI Java 7.30?

From a technical perspective, BI Java 7.30 consists of the following J2EE Software Component Archives (SCAs):

    o  BI-BASE-S.SCA - BI BASE SERVICES

    o  BI-BASE-E.SCA - BI BASE EXPORT SERVICES

    o  BI-BASE-B.SCA - BI BASE FOUNDATION

    o  BIWEBAPP.SCA - BI WEB APPLICATIONS

    o  BI-IBC.SCA - BI INFORM. BROADCASTING

------------

-  UTs of SAP NetWeaver 7.00 (2004s):

   Components of BI (UT_NAME =  BI):

FILE NAME         DESCRIPTION

BIIBC**_*.SCA     BI INFORM. BROADCASTING 7.00

BIWEBAPP**_*.SCA  BI WEB APPLICATIONS 7.00 (SP <current

version>)

BIBASES**_*.SCA   BI BASE SERVICES 7.00 (SP <current version>)

BIREPPLAN**_*.SCA BI REPORTING AND PLANNING 7.00

BIWDALV**_*.SCA   BI WEBDYNPRO ALV 7.00

VCKITBI**_*.SCA   VCKITBI

You must install all components from BI-Java. If SOME of these entries DO NOT EXIST, the usage type BI Java is not completely installed.

regards,
hemanth
SAP AGS Ireland

[former_member196664 · Accepted solution]

Deleting all tmp tables along with hierarchy resolved issue.

Thanks,

Kavitha Rajan.

[hemanth2 · Accepted solution]

Great news Kavitha.
I would still state that you make sure that all the SCAs have been deployed so that we can rule out any consistency issues at a later point of time .

Regards,
hemanth

[Former Member · Accepted solution]

Hi Hemanth,

Yes, all SCAs are deployed correctly.

Thanks,

Kavitha Rajan.

[RolandKramer]

Please have a look to this Blog - BI-JAVA, BEx Web and EP: the real connection

Best Regards Roland