topic Re: Re: fetching Data From SAP in QlikView

fetching Data From SAP

Sat, 27 Sep 2014 04:48:23 GMT

What is the reason behind this error.When I fetched the data from SAP after establishing the connection

Re: fetching Data From SAP

Anonymous — Sat, 27 Sep 2014 05:48:34 GMT

hi,

after successful connection to sap,

write the code to fetch the tables like

Tablename:

SQL SELECT * from Tablename;
store Tablename into path Tablename.QVD;
drop Table Tablename;

Re: fetching Data From SAP

Anonymous — Sat, 27 Sep 2014 06:01:55 GMT

Please take a look at the connector logfile:

C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log

If you cannot solve the problem, please attach the log

Thanks

Yaniv

Re: fetching Data From SAP

Sat, 27 Sep 2014 06:10:35 GMT

I already done that , see the execution sript

SQL select GJAHR FROM COSP

Re: fetching Data From SAP

Anonymous — Sat, 27 Sep 2014 06:12:57 GMT

Hi,

you want to fetch the GJAHR from COSP table right ..??

for that

Tablename:

SQL SELECT * from Tablename where GJAHR = particular year;

Re: Re: fetching Data From SAP

Sat, 27 Sep 2014 06:16:27 GMT

PFA

Re: fetching Data From SAP

Anonymous — Sat, 27 Sep 2014 07:18:45 GMT

Can you please provide the script that you use?

Please try to execute the following command:

test:

SQL SELECT GJAHR from COSP ;

Re: fetching Data From SAP

Wed, 01 Oct 2014 06:06:09 GMT

what is the meaning of custom read failed while fetching the data from SAP

Re: fetching Data From SAP

Anonymous — Wed, 01 Oct 2014 09:38:39 GMT

It means that something went wrong in the SAP side (Short Dump or Error) that caused the extraction to fail.

You can try to check the contents of table: /QTQVC/TRACE on SAP side

Lookup the record which matches your extraction (according to field TIMESTAMP)

Maybe you will see something there

Re: fetching Data From SAP

Wed, 01 Oct 2014 11:51:29 GMT

in my application whenever i am doing extraction sometimes it throw an error message custom read failed

& sometimes run successfully

where we can see the TimeOutFetchParameter in Qlikview and how we can increase it

Re: fetching Data From SAP

Anonymous — Wed, 01 Oct 2014 12:05:51 GMT

Add the following parameter in the connection string in QlikView:

TimeOutFetch=n

Re: fetching Data From SAP

Mon, 06 Oct 2014 04:58:09 GMT

this is my SAP connection string:-

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=111.11.11.900;SYSNR=11;CLIENT=111;KeepCasing=1;NullDate=1;XUserId=JGJYaYRNJbaeFSFNBDbGE;XPassword=PSOaVDdNHScKWSZNRRMGTRA;";

plz tell where i have to add timeout fetch paramater

Re: fetching Data From SAP

Anonymous — Mon, 06 Oct 2014 05:37:30 GMT

Hi try like this

TableName:

SQL SELECT GJAHR from TableName;
store TableName into $(vSource)TableName.QVD;

drop Table TableName;

by using the above script we can retrieve the field GJAHR from the table....

Re: fetching Data From SAP

Mon, 06 Oct 2014 10:17:40 GMT

any idea??????????

Re: fetching Data From SAP

Anonymous — Mon, 06 Oct 2014 10:34:54 GMT

Please try this:

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=111.11.11.900;SYSNR=11;CLIENT=111;KeepCasing=1;NullDate=1;XUserId=JGJYaYRNJbaeFSFNBDbGE;XPassword=PSOaVDdNHScKWSZNRRMGTRA;TimeOutFetch=1800";

Re: fetching Data From SAP

Mon, 06 Oct 2014 12:02:00 GMT

I have used this connection string

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=111.11.11.900;SYSNR=11;CLIENT=111;TimeOutFetch=2000;KeepCasing=1;NullDate=1;XUserId=JGJYaYRNJbaeFSFNBDbGE;XPassword=PSOaVDdNHScKWSZNRRMGTRA;";

but it still throw the same error msg

even i tried with TimeOutFetch=20000 as well,but it won't work

Re: fetching Data From SAP

Peter_Cammaert — Mon, 06 Oct 2014 12:40:44 GMT

AFAIK you are getting errors way before your SQL statement is transmitted to SAP. I guess something in your setup is wrong. Your logs should at least mention something like

Creation of function /QTQVC/OPEN_STREAM returned ...

before you can be sure that a usable connection has been established. But there is nothing of the kind in your logs.

Check your connection parameters (use the Test button of the SAP Connector setup screen)

IMHO 111.11.11.900 is not a valid IP-adres. Can you use a hostname?

Peter

Re: fetching Data From SAP

Tue, 07 Oct 2014 04:23:32 GMT

When I created the connection I have already done test connection ,and it was successful ,I know

111.11.11.900 is not a valid IP , I edit before pasting in community in order hide the security of my client