ODBC problem when I load more than six columns in the sql select

[#1]

Hi everybody,

I've a problem in my request, it works without problem in sql devlopper, but in QV, it returns a ODBC problem, but when I reduce the number of columns loaded in the sql select to six, it works, has anybody meet this problem befor?

FI: I use the version 9.

Here you are my script fot this request:

load

//  "SAPLIGCOM_IDEODSART",

//  "SAPPTFCOM_NUMCOM",

  "ODSREFTPSJOU_DAT",

  "SAPPTFCOM_IDEODSART",

  "SAPPTFCOM_NUMCOM",

  "SAPPTFCOM_QTECOM",

  "SAPPTFCOM_MNTPST",

  "SAPPTFCOM_QTECON",

  "SAPPTFCOM_QTECOM"-"SAPPTFCOM_QTECON" as QT_RUPT;

SQL SELECT "SAPPTFCOM_QTECOM", "SAPPTFCOM_MNTPST", "SAPPTFCOM_QTECON","SAPPTFCOM_NUMCOM","SAPPTFCOM_IDEODSART","ODSREFTPSJOU_DAT"/*,"SAPLIGCOM_IDEODSART","SAPPTFCOM_NUMCOM",*/

FROM SAP_LIGCOM,ODS_REFTPS_JOU,SAP_PTFCOM,SAP_MAG

//where ODS_REFTPS_JOU.ODSREFTPSJOU_DAT between to_date('20/11/2012','DD/MM/YYYY') and sysdate

where ODS_REFTPS_JOU.ODSREFTPSJOU_DAT=to_date('22/11/2012','DD/MM/YYYY')

and ODS_REFTPS_JOU.ODSREFTPSJOU_IDE=SAP_PTFCOM.SAPPTFCOM_IDEODSDATPTF

and SAP_LIGCOM.SAPLIGCOM_IDEODS=SAP_PTFCOM.SAPPTFCOM_IDEODSLIGCOM

and SAP_LIGCOM.SAPLIGCOM_IDEODSMAG=SAP_MAG.SAPMAG_IDEODS

and SAP_LIGCOM.SAPLIGCOM_IDEODSDATCOM=ODS_REFTPS_JOU.ODSREFTPSJOU_IDE

and SAP_LIGCOM.SAPLIGCOM_IDEODSDIV=8

and SAP_LIGCOM.SAPLIGCOM_CODSTALIVCOM in ('A','B')

and (SAP_LIGCOM.SAPLIGCOM_CODSTACRE is null or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='A' or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='D')

and SAP_LIGCOM.SAPLIGCOM_IDEODSRAIREJCOM=1

and SAP_LIGCOM.SAPLIGCOM_IDEODSBLOLIV not in (20,22,23,24,48483)

and SAP_LIGCOM.SAPLIGCOM_IDEODSCANDIS in (15,16)

and (SAPMAG_CODMAG like 'MY%' or sapmag_codmag like 'A%' or sapmag_codmag like 'S%')

and SAP_PTFCOM.SAPPTFCOM_QTECON < SAP_PTFCOM.SAPPTFCOM_QTECOM;

Thanks you.

ZM

[#2]

No, it's the correct column name, my request works in sql devlopper :s

[jvitantonio]

Could you please try loading one field at a time and check if any of them throw an error?

[Gysbert_Wassenaar]

23/11/2012 10:42:28: 0026  SQL SELECT SAP_LIGCOM.SAPPTFCOM_NUMCOM,

According to the log you were asking for the field SAP_LIGCOM.SAPPTFCOM_NUMCOM. That was probably a typo, since there is not field called SAPPTFCOM_NUMCOM in table SAP_LIGCOM. I think you meant to select the field from SAP_PTFCOM instead: SAP_PTFCOM.SAPPTFCOM_NUMCOM.

[#5]

Yes I agree, I'm sorry I've loaded the wrong script,

The log is:

23/11/2012 13:56:45:      Début de l'exécution

23/11/2012 13:56:45:      QlikView Version:9.00.7502.8

23/11/2012 13:56:45: 0002  SET ThousandSep=' '

23/11/2012 13:56:45: 0003  SET DecimalSep=','

23/11/2012 13:56:45: 0004  SET MoneyThousandSep=' '

23/11/2012 13:56:45: 0005  SET MoneyDecimalSep=','

23/11/2012 13:56:45: 0006  SET MoneyFormat='# ##0,00 €;-# ##0,00 €'

23/11/2012 13:56:45: 0007  SET TimeFormat='hh:mm:ss'

23/11/2012 13:56:45: 0008  SET DateFormat='DD/MM/YYYY'

23/11/2012 13:56:45: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

23/11/2012 13:56:45: 0010  SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.'

23/11/2012 13:56:45: 0011  SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.'

23/11/2012 13:56:45: 0013  CONNECT*Provider*XPassword*

23/11/2012 13:56:45: 0017  load "SAPMAG_CODMAG",

23/11/2012 13:56:45: 0018    "SAPLIGCOM_NUMCOM",

23/11/2012 13:56:45: 0019    "SAPLIGCOM_IDEODSBLOLIV",

23/11/2012 13:56:45: 0020    "SAPLIGCOM_CODSTAREJCOM",

23/11/2012 13:56:45: 0021    "SAPLIGCOM_CODSTACRE",

23/11/2012 13:56:45: 0022    "SAPLIGCOM_CODSTALIVCOM",

23/11/2012 13:56:45: 0023    "SAPLIGCOM_IDEODSDIV",

23/11/2012 13:56:45: 0024    "SAPLIGCOM_IDEODSRAIREJCOM",

23/11/2012 13:56:45: 0025    "SAPLIGCOM_IDEODS",

23/11/2012 13:56:45: 0026    "SAPLIGCOM_IDEODSDATLIVSOU",

23/11/2012 13:56:45: 0027    "SAPLIGCOM_IDEODSART",

23/11/2012 13:56:45: 0028    "SAPLIGCOM_IDEODSMAG",

23/11/2012 13:56:45: 0029    "SAPPTFCOM_NUMCOM",

23/11/2012 13:56:45: 0030    "SAPPTFCOM_IDEODSCANDIS",

23/11/2012 13:56:45: 0031    "SAPPTFCOM_MNTBLO",

23/11/2012 13:56:45: 0032    "ODSREFTPSJOU_DAT",

23/11/2012 13:56:45: 0033    "SAPPTFCOM_IDEODSART",

23/11/2012 13:56:45: 0034    "SAPPTFCOM_NUMCOM",

23/11/2012 13:56:45: 0035    "SAPPTFCOM_IDEODSDATPTF",

23/11/2012 13:56:45: 0036    "SAPPTFCOM_IDEODSLIGCOM",

23/11/2012 13:56:45: 0037    "SAPPTFCOM_QTECOM",

23/11/2012 13:56:45: 0038    "SAPPTFCOM_MNTPST",

23/11/2012 13:56:45: 0039    "SAPPTFCOM_QTECON",

23/11/2012 13:56:45: 0040    "SAPPTFCOM_QTECOM"-"SAPPTFCOM_QTECON" as QT_RUPT

23/11/2012 13:56:45: 0041  SQL SELECT "SAPMAG_CODMAG","SAPLIGCOM_NUMCOM","SAPLIGCOM_IDEODSBLOLIV","SAPLIGCOM_CODSTAREJCOM","SAPLIGCOM_CODSTACRE","SAPLIGCOM_CODSTALIVCOM","SAPLIGCOM_IDEODSDIV","SAPLIGCOM_IDEODSRAIREJCOM","SAPLIGCOM_IDEODS","SAPLIGCOM_IDEODSDATLIVSOU","SAPLIGCOM_IDEODSART", "SAPLIGCOM_IDEODSMAG","SAPPTFCOM_NUMCOM","SAPPTFCOM_IDEODSCANDIS","SAPPTFCOM_MNTBLO","ODSREFTPSJOU_DAT","SAPPTFCOM_IDEODSART","SAPPTFCOM_NUMCOM", "SAPPTFCOM_IDEODSDATPTF","SAPPTFCOM_IDEODSLIGCOM","SAPPTFCOM_QTECOM", "SAPPTFCOM_MNTPST", "SAPPTFCOM_QTECON"

23/11/2012 13:56:45: 0042  FROM SAP_LIGCOM,ods_reftps_jou,SAP_MAG,SAP_PTFCOM

23/11/2012 13:56:45: 0043  where ods_reftps_jou.odsreftpsjou_dat between to_date('20/11/2012','DD/MM/YYYY') and sysdate

23/11/2012 13:56:45: 0044  and odsreftpsjou_ide=SAPPTFCOM_IDEODSDATPTF

23/11/2012 13:56:45: 0045  and SAPLIGCOM_IDEODS=SAPPTFCOM_IDEODSLIGCOM

23/11/2012 13:56:45: 0046  and SAPLIGCOM_IDEODSMAG=SAPMAG_IDEODS

23/11/2012 13:56:45: 0047  and SAP_LIGCOM.SAPLIGCOM_IDEODSDATCOM=ods_reftps_jou.odsreftpsjou_ide

23/11/2012 13:56:45: 0048  and "SAPLIGCOM_IDEODSDIV"=8

23/11/2012 13:56:45: 0049  and "SAPLIGCOM_CODSTALIVCOM" in ('A','B')

23/11/2012 13:56:45: 0050  and ("SAPLIGCOM_CODSTACRE" is null or "SAPLIGCOM_CODSTACRE"='A' or "SAPLIGCOM_CODSTACRE"='D')

23/11/2012 13:56:45: 0051  and "SAPLIGCOM_IDEODSRAIREJCOM"=1

23/11/2012 13:56:45: 0052  and "SAPLIGCOM_IDEODSBLOLIV" not in (20,22,23,24,48483)

23/11/2012 13:56:45: 0053  and "SAPLIGCOM_IDEODSCANDIS" in (15,16)

23/11/2012 13:56:45: 0054  and (SAPMAG_CODMAG like 'MY%' or sapmag_codmag like 'A%' or sapmag_codmag like 'S%')

23/11/2012 13:56:45: 0055  and sap_ptfcom.sapptfcom_qtecon < sap_ptfcom.sapptfcom_qtecom

23/11/2012 13:56:49:        24 champs trouvés: SAPMAG_CODMAG, SAPLIGCOM_NUMCOM, SAPLIGCOM_IDEODSBLOLIV, SAPLIGCOM_CODSTAREJCOM, SAPLIGCOM_CODSTACRE, SAPLIGCOM_CODSTALIVCOM, SAPLIGCOM_IDEODSDIV, SAPLIGCOM_IDEODSRAIREJCOM, SAPLIGCOM_IDEODS, SAPLIGCOM_IDEODSDATLIVSOU, SAPLIGCOM_IDEODSART, SAPLIGCOM_IDEODSMAG, SAPPTFCOM_NUMCOM, SAPPTFCOM_IDEODSCANDIS, SAPPTFCOM_MNTBLO, ODSREFTPSJOU_DAT, SAPPTFCOM_IDEODSART, SAPPTFCOM_NUMCOM, Erreur: Échec de lecture ODBC

23/11/2012 13:56:54:      Fin de l'exécution.