Front end connection issues

[Former Member]

Hi,

We have just gone live with 2004s and noticing that users are continually being thrown out of the analyser and query designer with the generic 'critical error' message.

Looking at the system log I can see a number of entries with the following:

<b>Communication error CPIC return code 020, SAP return code 223</b>

Has anyone seen this before? If so how did you fix it?

any help appreciated,

Michael

[Former Member]

Stefan - did you get any success with this one?

[Former Member]

Hi Miahcael.

I've raised an OSS now and are waiting for SAP to answer. Will keep this thread updated.

BR

Stefan

[Former Member]

I had the same problems in my computer, but in other computers works fine. the issue is related with problems in excel. Currently we have been experiencing problems only in Excel 2007. In Excel 2003 the problem disappeared.

The only way that solve our problems was to update all the patches for office 2003. Install all the recommendations given in the Bloq "SAP GUI BW 7.1 INSTALLATION" in SDN page. it's contains the 22 steps to validate and update all the microsoft framework (that's where the problem is... is Microsoft). Once we apply all these "recommendations" almost all computers works more stable. In my laptop with a persistent issue I had to format and reinstall everything and now it works fine...

Regards.

Ebert

[Former Member]

I just get the link to check all the patches and excel's config. related:

<a href="https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4087">https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4087</a>

Regards.

Ebert

[Former Member]

Hi Stefan

Did you ever get a response from SAP on this?

We are experiencing excactly the same problem on SP13.

I ran the BEx check tool as specified in the blog and got a single red.

sapbex.xls 3500.9.044 3500.11.051

But this is for the 3.5 version, so it shouldn't really pose a problem. However, we will patch it ASAP and try again of course.

Br

Karsten

[Former Member]

Hi Michael.

I am having exactly the same problem after the upgrade to 2004s. Did you find any solution?

BR

Stefan

[Former Member]

Stefan - unfortunately not. I have now left this particularly project so was unable to keep the pressure on this issue.

Your best option would be to raise this direct with SAP. The problem however is that I imagine that this could be caused by a number of issues and it will be difficult to narrow down.

What patch level are you on? I am now working on SP12 and Bex seems a lot more stable.

[Former Member]

Hi Michael and thank you for your prompt answer!

The system is on SP12 and the front end BI tools SP13 so I don't think this is causing the problems. It is just weird that I'm having EXACTLY the same issues as you mention in your first post. I wonder what is causing them, but I will have to find a solution very soon as this is happening on the production system! I might have to raise an OSS as you say. Thanks.

BR

Stefan

[Former Member]

Hi Michael,

Take a look at this OSS note 63347 and it might help you.

Bye...

[Former Member]

Thanks - have searched the notes and there are a lot of options to look at. The problem with network related issues is that they can be caused by a number of different factors depending on how the network has been setup.

I am interested in seeing what people actually did to fix this if they had a similar problem.

thanks

Mike

[Former Member]

You may want to start with these

When you have problems with logging on to a BW system using a BW front-end application, first check whether the following logons are working properly.

1. Logon to BW back end with SAP GUI

2. Logon with srfctest.exe (see below)

3. Logon with BEx Browser

4. Logon with BEx Analyzer (via start menu)

5. Logon with BEx Analyzer (via SAP GUI with transaction RRMX)

This is important in order to determine whether this is a general or specific problem

For details check below-

Note 452443 - Problems logging on to BW systems

Most of the network related issues are solved by taking Basis help and support,they can trouble shoot well with their check list.

Hope it Helps

Chetan

@CP..

[Former Member]

It will be a good idea to check the front end version and the patch level.

Ravi Thothadri