Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jatin333
New Contributor III

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 .

Tags (2)
5 Replies
Not applicable

Re: Extract cubes from sap bw into qlikview via sapolapconnector

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.

jatin333
New Contributor III

Re: Extract cubes from sap bw into qlikview via sapolapconnector

Hi Antony,

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

alokpande28
New Contributor II

Re: Extract cubes from sap bw into qlikview via sapolapconnector

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

jatin333
New Contributor III

Re: Extract cubes from sap bw into qlikview via sapolapconnector

Hi Alok Pande ,

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

Regards,

Kolhe Jatin.

Employee
Employee

Re: Extract cubes from sap bw into qlikview via sapolapconnector

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

Community Browser