Error when execute a query BW in WEBI

[Former Member]

Hi Gurus,

I need your help:

Status:

SAP_ABA 700

SAP_BASIS 700

PI_BASIS 2005_1_700

SAP_BW 700

BI_CONT 703

SAP GUI 7.10 SP 7

I run a 3.5 query with bex and all its ok.

But when i want run the same query in BOE Web Intelligence Rich Client I have an error

In WEBI: error : WIS 10901 for MDX QUERY

in BW TR: SM21 : Communication error, CPIC return code 020, SAP return code 456.

thxxhead 7415 020456 ThRecei CPIC-Er

If I just put one masterdata, the query return the list of this MD.

But when i put 2 MD or one indicators, i have error.

Thanks for help.

[Former Member · Accepted solution]

Hello Ingo,

Our setup:

- XI 3.0 on top of SAP BI 7(both Windows 2003 server)

- Creating the SAP OLAP universe works (on top of BW Query)

Note though: when creating the connection for the universe, we only have the choice of "3.x" (not 7). This does not seem to be an issue since we see both InfoCubes and BEx Queries.

We've tested with the different flavours of WebI. We get following behaviour:

- WebI rich client: "The MDX-query <MDX syntax> See RFC trace file or SAP system log for more details. (WIS 10901)" - same error as occurs in several posts of this thread. We checked the log and ended up with a reference to Profile parameter - gw/cpic_timeout: Max waiting time to establish connections. Before this error, we did get a pop-up window with prompts to be filled in for the query. We filled in the required prompts (based on a list of values - which worked fine) and left the optional empty.

- WebI "Java flavour" (I believe it's indicated as advanced): An error occurred while trying to load the provider for transport sap. Failed to load library mda_sap. System error message: .(WIS 10901)" If we followed up on this, we ended up with The BusinessObjects XI Integration Kit for SAP Solutions is not installed (1206970) We did a server install on the server and a custom install (with all options) on the Desktop we're running the web browser / rich client from.

- WebI "simple": we just got a pop up window indicating the report was running, but nothing seemed to be happening (no process visible in BW). In the end we just closed the browser and tried the above.

We would like to rule out a missing step in our installation. With the above, does it sound like we're missing something there?

Might the registry key be applicable to our situation?

We're gonna check out the suggestion of Alexis and try a simple BW query.

Thanks,

Raf

[IngoH · Accepted solution]

Hi,

so to eliminate the step here : you did install the SAP Integration Kit and its not an evaluation key that has expired ?

- Try a simple BI Query and build a new Web Intelligence report on top (java, dhtml)

- did you check the MDX Parser destination in transaction SM59 ?

thanks

ingo

[Former Member · Accepted solution]

Hi Ingo, hi Adil

I'm using the following characteristics in my query:

as rows:

- 0Material_0Matl_Group

- 0Material_0Division

- 0Sales_Dist

- 0Cust_Group

free charasteristics:

- 0Sold_to

- 0Material

- 0Sold_to_0Country

key figures in columns

- Actual

= 0Netval_inv

= 0FISCPER (=0I_FPER; this is the variable)

= 0FISCVARNT (=K4)

- Forecast: similar to Actual

- Budget:

= 'Actual' ** 2 / ('Forecast' * 1.1)

- Actual Abw. Forecast

= 'Actual' % 'Forecast'

The Variable 0I_FPER (which is used in the key figure Actual) can not be seen in the Universe. And there is no default value set for these variable.

Im Using Query Designer 7.10 thats right. I've also build the query based on BW 3.5 with similar characteristics and key figures and a universe based on this query. On calling these universe in webi from infoview. The same error occurs. Webi rich client also doesn't work. The error is also:

Datenbankfehler. Der Datenbankfehlertext lautet: Die MDX-Abfrage SELECT { .[D43SFAXOSGXFGTU9W1F4L45ZN], .[D43SFAXOSGY75G617KUQNJK9F], .[D43SFAXOSGYYU2HSJ4ACPYYJ7], .[D43SFAXOSGZQIOTJUNPYSECSZ] } ON COLUMNS , NON EMPTY .[LEVEL01].MEMBERS ON ROWS FROM konnte nicht ausgeführt werden. Fehler See RFC trace file or SAP system log for more details. (WIS 10901)

Thanks for your help

Claudia

[Former Member · Accepted solution]

Hi Ingo,

In response to your questions:

- "you did install the SAP Integration Kit?": yes, we did a "server" install. The other options are Desktop and Custom

- "its not an evaluation key that has expired ?": No, this is not the case

- "did you check the MDX Parser destination in transaction SM59 ?": Yes, this is working now (SM59 - connection test succesful).

- "Try a simple BI Query and build a new Web Intelligence report on top (java, dhtml)" We did this, results:

WebI Rich Client. This worked fine. Report made, refreshes, can add objects, ...

Web Advanced (JAVA Report panel): we get error - "An error occurred while trying to load the provider for transport sap. Failed to load library mda_sap. System error message: .(WIS 10901)"

We checked if we didn't miss anything with the server installation of the SAP integration kit, this was not the case. When we chose a "repair install", all options where already installed. What we did do, is install the Fix pack2. Reason: there was a reference to mda_sap.dll in the BusinessObjects Enterprise XI 3.0 FixPack 2 notes. Note: refer to new thread: Cluster Definition transport error - BO XI 3.0 FixPack 2 (Server&Client)

- We also tried a more advanced query, with prompted filters and calculations.

WebI Rich Client. same error as before, "The MDX-query <MDX syntax> See RFC trace file or SAP system log for more details. (WIS 10901)"

Web Advanced (JAVA Report panel): same error as before - "An error occurred while trying to load the provider for transport sap. Failed to load library mda_sap. System error message: .(WIS 10901)"

Seems we have the same problem as Claudia + an mda_sap issue. We are running out of options here. Any thoughts on this?

Thanks for your help!

Raf

[Former Member · Accepted solution]

Hi Claudia,

Did you find a solution?

I have the exact same problem, but only on BW7.0, not on BW3.5, and only when using two or more restricted keyfigures in the WEBI report.

When using just one restricted keyfigure, theres no error...

BR,

Andreas

[IngoH · Accepted solution]

HI Andreas,

what exactly is the error message you receive and when ?

Ingo

[Former Member · Accepted solution]

Hi Ingo,

Below a link with a dump of the error.

[http://img232.imagevenue.com/img.php?image=13968_WIS10901_122_598lo.JPG]

I get the error when reporting on BW7.0.

I have created a universe on top of a mega query, eg. a query containing all keys/chars from a cube.

Furthermore I have made some restricted keyfigures, restricted on time and version, eg. monthly & YTD figures, plan and actual etc.

When using ONE of the restricted keyfigres in the WEBI report, I get no error, but when using more than one I get the error.

I have tried to make smaller universes (actually the posted dump is from one of the test universes), just to make sure that I hadn't made any errors etc. Offcause I have checked the BEX query etc.

I still get the error.

I do not get this error when reporting on BW3.5!

The customer I currently are working on a solution for are ugrading their BW to 7.0 right now, so I have created the queries, universes etc. against the 3.5 system - no problem. Now we are connecting to 7.0, and get the error...

Do you have any ideas of what might be causing this error...

BR,

Andreas Madsen

[IngoH · Accepted solution]

Hi Andreas,

having a single universe with everything is for sure not the recommended approach.

Take the MDX and try to execute it in transaction MDXTEST

Ingo

[Former Member · Accepted solution]

Hi Ingo,

I hear what you are saying. The reason for this approach, is to provide full freedom for the report users/builders. The users have requested access to the same data, as when reporting in BEx.

And according to best practice " There is no direct impact on performance when working with OLAP

universes created from large BW Queries. OLAP universe objects not inserted in the Web Intelligence query have no direct impact on the query performance" (Using SAP BW in Universe Designer). Or do you have different experiences...?

I will try what you suggest with MDXTEST. I take that it is a transaction in BW...?

Thanks,

Andreas

[IngoH · Accepted solution]

Hi Andreas,

not sure which Best Practices you referring to but it is not recommended to build a single universe on top of the cube. first of all we clearly recommend to leverage the BI query and second we recommend to build a small set of queries with universe - but not a single one.

yes building a gigantic query can have a performance impact on the SAP BI side already based on all the components that are included in the query.

take a look here:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/008d15dc-f76c-2b10-968a-fafe5a12...

Ingo

[Former Member · Accepted solution]

Hi Ingo,

Thanks for all your input. It really helps.

The document I'm referring to is

http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_sap_olap_universes_en.pdf

Look at page 13.

But I see in your presentation, you actually say the opposite... Interesting stuff.

Thanks,

Andreas

[IngoH · Accepted solution]

Hi,

the background is the amount of components used in a BI query. at one point it can be too much items and even if you only ask for 1 characteristic and 1 keyfigure from a gigantic query that it takes much longer than it should

ingo

[Former Member]

Hello Team:

Is this problem resolved for anyone.

I have the exact scenario. Can someone please list out the solution if at all this has been resolved.

Thank you

Biral

[IngoH]

hi BK,

what is the issue youhaving ? I would suggest you open a new entry with the details from your issue.

ingo

[Former Member]

To Walter Gomez Ferraro

Hi Walter,

from the little I understand from the (Spanish?) error message I believe I saw the same today in German. In my case it was an unsupported function in the query. The function name was QT and this function calculates the percentage of a total (i.e. let's assume in the rows we retrieve product lines and categories and a sales revenue. Then this function lets you calculate the percentage of the total revenue per category and line). With a button in the query designer you can check whether the query is syntactically correct. In our case we got the error message that the result of the query depends on the presentation of the data and therefore this function is not released for OLEDB.

Another unsupported function we found was the TOP function (to retrieve the top 10 suppliers). And I bet there are many more unsupported functions...

Maybe it is worthwile to look for suspicios functions in your query, throw them out, see whether it works and then bring them back in one after the other.

Hope this helps, Martina

[Former Member]

To Walter Gomez Ferraro

Hi Walter,

from the little I understand from the (Spanish?) error message I believe I saw the same today in German. In my case it was an unsupported function in the query. The function name was QT and this function calculates the percentage of a total (i.e. let's assume in the rows we retrieve product lines and categories and a sales revenue. Then this function lets you calculate the percentage of the total revenue per category and line). With a button in the query designer you can check whether the query is syntactically correct. In our case we got the error message that the result of the query depends on the presentation of the data and therefore this function is not released for OLEDB.

Another unsupported function we found was the TOP function (to retrieve the top 10 suppliers). And I bet there are many more unsupported functions...

Maybe it is worthwile to look for suspicios functions in your query, throw them out, see whether it works and then bring them back in one after the other.

Hope this helps, Martina

[IngoH]

Hi Alexi,

any update ?

Ingo

[Former Member]

Hello Ingo, I'm having the same problem with the Integration Kit. When I used the SAP OLAP BAPI in the Universe Designer, I've no problem to see all InfoCubes, and to import one of them. Then, I can export the Universe without problems again, but, when I use the WebI, and want to execute a simple query, the problem appears, with the following error message, and I get no data.

I have also installed the Update that it's availible in the site.

Consulta 1 - PRUEBA SAP

Se produjo un error en la base de datos. El texto de error de la base de datos es: La consulta MDX SELECT { [Measures].[0COST] } ON COLUMNS , NON EMPTY CROSSJOIN( [0BILL_DATE].[LEVEL01].MEMBERS, [0BILL_ITEM].[LEVEL01].MEMBERS ) DIMENSION PROPERTIES MEMBER_NAME ON ROWS FROM [$ZBWBO] no pudo ejecutarse con el error See RFC trace file or SAP system log for more details. (WIS 10901)

Thanks.

Walt

[IngoH]

hi,

please contact me. For further steps I might have to send you a registry key

ingo

[Former Member]

hi,

Sorry, but I'm new in this SAP Forums.

I look at your profile and I didn't found any contact information.

How can I contact you?

Thanks

[IngoH]

it should be there on the business card

ingo

[IngoH]

Hi Alexis,

please contact me so that I can send you a registry file for futher details

thanks

Ingo Hilgefort

[Former Member]

Thanks You,

I send you a message.

PLease, tell me if U don't received mail

Bye.

Edited by: Alexis Dolci on Jul 31, 2008 5:06 PM

[Former Member]

Hello Alexis, has you solve the problem?.

We have the same issue. If the answer it's yes, can you send me the solution.

Thanks.

Walt

[Former Member]

We too have the same problem. Can you please share the solution to fix it.

Thanks,

Spandan.

[IngoH]

Hi Spandan,

could you share the details on your issue and I will then see how we can help ?

the previosu issues where very different so I can't tell without the details if it is the same problem

Ingo

[Former Member]

Hi,

I have the same problem. When I call a BW query in WEBI which uses calculated key data such as " Actual % Forecast " I'll get the following error:

Abfrage 1 - BO_Showcase_PF_Kunde

Datenbankfehler. Der Datenbankfehlertext lautet: Die MDX-Abfrage SELECT { .[D3Z2YBDYX32UE38P6GOGNHUMR], .[D3Y612L6XCO960M7Q7SJGXZ6B], .[D3Z3Q46UM7JFBGAK2UXQ7TX77], .[D3Z3Q46UM7K702MBEEDCA9BGZ] } ON COLUMNS , NON EMPTY .[LEVEL01].MEMBERS ON ROWS FROM konnte nicht ausgeführt werden. Fehler See RFC trace file or SAP system log for more details. (WIS 10901)

The error occurs when I'll create a Webi-report with InfoView or with Webi rich client. When I delete the calculated key "Actual % Forecast" and create a Webi-report based on this simple BW-Query it will work.

Can this error also be fixed with a registry key?

Thanks for help.

Claudia Liebl

[IngoH]

Hi Claudia,

- I assume we talk about XIR3 ?

- Are you able to create Universe ?

- could you check the MDX Parser destination in transaction SM59 if it is ok ?

thanks

Ingo

[Former Member]

Hi Ingo,

our BO is Version XI 3.0. I'm able to create Universe and the connection test ist always ok. The MDX parser destination should be ok, because I can call simple BW queries.

The problem occurs when I'm calling a BW query which has a key figure that is restrict by a variable.

For Exmaple key figure "actual" is restrict by variable "year".

I found out that I can build a bo-query on a universe which is using this bw query from webi rich client. But when I use Webi from InfoSource the error occurs.

Thanks for help.

Claudia

[adil_madid]

Hi,

I believe you are using a "mandatory variable with no default value" created using Query Designer 7.10, is this correct?

I was able to reproduce and got the same error as you, however when using Query Designer 3.X it is fine for me can you try that as a simple test?

In my case the LOVs are not available at Universe level and therefore the error at WEBI level.

Regards,

Adil

[Former Member]

Hi all,

In my case in sm59, MDX PARSER RFC TC/IP doesn't work.

I found oss note 1032461: The MDX parser does not start:

Solution: Implement the current version of librfc32.dll (not librfc32u.dll) on ALL application servers. You can download the current librfc32.dll file from SAP Service Marketplace:

Question:

Application servers: It's my BW serv or my Serv BOE or PC with integration kit sap?

Regards

Alexis

[IngoH]

Hi Claudia,

- do you see all the variables from the BI Query in the Universe as Filters ?

- which characteristics are in the query and which are used by variables ?

thanks

Ingo

[Former Member]

Hi all,

The problem is solved.

It was the dll librfc.dll, with the unicode install of BW we have librfcU.dll (for unicode) but not the librfc.dll, and the mdx parser works with no-unicode dll.

When the librfc.dll was installed on BW-serv, mdx-parser works and my query is ok.

Thanks for help.

Alexis DOLCI

[Former Member]

Claudia,

We found that if you have a calculated key figure you must include whatever is needed for the measure in the bex query output. So I beleive in your case you mentioned the year value.