Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract cubes from sap bw into qlikview via sapolapconnector

I am fetching cubes data via sapolapconnector and storing them as qvd,but when i try to fetch cubes of large number of rows(above 1 million) my qvw file gets hanged.I am getting "custom read failed" error .I searched for the solution and found some solutions which said that buffer size is less,so the problem arises.But i am not understanding how to change it or is there any other solution for it.I know we can also do it using qvsapconnector ,but can you please suggest me how to do it .

5 Replies
Not applicable
Author

hi Jatin,

       did u find answer above issue ?? even i am also facing the same issue... if u know then please tell me.

Regards,

Antony.

Anonymous
Not applicable
Author

Hi Antony,

I used sap connector instead of sap olap connector since there was limitation of rows on it.

Anonymous
Not applicable
Author

Dear Jatin,

I think the Buffer Size can be increase from the SAP Server by SAP Team.

there is no any settings where you can set the buffer into QlikView.

Regards,

Alok

Anonymous
Not applicable
Author

Hi Alok Pande ,

Can you confirm this from any document or your personal experience ?

Regards,

Kolhe Jatin.

nam
Former Employee
Former Employee

Hi the custom read fail is not a sap error its usually a qlikview error, when the records that you are trying to extract exceed the max rows in your connection string.

CUSTOM CONNECT TO "Provider=QvSAPDSOConnector.dll;ASHOST=00.00.00.00;SYSNR=10;CLIENT=800;ODSMaxRows=10000000;XUserId=SGDIdYZODLdGXSJObF;XPassword=ULeXUYRNJbaMXUVMXDJA;";

change the ODSMaxRows to a bigger value.

Just to test this theory set the ODSMaxRows=10000 and debug with a limited load of 5000 so not to exceed your 10,000 limit and if this is successful then the ODSMaxRow limit is your issue

Now if you get a different error such as 'File Exdata.cpp' this is related to SAP and there is not enough buffer in sap to complete your request, so either try and break your query in smaller chunk based on some field or get SAP to increase the available buffer for you