Skip to Content

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

BICS_PROV_GET_RESULT_SET returned an exception: INVALID_DATA_PROVIDER_HANDLE


Hello,


Did any one face a similar problem?


Business Objects Analysis for Excel dumps on Save Data in a Standard Input-ready query


Error when multiple rows of data is saved in Analysis. Works fine when a single row of data is saved.


Any pointers to find the probable cause are appreciated. Thanks.


Versions: BO Analysis for Excel Client (Version: 1.4.6)

Netweaver 7.3 SP 11

Steps:

Open a Standard delivered Input Ready query /ERP/COOM_A07_IRQ0001

In the Input template, enter values for multiple WBS Elements for a single period

Click on Save Data

Analysis Error occurred. Data is not saved.

Error Messages:

a) An exception occurred in one of the data sources.

SAP BI Add-in has disconnected all data sources.

If you want to restart, press the Restart button below. (ID-111006)

b) Nested exception. See inner exception below for more details:

Invalid program status\: RFC call BICS_PROV_GET_RESULT_SET returned an exception: INVALID_DATA_PROVIDER_HANDLE

Also, question on Analysis and Java.  Is BI-JAVA required for Bex queries to work on Analysis?


From what I gathered from scn, Java isn't a pre-requisite. However all the SAP Notes related to BO Analysis point to corrections or upgrade to BI-JAVA


Tags:
Former Member
Former Member replied

Hello Divya,

I think the issue you are facing is a different one.

SAP support found out that the error we ran into was due to an error a SAP Project Systems Program . They recommended  applying note 1894493.  It fixed the issue.

Thanks,

Vasu

0 View this answer in context

Helpful Answer

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