Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My Client is using SAP 700. Wheather Qlikview SAP CONNECTOR 5.3 WILL SUPPORT THIS?
-Sathish
Sunil,
For ur reference log file :
09/20/10 10:50:41: Execution started.
09/20/10 10:50:41: QlikView Version:9.00.7440.8
09/20/10 10:50:41: 0002 SET ThousandSep=','
09/20/10 10:50:41: 0003 SET DecimalSep='.'
09/20/10 10:50:41: 0004 SET MoneyThousandSep=','
09/20/10 10:50:41: 0005 SET MoneyDecimalSep='.'
09/20/10 10:50:41: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
09/20/10 10:50:41: 0007 SET TimeFormat='h:mm:ss TT'
09/20/10 10:50:41: 0008 SET DateFormat='M/D/YYYY'
09/20/10 10:50:41: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
09/20/10 10:50:41: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
09/20/10 10:50:41: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
09/20/10 10:50:41: 0017 CUSTOMCONNECT*Provider*QvSAPConnector*XUserId*XPassword*
09/20/10 10:50:41: 0019 VBRK:
09/20/10 10:50:41: 0020 LOAD
09/20/10 10:50:41: 0021 MANDT,
09/20/10 10:50:41: 0022 VBELN,
09/20/10 10:50:41: 0023
09/20/10 10:50:41: 0024
09/20/10 10:50:41: 0025
09/20/10 10:50:41: 0026
09/20/10 10:50:41: 0027
09/20/10 10:50:41: 0028
09/20/10 10:50:41: 0029
09/20/10 10:50:41: 0030
09/20/10 10:50:41: 0031
09/20/10 10:50:41: 0032 FKDAT where year(FKDAT) > 2008
09/20/10 10:50:41: 0133 SQL Select * FROM VBRK
09/20/10 10:50:45: 3 fields found: MANDT, VBELN, FKDAT, Error: Custom read failed
09/20/10 10:51:52: 0134 STORE VBRK INTO D:\QV-Project\MB_SCM\Qvd\SalesPipelineQvd\VBRK.qvd
09/20/10 10:51:52: 0135 DROP TABLE VBRK
09/20/10 10:51:52: 0136 EXIT SCRIPT
09/20/10 10:51:52: Execution finished.
pls try this onr in where condition
where FKDAT > 20080101
Sunil,
Ya I tried but same error
-Sathish
pls try
where fkdat> '20080101' order by fkdat;
SUNIL,
I Think syntax is not a problem. Because if i give year(FKDAT) > 2005 ITS LOADING UPTO 7000 ROWS AFTER THAT CUSTOM ODBC FAILED.
pls use attached tool for extraction by change change connection string. It help you lot.
I want to know one thing for custom odbc failed.
what is data size . I mean data of no .of year in SAP.
Sunil,
Really Very Very Thaks for ur Help!!!!
In that table having 1998 to 2010 Year data. after 2008 means 2009 and 2010 around 3 L .
But this sap extractoR also shows Custom ODBC cONNECTION FAILED....
-sATHISH
pls check through DBA regarding whether data after 2008 is archived or what ?.
also check through your SAP Basis team. i think SAP Connector is unable to read data from 2008 . so may be is there any internal problem in this table.
Sathish , what abt other table LIKP,LIPS,VBAP,VBAK,VBFA .....................
same thing happening with other table or what ?.
Dear All,
I am also facing the same problem,but not for same tables.
any clue on this problem.
Regards,
Santhosh Kumar G
Dear Santosh,
Can you post more details on the issue you are facing ?.
Regards
Sunil Jain