Solved: Error connecting to SAP BW

Hello, we are experimenting on BO connection to SAP BW using SAP Integration kit. The connection used to work several weeks ago. But now it no longer works, the SAP BW system rejects the BO query with the following message:

"A database error occured. The database error text is: The supplied XML is not valid. [C_TKT_TP].[LEVEL01]. (WIS 10901)"

There is also a supplementary information: the SAP BW system has crashed a week ago and the admin restored the system a prior state. It may or may not be related to the error.

In fact, what I would like to know is: what exactly is the message that BO sends to SAP BW. I have tried to trace the message by adding -trace parameter to the WebIntelligence ProcessingServer service. And I got the a package of logs, but nothing seems to be the real message.

And the error mentions XML, is the message sent by BO to SAP a message of XML for Analysis?

Thanks a lot!

BTW, how do I upload the log files?

SAP Managed Tags:
SAP BusinessObjects Business Intelligence platform

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi,

which version of the BusinessObjects software are you using ? I can then outline the steps to trace more details

Ingo

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I am using BO XIR3.1.

Hi,

use the attached registry file. merge it into the registry, restart the BusinessObjects services and try your workflow again. you should then find logfiles on drive c:\.

would be good to get the traces attached here.

Ingo

Hello, Ingo, could you please re upload the file, I get a file of 0 bytes. Thanks a lot.

upload

Hello, Ingo, I think your zip file must contain a reg file, something like that? It must have been filtered by some antivirus software somewhere. I still got 0 bytes. Could you try to rename the reg to an extension like .aaa and also the zip file to an extension like .bbb so that antivirus can't understand the extension?

https://sapmats-us.sap-ag.de/download/download.cgi?id=SEUT7R06WK4OTP7WD3L83HU6XGSAONJM9BQS9EH7SBSBVY...

Thanks, Ingo, this time it works better. I got a log of the integration interface. In the log , I found the following message:

<DP>

<QUERY>

</QUERYRESULT>

</QUERYCONDITION>

</QUERY>

</DP>

</DPCOMMAND>

</DPCOMMANDS>

I have tried to test it in the mdx test editor. But it told me : "Invalid MDX command with DPCOMMANDS"

Is there somewhere another level of transformation from this XML to another form? Is this XML the right form of XML expected from BO?

hi,

which makes sense because it is not an MDX statement. could you attach the complete trace files here ?

thanks

ingo

I don't seem to be able to upload the file. So I post it here:

Wed Apr 15 09:45:35.311 ThreadID<1404> SAPMODULE : module CreateServer : Retrieve valid license key.

Wed Apr 15 09:45:35.311 ThreadID<1404> SAPMODULE : SAPFactory::createBrowseObject

Wed Apr 15 09:45:35.311 ThreadID<1404> SAPMODULE : SAPFactory::createCube

Wed Apr 15 09:45:35.311 ThreadID<1404> SAPMODULE : SAPConnection::connect

Wed Apr 15 09:45:35.311 ThreadID<1404> SAPMODULE : Authentication model for SAP connectivity is CREDENTIALS

Wed Apr 15 09:45:35.311 ThreadID<1404> SAPMODULE : Authentication model for SAP connectivity is username and password

Wed Apr 15 09:45:35.311 ThreadID<1404> SAPMODULE : Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=10.147.30.186,SYSNR=00,R3NAME=E30,AUTHTYPE=CREDENTIALS,USER="fzhang ",LANG=en,CLIENT=100,CATALOG="$INFOCUBE",CUBE="$MP_ET02",PASSWD=******

Wed Apr 15 09:45:35.327 ThreadID<1404> SAPMODULE : Calling m_pRfcWrapper->RfcOpenEx() ...

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : RfcOpenEx(...) returned 1

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : Call to m_pRfcWrapper->RfcOpenEx() took 5.844 seconds

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : There are currently 1 concurrent connections

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : Connection 1 successful

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : Connection to SAP BW server successful

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : SAPAuthenticationService::~SAPAuthenticationService

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : SAPClient::load_structure

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : Looking for cube $MP_ET02 (catalog $INFOCUBE)

Wed Apr 15 09:45:41.170 ThreadID<1404> SAPMODULE : Calling MDDataProviderBW.GetCubes ...

Wed Apr 15 09:45:53.561 ThreadID<1404> SAPMODULE : RFC function call MDDataProviderBW.GetCubes returned S

Wed Apr 15 09:45:53.561 ThreadID<1404> SAPMODULE : Call to MDDataProviderBW.GetCubes took 12.390 seconds

Wed Apr 15 09:45:53.561 ThreadID<1404> SAPMODULE : Found cube - creating structure ..

Wed Apr 15 09:45:53.561 ThreadID<1404> SAPMODULE : SAPStructure::init

Wed Apr 15 09:45:53.561 ThreadID<1404> SAPMODULE : Cube Information

Catalog $INFOCUBE

Cube $MP_ET02

Description Multiprovider - Eurotunnel 2

Wed Apr 15 09:45:53.561 ThreadID<1404> SAPMODULE : Structure created for cube $MP_ET02

Wed Apr 15 09:45:53.577 ThreadID<1404> SAPMODULE : Reserved Structure $MP_ET02

Wed Apr 15 09:45:53.577 ThreadID<1404> SAPMODULE : SAPConnection::connect

Wed Apr 15 09:45:53.577 ThreadID<1404> SAPMODULE : SAPClient::load_structure

Wed Apr 15 09:45:53.577 ThreadID<1404> SAPMODULE : Looking for cube $MP_ET02 (catalog $INFOCUBE)

Wed Apr 15 09:45:53.577 ThreadID<1404> SAPMODULE : Calling MDDataProviderBW.GetCubes ...

Wed Apr 15 09:45:53.670 ThreadID<1404> SAPMODULE : RFC function call MDDataProviderBW.GetCubes returned S

Wed Apr 15 09:45:53.670 ThreadID<1404> SAPMODULE : Call to MDDataProviderBW.GetCubes took 0.094 seconds

Wed Apr 15 09:45:53.670 ThreadID<1404> SAPMODULE : Found cube - creating structure ..

Wed Apr 15 09:45:53.670 ThreadID<1404> SAPMODULE : SAPStructure::init

Wed Apr 15 09:45:53.686 ThreadID<1404> SAPMODULE : Cube Information

Catalog $INFOCUBE

Cube $MP_ET02

Description Multiprovider - Eurotunnel 2

Wed Apr 15 09:45:53.686 ThreadID<1404> SAPMODULE : Structure created for cube $MP_ET02

Wed Apr 15 09:45:53.686 ThreadID<1404> SAPMODULE : Reserved Structure $MP_ET02

Wed Apr 15 09:45:53.686 ThreadID<1404> SAPMODULE : XML Query :

<DP>

<QUERY>

</QUERYRESULT>

</QUERYCONDITION>

</QUERY>

</DP>

</DPCOMMAND>

</DPCOMMANDS>

Wed Apr 15 09:45:53.686 ThreadID<1404> SAPMODULE : saputils::GetHierarchyByUName

Wed Apr 15 09:45:53.686 ThreadID<1404> SAPMODULE : Calling MDDataProviderBW.GetHierarchies ...

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : RFC function MDDataProviderBW.GetHierarchies return with error code 3

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : RFC function call MDDataProviderBW.GetHierarchies returned with an RFC_ERROR_GROUP of RFC_ERROR_SYSTEM_FAILURE with reason Exception condition "HIERARCHY_NOT_FOUND" raised.

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : RFC function call MDDataProviderBW.GetHierarchies returned

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : SAPConnection::reconnect

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : SAPConnection::disconnect

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Closing connection 1 ...

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Calling m_pRfcWrapper->Close( m_hRfcConnection ) ...

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Call to m_pRfcWrapper->Close( m_hRfcConnection ) took 0.000 seconds

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Connection 1 closed

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : SAPConnection::connect

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Authentication model for SAP connectivity is CREDENTIALS

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Authentication model for SAP connectivity is username and password

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=10.147.30.186,SYSNR=00,R3NAME=E30,AUTHTYPE=CREDENTIALS,USER="fzhang ",LANG=en,CLIENT=100,CATALOG="$INFOCUBE",CUBE="$MP_ET02",PASSWD=******

Wed Apr 15 09:46:32.170 ThreadID<1404> SAPMODULE : Calling m_pRfcWrapper->RfcOpenEx() ...

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : RfcOpenEx(...) returned 2

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : Call to m_pRfcWrapper->RfcOpenEx() took 0.281 seconds

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : There are currently 1 concurrent connections

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : Connection 1 successful

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : Connection to SAP BW server successful

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : SAPAuthenticationService::~SAPAuthenticationService

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : Error getting hierarchies for dimension [C_TKT_TP] (Cube $MP_ET02): Exception condition "HIERARCHY_NOT_FOUND" raised.

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : Call to MDDataProviderBW.GetHierarchies took 38.766 seconds

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : SAPCube::setParameters

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : SAPStructure::get_variables

Wed Apr 15 09:46:32.452 ThreadID<1404> SAPMODULE : Calling MDDataProviderBW.GetVariables ...

Wed Apr 15 09:46:32.655 ThreadID<1404> SAPMODULE : RFC function call MDDataProviderBW.GetVariables returned S

Wed Apr 15 09:46:32.655 ThreadID<1404> SAPMODULE : Call to MDDataProviderBW.GetVariables took 0.203 seconds

Wed Apr 15 09:46:32.655 ThreadID<1404> SAPMODULE : Got 0 variables for cube $MP_ET02

Wed Apr 15 09:46:32.655 ThreadID<1404> COMMONMODULE : The supplied XML is not valid. [C_TKT_TP].[LEVEL01]

Wed Apr 15 09:46:32.670 ThreadID<1404> SAPMODULE : SAPCube::~SAPCube

Wed Apr 15 09:46:32.670 ThreadID<1404> SAPMODULE : Unreserved Structure $MP_ET02

Wed Apr 15 09:46:32.670 ThreadID<1404> SAPMODULE : SAPStructure::~SAPStructure

Wed Apr 15 09:46:32.670 ThreadID<1404> SAPMODULE : SAPClient::~SAPClient

I think I got the answer, there is an exception thrown "HIERARCHY NOT FOUND", so I guess it is on the SAP BW side that the infoprovider got corrupted somehow? But how could I verify on the SAP BW side, I see no anomalies in the Data Warehouseing Workbench.

Edited by: Fei Zhang on Apr 15, 2009 5:12 PM

Hi Fei,

can you put the COMPLETE traces somewhere ? You also have the upload option here for attachments (at the bottom when you reply)

Ingo

Hello, Ingo, I used you send it to send you the log file and here is the link:

[http://www.yousendit.com/download/dVlvUGhmYWI1R1BIRGc9PQ |http://www.yousendit.com/download/dVlvUGhmYWI1R1BIRGc9PQ ]

I have noticed an RFC error in the log:

RFC function MDDataProviderBW.GetHierarchies return with error code 3

I guess it can not get the hierarchy of the InfoProvider.

But on the SAP BW side, I see no anomalies, how can I verify this behaviour on the SAP BW side?

Thanks a lot!

Hi,

it looks like you are using a universe directly on top of the cube. Could you verify if that issue happens when using a BI query with the hierarchy activated.

Clearly you getting errors from the OLAP BAPI interface in the SAP BW system.

Ingo

OK, query solves the problem.

Thank you, Ingo

Hello Ingo,

We are having a similar problem, can you send the file in order for me to generate the log files. I tried downloading the zip file, but does not work.

Thanks in advance.

Dharma.

Hi,

you could create a new entry, provide the details of the issue ?

thanks

Ingo

Hello Ingo,

I have opened a new entry for the issue.

I created a webi report on top of the universe which was built on top of an InfoCube.

When I do a MDX statement it works fine retreiving the data from the cube.

Can you please help me out.

Thanks

Dharma.

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

Error connecting to SAP BW

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: Re Generate Co files and data files

Re: error during install SAP S/4HANA Server 2022

Re: BODS Job Stored Procedure

Re: Query does not work in Procurement Price Speci...

Re: Integrate an external task system to Cloud ALM...