Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Xcelsius error 2032 when using stored procedure as a datasource

Hello!

We have a problem with customized dashboard and SAP support suggested to post the request here, hopefully someone has an idea:

Scenario:

Design the dashboard as per the guide from Yatsea Li "Creating New Dashboard Packages for SAP

Business One 8.8", as a datasource use the stored procedure call with %-parameters in the query manager.

Actual result:

In the testing mode Xcelsius returns the error message:

An error has occurred.

For more information, contact the file creator or your system administrator.

Error: Error #2032

Connection Type: XML Data

In the same time B1if logs shows the following exceptions:

IPO Step / Time Stamp / Error Description

=

/vP.001sap0004.in_HCSX/com..../vP.001sap0004.in_HCSX/com.sap.b1i.vplatform.runtime/INB_HT_CALL_SYNC_XPT/INB_HT_CALL_SYNC_XPT.ipo/ErrorHandler

= 20110519002115

= com.sap.b1i.xcellerator.Xce...com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested

exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception:

com.sap.b1i.utilities.UtilException: UTE001 Nested exception:

com.sap.engine.lib.xml.parser.ParserException: = expected in attlist(:main:, row:28, col:1929)

=

/vP.001sap0004.in_HCSX/com..../vP.001sap0004.in_HCSX/com.sap.b1i.vplatform.runtime/INB_HT_CALL_SYNC_XPT/INB_HT_CALL_SYNC_XPT.ipo/proc

= 20110519002115

= com.sap.b1i.xcellerator.Xce...com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested

exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception:

com.sap.b1i.utilities.UtilException: UTE001 Nested exception:

com.sap.engine.lib.xml.parser.ParserException: = expected in attlist(:main:, row:1, col:1950)

Dashboard is setup properly, verified and tested and there is no any issues with this, as simply

changing the query from the EXEC to dummy SELECT statement eliminates the issue. Replacing the EXEC

with SELECT is not an option as we are talking about the complicated SQL logic for the financial module, thus the stored procedure call is the only option here.

In the MSSQL profiler we see the SP call with the right parameter values, again it means the

dashboard setup is correct.

'Declare' statement is not used in the query as suggested by the SAP Note 1536078. The query is

EXEC [dbo].[MySP] '[%0]', '[%1]'

Expected result:

Dashboard should work the same way regardless this is simple SELECT statementor SP call.

B1 - 8.81 PL05

B1if - latest

Xcelsius - 5.3.5.0

Thanks in advance!

Not what you were looking for? View more on this topic or Ask a question